Database Manager

The Database Manager inside the Site Control Panel provides an effective yet convenient–to–use interface. You can easily set up a whole new MySQL or PostgreSQL database by just typing a user name and password. Also, you could make a backup file or change the password of the database with only a click of the mouse.

From the Database Manager you have direct access to the administrator area for all your databases, so you’re able to make quick adjustments when you have to.

We’ve designed the manual database back–up formation into a quite simple task. To do this: inside the Database Manager, click on the ’clock’ image beside the database that you would like to back up and after that wait around for a couple of seconds for the backup process to take place. With respect to the size of the database, the creation of a back–up file will need somewhere between a few seconds and a minute.

You can make as many copies per database as you want. We have not set any limits about the quantity of databases you can back up either.

Nearly all of the cloud hosting plans plans grant PgSQL support. While falling behind MySQL with regard to popularity and usage, PgSQL databases are famous for delivering the best level of safety for your website content material. It is the basic reason why companies like Skype and Yahoo employ PgSQL databases as opposed to MySQL.

When considering database management, PgSQL is as simple and easy as MySQL.

We have integrated InnoDB – the new default MySQL database engine on every one of our web servers. InnoDB is ideal for substantial database web sites that need high levels of overall performance and scalability. Tests have shown that sites using InnoDB based tables attain a 3–fold effectiveness increase for large joins, when compared to those employing MyISAM tables.

InnoDB takes advantage of row–level locking as a way to get rid of the efficiency problems observed at the high usage times of the previous release of the database engine – MyISAM, which employs table–level locking.

We offer you an easy approach to keep an eye on the database consumption on your active web sites. From your descriptive database stats user interface, that is incorporated into the Site Control Panel, you’ll be able to track the load generated by your active sites in real time. The delivered data will let you evaluate the database load changes per hour, each day or each month.

It’s possible to keep track of the database load for your sites in the Database Stats portion of the Site Control Panel. The table on–screen reveals the database lookups generated in the present month. To take a look at info for a past month, click on the back arrows located at the top.