Database Manager

Database management may appear like a difficult job to unskilled web hosting users, however with our Database Manager, it’s actually relatively easy! To create a new database, you only ought to provide the username and password. Database backups are simply a mouse click away at the same time.People that choose to look into their databases and then change them may use the phpMyAdmin and phpPgAdmin tools.

We’ve made the manual database back–up creation into a quite simple job. To execute that: within the Database Manager, click the ’clock’ icon beside the database that you intend to back up and afterwards hang on for a few seconds for the process to take place. With respect to the size of your database, the generation of the backup file will take between a few seconds and a minute.

You may create as many backups of a database as you would like. We’ve not specified any boundaries on the number of databases that you can back up too.

Nearly all of our Linux cloud hosting bundles feature PgSQL support. Although falling behind MySQL with respect to global recognition and application, PgSQL databases are famous for providing the top level of safety for your website content material. It is the main reason why businesses like Skype and Yahoo make use of PgSQL databases as an alternative to MySQL.

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

We’ve set up InnoDB – the new default MySQL database engine on each of our servers. InnoDB is great for large database web sites that require high overall performance and scalability. Trials demonstrate that web sites using InnoDB based tables attain a 3–fold general performance grow for huge joins, as compared to those making use of MyISAM tables.

InnoDB utilizes row–level locking so as to clear away the general performance difficulties observed at the high usage times of the previous variant of the database engine – MyISAM, which utilizes table–level locking.

Monitoring the load caused by the databases in your busy website assists you to prevent all overload troubles that can slow it down and chase away website visitors. For this reason, we’ve bundled a in–depth Database Stats tool into the Web Site Control Panel. There you can get all–encompassing information about the inbound requests to your databases for each hour, day and month.

Depending on the number of daily and by the hour queries, it will be easier to find out what databases are employed the most as well as take procedures to optimize their work.