Databases Manager

Supervising your databases is much easier than ever, thanks to the Site Control Panel interface for MySQL and PgSQL administration! Even though you may not have substantial knowledge in handling databases, it will be easy to use the Databases Manager.

You could make a brand new database simply by entering the user name and security password or produce a database back–up with just a mouse click. Likewise, within the Data Manager you have direct access to the admin area for every single database, which means you can almost instantly manage it.

We’ve evolved the manual database backup formation into a quite easy job. To execute this: in the Databases Manager, click the ’clock’ icon beside the database that you want to back up and then wait for a few seconds for the process to take place. With regards to the size of your database, the creation of the back–up file will require somewhere between a few seconds and a minute.

You can create as many copies of a database as you desire. We haven’t specified any limitations on the quantity of databases that you can back up as well.

A lot of our Linux cloud web hosting packages bundles present PgSQL support. Although dropping behind MySQL when it comes to acceptance and usage, PgSQL databases are famous for providing the maximum level of safety for your site content and articles. That is the basic reason why businesses like Skype and Yahoo rely on PgSQL databases as opposed to MySQL.

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

The MySQL databases on our servers utilize the most current release of the InnoDB storage engine. InnoDB is built to ensure the top effectiveness for sites that process sizeable amounts of data. It boasts CPU performance that could not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives full transaction support, meaning that you can update/insert/create/alter/drop a couple of times for a single "operation" of your application. Moreover, it uses row–level locking as an alternative for MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

Keeping tabs on the load produced by the databases within your dynamic site will let you reduce any sort of overload difficulties that might slow it down and ward off site visitors. For that reason, we have built in a detailed Database Stats tool directly into the Site Control Panel. There you shall find extensive info about the incoming requests to your databases for each hour, day and month.

In line with the quantity of day–to–day and per hour queries, you will be able to find out what databases are utilized the most and then consider procedures to optimize their load.