Database Manager

Overseeing your databases is easier than in the past, due to the Online Control Panel interface for MySQL and PgSQL administration! Even though you may not have extensive experience in managing databases, it will be an easy task to manage our Database Manager.

You could make a whole new database by only typing the username and security password or make a database back–up with just a mouse click. Likewise, with the Data Manager you will get direct access to the administrative area for every database, allowing you to immediately edit it.

We’ve designed the manual database backup formation into a quite simple task. To do this: in the Database Manager, click the ’clock’ icon on the side of the database that you plan to back up and afterwards wait around for a couple of seconds for the process to take place. With respect to the size of the database, the generation of the backup file will take between a couple of seconds and a minute.

You can create as many backup copies of a database as you wish. We haven’t determined any restrictions on the number of databases that you can back up either.

Most of the Linux cloud web hosting bundles provide PgSQL support. Although falling behind MySQL with regard to popularity and application, PgSQL databases are famous for offering the best level of stability for your website content material. That’s the reason why companies such as Skype and Yahoo go with PgSQL databases in lieu of MySQL.

With respect to database management, PgSQL is as quick as MySQL.

The MySQL databases on our web servers employ the most recent release of the InnoDB storage engine. InnoDB was created to ensure the maximum efficiency for websites that work with large volumes of data. It features CPU effectiveness that can not be matched by other different disk–based relational database engines.

InnoDB is ACID–compliant and gives 100% transaction support, meaning that you’re able to update/insert/create/alter/drop many times for a single "operation" of your application. Additionally, it utilizes row–level locking as an alternative for MyISAM’s table–level locking, that boosts multi–user concurrency and effectiveness.

Via the complete database statistics tool built–into the Online Control Panel, you are able to keep a record of the load generated by your dynamic web sites around the clock. Every single overload problem with your sites can slow the loading rates and have a damaging effect on the online experience of your respective website visitors. Hence, by having info for the database load instantly, it will be easier to fix overload troubles right away.

The database statistics interface displays info of the amount of daily, hourly and monthly lookups, meaning you can evaluate how the load is spread over various time frames.