Database Manager

Database management may sound like a difficult task to inexperienced web hosting clients, nevertheless with the Database Manager, it’s actually reasonably easy! To set up a whole new database, you simply have to provide your username and password. Database back–ups are a mouse click away on top of that.Those who would like to examine their databases as well as edit them can use the phpMyAdmin and phpPgAdmin tools.

We’ve transformed the manual database back–up creation into a very easy task. To execute that: inside of the Database Manager, click the ’clock’ image on the side of the database that you plan to back up and afterwards wait around for a few seconds for the process to take place. With respect to the size of the database, the building of the back–up file can take between a couple of seconds and a minute.

You can make as many backup copies of a database as you wish. We haven’t determined any limits for the number of databases you can back up as well.

PgSQL databases are much less widespread than the popular MySQL databases. Nevertheless, they are a favored alternative for programmers who are looking for the maximum stability for their web sites and applications. Due to the user–friendly Database Manager included in the 6xCloud Control Panel, you can administer all your PostgreSQL databases with merely a click of the mouse.

You are going to find PgSQL databases incorporated automatically inside of the top cloud web hosting packages. Assuming that you are using a standard hosting package, you are able to ask for PgSQL databases to be added to your account as upgrades.

We’ve set up InnoDB – the brand new default MySQL database engine on all of our servers. InnoDB is perfect for large database web sites which require high overall performance and scalability. Tests have established that web sites working with InnoDB based tables reach a 3–fold performance increase for massive joins, as compared to those making use of MyISAM tables.

InnoDB utilizes row–level locking in order to be able to get rid of the effectiveness difficulties witnessed at the top consumption times of the prior release of the database engine – MyISAM, which utilizes table–level locking.

Via the in depth database statistics tool built–into the Hosting Control Panel, it’s possible to keep tabs of the stress created from your dynamic sites at any hour. Any overload issue with your websites could slow the loading speeds and have a negative effect on the overall impression of your site visitors. Which means that, having details for the database work immediately, it is also possible to resolve overload problems as fast as possible.

The database data interface shows details of the quantity of daily, hourly and monthly queries, allowing you to examine how the load is distributed over several time periods.