Database Manager

Supervising your databases is simpler than ever before, as a result of Control Panel user interface for MySQL and PgSQL control! Even if you do not have substantial knowledge of working with databases, you will find it an easy task to manage the Database Manager.

You could make a brand new database by only keying in the username and password or create a database backup with a click of the mouse. Furthermore, through the Data Manager you will have direct access to the admin area for every database, so you’re able to conveniently modify it.

We have transformed the manual database backup generation into a simple job. To do this: inside of the Database Manager, click on the ’clock’ image near the database that you intend to back up and then wait around for a couple of seconds for the backup process to take place. Depending upon the size of your database, the creation of the backup file will require between a couple of seconds and a minute.

You may make as many back–ups per database as you desire. We’ve not determined any restrictions on the amount of databases you can back up either.

Most of our Linux web hosting plans feature PgSQL support. While falling behind MySQL in terms of acceptance and usage, PgSQL databases are famous for offering the maximum level of stability for your site content material. That is the reason why companies such as Skype and Yahoo employ PgSQL databases and not MySQL.

With respect to database administration, PgSQL is as easy to use as MySQL.

We have integrated InnoDB – the new standard MySQL database engine on each of our machines. InnoDB is perfect for significant database web sites that require high levels of effectiveness and scalability. Tests have shown that sites employing InnoDB based tables achieve a 3–fold general performance increase for large joins, as compared with those employing MyISAM tables.

InnoDB works by using row–level locking as a way to take away the operation problems witnessed at the top usage times of the prior version of the database engine – MyISAM, which uses table–level locking.

Through the comprehensive database stats tool built into the Control Panel, it is possible to keep tabs of the stress created by your active web sites 24 / 7. Virtually any overload difficulty with your sites can lower the loading rates and have a damaging influence over the overall experience of your website visitors. So, having details for the database load in real time, it will be easier to resolve overload problems as quickly as possible.

The database data user interface shows data of the amount of daily, hourly and monthly queries, which means you can analyze the way the load is allocated over various time periods.