Database Manager

The Database Manager in the Hosting Control Panel contains a robust but still intuitive interface. You are able to set up a brand new MySQL or PostgreSQL database by just entering a user name and password. Additionally, you can create a backup file or change the password of the database with merely a mouse click.

From the Database Manager you’ve got direct access to the administration area for every one of your databases, which enables you to make simple and easy adjustments if you ever have to.

Via the Database Manager you are able to generate an archived backup of your database anytime you need! That way, you are going to always have a back–up of your dynamic content material in case your web site gets hacked or you mistakenly eliminate a database. To make a back–up: click the ’clock’ image next to a particular database and then just wait for a couple of seconds for the process to be executed.

There are no restricts on the number of databases you would be able to back up or the volume of backups you can make for any database.

Almost all of ITMax Hosting’s Linux cloud hosting plans deliver PgSQL support. While falling behind MySQL when considering popularity and usage, PgSQL databases are famous for supplying the highest level of safety for your web site content. That is the reason why companies such as Skype and Yahoo rely upon PgSQL databases and not MySQL.

When considering database management, PgSQL is equally uncomplicated as MySQL.

The MySQL databases on our web servers use the most current version of the InnoDB storage engine. InnoDB is created to guarantee the highest efficiency for websites that operate with massive volumes of data. It offers CPU effectiveness that can not be matched by any other disk–based relational database engines.

InnoDB is ACID–compliant and gives complete transaction support, which means that it is easy to update/insert/create/alter/drop many times for a single "operation" of your application. Furthermore, it uses row–level locking as an alternative to MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

Keeping tabs on the load produced by the databases for your dynamic website assists you to prevent any kind of overload issues that could slow it down and ward off website visitors. For this reason, we have incorporated a detailed Database Stats tool in the Hosting Control Panel. There you can get thorough information on the arriving requests to your databases for each hour, day and month.

Depending on the number of day–to–day and hourly queries, it will be easy to find out what databases are utilized the most as well as consider steps to enhance their load.