Database Manager

Overseeing your databases is easier than in the past, on account of the Control Panel user interface for MySQL and PgSQL management! Even though you may not have considerable knowledge in utilizing databases, it will be effortless to work with AJs Web Hosting’s Database Manager.

You could make a completely new database by simply specifying the user name and password or produce a database back–up with a simple click of the mouse. Additionally, within the Data Manager you have direct access to the management area for each individual database, allowing you to conveniently edit it.

We have changed the manual database back–up creation into a quite easy task. To do this: within the Database Manager, click the ’clock’ icon beside the database that you intend to back up and then wait around for a couple of seconds for the process to take place. Depending on the size of the database, the generation of any back–up file can take between a couple of seconds and a minute.

You may create as many copies of a database as you want. We haven’t specified any boundaries on the volume of databases you could back up as well.

PgSQL databases are much less famous in comparison to the widespread MySQL databases. On the other hand, they are a preferred selection for web developers who are looking for the ultimate protection for their websites and applications. Due to the intuitive Database Manager integrated into the AJs Web Hosting Control Panel, you can administer all of your PostgreSQL databases with just a click of the mouse.

You can find PgSQL databases included automatically inside of the top Linux cloud hosting packages packages. Assuming that you are with a regular hosting package, you can easily ask for PgSQL databases to be included in your web hosting account as upgrades.

With AJs Web Hosting, you will always discover the most up–to–date version of MySQL as well as the default MySQL storage engine – InnoDB, set up.

InnoDB is more reliable in comparison to the past storage engine’s version – MyISAM. It’s ACID–compliant and, most importantly – it provides total transaction support. What’s more, it utilizes row–level locking, instead of MyISAM’s table–level locking, that used to lead to efficiency issues at peak usage occasions.

Checking the load made by the databases on your active site makes it possible to prevent any sort of overload difficulties that can slow it down and chase away visitors. Therefore, we’ve bundled a comprehensive Database Stats tool into your Control Panel. There you will find broad info on the incoming requests to your databases for every hour, day and month.

Based on the amount of daily and hourly queries, you’re going to be able to determine which databases are utilized the most and take procedures to enhance their load.