Databases Manager

The Databases Manager within our Control Panel comes with an effective yet straightforward user interface. You can easily configure a brand new MySQL or PostgreSQL database simply by specifying a user name and password. Additionally, you could make a back–up file or customize the security password of your database with a mouse click.

Via the Databases Manager you have immediate access to the administrator area for all of your databases, so you can make effortless corrections if you ever need to.

We have evolved the manual database back–up formation into a simple task. To do this: inside of the Databases Manager, click on the ’clock’ icon beside the database that you plan to back up and after that wait around for a couple of seconds for the backup process to take place. Depending upon the size of the database, the building of the backup file will take between a few seconds and a minute.

You may create as many back–ups per database as you would like. We’ve not specified any boundaries for the amount of databases that you can back up as well.

You will find PgSQL support in all our Linux cloud web hosting plans. PgSQL databases might not be as sought after and frequently used as MySQL, but they provide the top level of security for your web site content and articles. For this reason, several famous businesses like Skype and Yahoo take advantage of PgSQL databases. Maintaining PgSQL databases is as easy as MySQL, as a result of the easy–to–use user interface of the Databases Manager.

PgSQL databases are integrated automatically with the most sophisticated web hosting packages. For the regular bundles, they’re included as upgrades.

With AtmoVantage, you’ll regularly discover the most recent variant of MySQL as well as the default MySQL storage engine – InnoDB, set up.

InnoDB is more stable as compared to the past storage engine’s edition – MyISAM. It’s ACID–compliant and, best of all – it includes full transaction support. Furthermore, it works by using row–level locking, instead of MyISAM’s table–level locking, that would always result in efficiency issues at high usage periods.

Keeping track of the load accumulated by the databases for your busy website will let you stop any kind of overload issues that might slow it down and ward off site visitors. For that reason, we’ve bundled a in–depth Database Stats tool directly into the Control Panel. There you can get detailed information about the incoming requests to your databases for every single hour, day and month.

Depending on the quantity of day–to–day and hourly queries, you are going to be able to find out what databases are used the most and then consider measures to optimize their load.