Databases Manager

Administering your databases is easier than in the past, due to the Website Control Panel interface for MySQL and PgSQL control! Even if you do not have detailed knowledge in working with databases, you will find it an easy task to deal with our Databases Manager.

You can create a new database just by typing the username and password or create a database backup with simply a mouse click. In addition, within the Data Manager you’ll get direct access to the administration area for every database, meaning you can quite easily edit it.

Through the Databases Manager it’s possible to generate an archived copy of your database when you desire! For this reason, you’ll always have a backup of your active content material in the event your website gets hacked or you mistakenly eliminate a database. To make a back–up: click on the ’clock’ image on the side of a given database and then wait for a few seconds for the process to be done.

There won’t be any limitations for the volume of databases you would be able to back up or the amount of back–ups you may make for a database.

You are going to find PgSQL support in all our cloud hosting offers. PgSQL databases are not as sought after and widely used as MySQL, nevertheless they provide the best level of stability for your site content. Due to this, many popular businesses like Skype and Yahoo make use of PgSQL databases. Taking care of PgSQL databases is as easy and simple as MySQL, on account of the incredibly user–friendly user interface of the Databases Manager.

PgSQL databases are incorporated automatically within the most sophisticated web hosting bundles. For the normal bundles, they’re included as upgrades.

The MySQL databases on our machines use the most current build of the InnoDB storage engine. InnoDB has been built to ensure the max effectiveness for sites that operate with significant amounts of data. It features CPU performance that can not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants full transaction support, which means you’re able to update/insert/create/alter/drop many times for a single "operation" of your web app. Moreover, it utilizes row–level locking and not MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

Keeping track of the load produced by the databases within your active site assists you to avoid any sort of overload problems that might slow it down and chase away visitors. For this specific purpose, we’ve provided a in–depth Database Stats tool into the Website Control Panel. There you shall find extensive info about the arriving requests to your databases for every single hour, day and month.

In line with the volume of daily and hourly queries, it will be straightforward to find out what databases are being used the most as well as consider procedures to enhance their work.