Database Manager

The Database Manager within our Site Control Panel comes with a robust nevertheless convenient user interface. It is easy to set up a new MySQL or PostgreSQL database simply by typing in a username and password. Moreover, you could make a back–up file or change the security password of a database with just a mouse click.

Through the Database Manager you’ll have immediate access to the administrator area for every one of your databases, so you’re able to make easy changes in the event you have to.

From the Database Manager you are able to make an archived duplicate of your database when you need! Therefore, you will always have a backup of your active content in the event your site gets hacked or if you erroneously remove a database. To make a backup: click the ’clock’ icon next to a given database and after that simply wait for a few seconds for the process to be completed.

There are not any limits on the volume of databases you would be able to back up or the amount of backup copies you can create for a database.

PgSQL databases are much less common compared to the common MySQL databases. Nevertheless, they are a favored choice for developers who seek the best protection for their web sites and web applications. Through the easy–to–use Database Manager built into the Advanceinternetwork.com Control Panel, you can control your PostgreSQL databases with a click of the mouse.

You can find PgSQL databases incorporated automatically inside the best cloud web hosting plans packages. Provided that you are with a basic hosting package, you can easily request PgSQL databases to be added in your account as upgrades.

With Advanceinternetwork.com, you shall regularly discover the most recent edition of MySQL as well as the default MySQL storage engine – InnoDB, set up.

InnoDB is far more secure compared to the old storage engine’s edition – MyISAM. It’s ACID–compliant and, best of all – it includes 100% transaction support. What’s more, it utilizes row–level locking, rather than MyISAM’s table–level locking, that previously used to result in functionality troubles at high usage times.

Keeping tabs on the load accumulated by the databases on your active website assists you to avoid any overload issues that could slow it down and chase away website visitors. For this purpose, we’ve incorporated a in depth Database Stats tool inside the Site Control Panel. There you can get in–depth info about the inbound requests to your databases for each hour, day and month.

Using the quantity of day–to–day and by the hour queries, it will be easier to find out which databases are employed the most and also consider measures to enhance their load.