Databases Manager

Taking control of your databases is much easier than in the past, thanks to the Site Control Panel interface for MySQL and PgSQL control! Even though you may not have detailed expertise in utilizing databases, it will be easy to use the Databases Manager.

You can make a brand new database simply by keying in the user name and password or create a database backup with just a mouse click. Furthermore, via the Data Manager you will get direct access to the management area for each individual database, to help you to effectively alter it.

We’ve changed the manual database backup creation into a quite simple task. To do this: within the Databases Manager, click the ’clock’ symbol near the database that you plan to back up and wait for a few seconds for the backup process to take place. With regards to the size of the database, the creation of the backup file will require somewhere between a few seconds and a minute.

You may create as many backup copies of a database as you wish. We have not set any boundaries for the amount of databases you could back up as well.

You are going to find PgSQL support in all of our cloud website hosting packages bundles. PgSQL databases aren’t as well–known and widespread as MySQL, however they supply you with the greatest level of stability for your web site content. For this reason, a number of famous companies such as Skype and Yahoo utilize PgSQL databases. Controlling PgSQL databases is as simple and easy as MySQL, due to the intuitive interface of the Databases Manager.

PgSQL databases are incorporated by default in the most innovative web hosting bundles. For the normal packages, they are offered as upgrades.

We’ve integrated InnoDB – the brand new standard MySQL database engine on all our web servers. InnoDB is ideal for sizeable database web sites which need high levels of performance and scalability. Tests indicate that web sites using InnoDB based tables achieve a 3–fold functionality grow for big joins, as opposed to those employing MyISAM tables.

InnoDB takes advantage of row–level locking as a way to eliminate effectiveness difficulties observed at the high usage times of the previous version of the database engine – MyISAM, which uses table–level locking.

Through the in–depth database statistics tool integrated into the Site Control Panel, it’s possible to keep track of the stress created from your active web sites twenty–four hours a day. Virtually any overload trouble with your websites can reduce the loading rates and have a negative influence over the overall impression of your site visitors. Thus, by having information for the database load in real time, it will be straightforward to mend overload difficulties promptly.

The database stats interface reveals details of the amount of daily, hourly and monthly queries, so that you can assess the way the load is distributed over several time periods.