Databases Manager

The Databases Manager inside our Site Control Panel comes with an effective nevertheless uncomplicated interface. It is possible to configure a new MySQL or PostgreSQL database by just typing a username and password. Additionally, you can make a backup file or change the password of an database with only a mouse click.

Via the Databases Manager you’ve got immediate access to the administrator area for all your databases, allowing you to make convenient modifications if you happen to need to.

We have made the manual database backup formation into a very easy job. To do so: inside of the Databases Manager, click on the ’clock’ symbol beside the database that you plan to back up and then wait for a few seconds for the process to take place. With regards to the size of your database, the creation of the backup file can take between a couple of seconds and a minute.

You may create as many backup copies of a database as you desire. We have not determined any restrictions for the number of databases you can back up as well.

The majority of the shared hosting plans provide PgSQL support. While dropping behind MySQL regarding reputation and utilization, PgSQL databases are famous for providing the highest level of stability for your website content. That’s the primary reason why businesses like Skype and Yahoo use PgSQL databases as an alternative to MySQL.

When considering database management, PgSQL is equally quick as MySQL.

The MySQL databases on A Global Web Host’s machines work with the newest version of the InnoDB storage engine. InnoDB is developed to ensure the maximum effectiveness for web sites that deal with substantial volumes of data. It boasts CPU effectiveness that can not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, which means you can update/insert/create/alter/drop more than once for a single "operation" of your app. Furthermore, it makes use of row–level locking and not MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

Through the complete database statistics tool included in the Site Control Panel, it is possible to make a record of the stress produced from your dynamic websites around the clock. Any overload trouble with your websites could reduce the loading speeds and have a negative effect on the overall experience of your respective website visitors. Consequently, by having data for the database work instantly, it is also possible to mend overload difficulties at once.

The database stats user interface displays data of the amount of daily, hourly and monthly lookups, which enables you to examine how the load is distributed over several time frames.