Databases Manager

The Databases Manager inside our Site Control Panel contains an effective nevertheless easy to use user interface. It is easy to configure a whole new MySQL or PostgreSQL database simply by typing a user name and password. Additionally, you can create a backup file or modify the password of your database with just a click of the mouse.

Through the Databases Manager you’ve got direct access to the administration area for all your databases, which enables you to make easy changes in the event you need to.

From the Databases Manager you’re able to make an archived copy of your database whenever you want! That way, you’ll always have a data backup of your dynamic content material in the event your website gets hacked or you incorrectly delete a database. To make a back–up: click the ’clock’ image alongside a particular database and afterwards just wait for a few seconds for the backup process to be completed.

There aren’t any limitations for the amount of databases you are able to back up or the number of back–ups you can make for any database.

A lot of the hosting plans packages feature PgSQL support. Although dropping behind MySQL when considering reputation and employment, PgSQL databases are renowned for delivering the highest level of security for your site content material. This is the key reason why businesses like Skype and Yahoo rely on PgSQL databases rather than MySQL.

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

We’ve added InnoDB – the new default MySQL database engine on all our machines. InnoDB is good for significant database websites which require high levels of overall performance and scalability. Tests have revealed that sites working with InnoDB based tables achieve a 3–fold efficiency grow for substantial joins, when compared to those utilizing MyISAM tables.

InnoDB utilizes row–level locking in order to be able to get rid of the functionality issues discovered at the maximum usage times of the previous release of the database engine – MyISAM, which utilizes table–level locking.

Through the broad database statistics tool built–into the Site Control Panel, you are able to keep track of the load produced by your busy websites twenty–four hours a day. Every overload trouble with your web sites could slow the loading speeds and have a negative impact on the overall impression of your respective website visitors. Therefore, by having details about the database load instantly, it will be easy to fix overload problems quickly.

The database data user interface displays information of the volume of daily, hourly and monthly lookups, which enables you to assess how the load is distributed over various time frames.