Database Manager

The Database Manager in the Site Control Panel features a powerful nevertheless easy to navigate user interface. You can easily set up a brand new MySQL or PostgreSQL database by just typing in a username and password. Moreover, you can create a backup file or alter the security password of an database with just a mouse click.

Within the Database Manager you will get immediate access to the administrative area for all of your databases, in order to make effortless changes when you have to.

We have evolved the manual database back–up generation into a quite easy task. To execute this: inside the Database Manager, click the ’clock’ image near the database that you would like to back up and afterwards wait for a few seconds for the process to take place. With respect to the size of your database, the generation of any backup file will require between a few seconds and a minute.

You may create as many backups per database as you want. We haven’t specified any confines on the quantity of databases that you could back up too.

Most of the website hosting services plans feature PgSQL support. Although falling behind MySQL with regard to level of popularity and application, PgSQL databases are famous for delivering the greatest level of protection for your site content material. This is the main reason why brands like Skype and Yahoo go with PgSQL databases as a substitute for MySQL.

With regards to database administration, PgSQL is just as simple as MySQL.

We’ve set up InnoDB – the new default MySQL database engine on each of our machines. InnoDB is good for large database websites which require high performance and scalability. Experiments have indicated that websites utilizing InnoDB based tables reach a 3–fold efficiency grow for huge joins, when compared to those using MyISAM tables.

InnoDB utilizes row–level locking in an effort to take away the effectiveness problems found at the top usage times of the prior variant of the database engine – MyISAM, which uses table–level locking.

With the broad database stats tool included in the Site Control Panel, it will be possible to make a record of the load produced through your active sites round the clock. Any overload trouble with your sites could reduce the loading rates and have a bad influence over the overall experience of your respective visitors. So, by having data about the database load instantly, it will be possible to eliminate overload problems in a timely manner.

The database data interface shows details of the volume of daily, hourly and monthly queries, allowing you to review just how the load is distributed over various time periods.