Databases Manager

The Databases Manager in our Site Control Panel provides a refined yet intuitive interface. It is easy to configure a brand new MySQL or PostgreSQL database by just specifying a user name and password. In addition, you could make a backup file or alter the security password of a database with a click of the mouse.

Through the Databases Manager you’ll possess immediate access to the administrative area for each of your databases, so you can make quick alterations in the event you have to.

We’ve changed the manual database back–up formation into a quite easy job. To execute that: in the Databases Manager, click on the ’clock’ icon on the side of the database that you intend to back up and then hang on for a few seconds for the process to take place. Depending on the size of the database, the generation of any backup file can take between a few seconds and a minute.

You may make as many copies of a database as you desire. We haven’t fixed any limits for the quantity of databases that you can back up too.

You can find PgSQL support in all of our Linux hosting packages offers. PgSQL databases might not be as famous and widespread as MySQL, however they provide you with the best level of safety for your website content. For this reason, a lot of popular businesses like Skype and Yahoo use PgSQL databases. Maintaining PgSQL databases is as easy and simple as MySQL, because of the incredibly user–friendly user interface of the Databases Manager.

PgSQL databases are provided by default inside the most sophisticated web hosting bundles. For the regular plans, they are included as upgrades.

The MySQL databases on a4host’s servers employ the newest version of the InnoDB storage engine. InnoDB is intended to ensure the max functionality for websites that work with huge volumes of data. It boasts CPU effectiveness that could not be matched by other different disk–based relational database engines.

InnoDB is ACID–compliant and provides 100% transaction support, which means that you can easily update/insert/create/alter/drop many times for a single "operation" of your web app. Additionally, it employs row–level locking in contrast to MyISAM’s table–level locking, that increases multi–user concurrency and performance.

Checking the load generated by the databases for your dynamic web site makes it possible to stop all sorts of overload difficulties that could slow it down and chase away visitors. For this specific purpose, we’ve included a in depth Database Stats tool into your Site Control Panel. There you will find all–encompassing information on the incoming requests to your databases for every hour, day and month.

Based on the number of day–to–day and per hour queries, it is possible to find out which databases are employed the most and consider steps to enhance their work.