Databases Manager

Supervising your databases is much easier than before, thanks to the Hosting Control Panel interface for MySQL and PgSQL control! Even though you may not have substantial experience of handling databases, you will find it an easy task to manage CloudNEO’s Databases Manager.

You may create a new database by just keying in the username and password or produce a database back–up with a simple click of the mouse. Furthermore, within the Data Manager you will possess direct access to the administration area for each and every database, meaning you can quickly manage it.

From the Databases Manager it is easy to generate an archived backup of your database whenever you desire! Therefore, you will always have a data backup of your dynamic content in the event your web site gets hacked or if you mistakenly remove a database. To generate a backup: click the ’clock’ icon on the side of a certain database and after that wait for a few seconds for the backup process to be concluded.

There are no boundaries on the volume of databases you would be able to back up or the volume of backup copies you may make for a database.

You are going to find PgSQL support in all of our shared website hosting offers. PgSQL databases are not as popular and commonly used as MySQL, nevertheless they offer the best level of protection for your web site content. Because of this, a number of famous brands like Skype and Yahoo take advantage of PgSQL databases. Managing PgSQL databases is as easy as MySQL, on account of the user–friendly user interface of the Databases Manager.

PgSQL databases are provided by default inside of the most sophisticated web hosting packages. For the basic bundles, they’re suggested as upgrades.

We have set up InnoDB – the new standard MySQL database engine on each of our machines. InnoDB is great for huge database websites which require high performance and scalability. Experiments have demonstrated that web sites applying InnoDB based tables reach a 3–fold effectiveness increase for massive joins, in contrast to those utilizing MyISAM tables.

InnoDB makes use of row–level locking in an effort to clear away the functionality problems seen at the top consumption times of the earlier variant of the database engine – MyISAM, which uses table–level locking.

Monitoring the load caused by the databases in your dynamic site will help you stop all sorts of overload troubles that could slow it down and chase away visitors. Therefore, we’ve built–in a in–depth Database Stats tool directly into the Hosting Control Panel. There you shall find thorough information on the arriving requests to your databases for each hour, day and month.

Using the amount of daily and hourly queries, you are able to find out what databases are being used the most and consider actions to enhance their load.