Database Manager

Managing your databases is much easier than in the past, because of the Online Control Panel user interface for MySQL and PgSQL control! Even though you may not have extensive knowledge in making use of databases, it will be simple to manage the Database Manager.

You could make a brand new database merely by typing the user name and password or make a database backup with merely a click of the mouse. Moreover, through the Data Manager you will possess direct access to the administrative area for every single database, so that you can almost instantly modify it.

We have changed the manual database backup generation into a simple job. To execute that: in the Database Manager, click on the ’clock’ icon beside the database that you want to back up and wait for a couple of seconds for the backup process to take place. With respect to the size of your database, the building of a backup file can take somewhere between a couple of seconds and a minute.

You can create as many copies per database as you wish. We’ve not fixed any restrictions for the quantity of databases you could back up as well.

You are going to find PgSQL support in all our shared web hosting packages. PgSQL databases are not as popular and widely used as MySQL, nonetheless they supply the maximum level of safety for your site content and articles. Because of this, a number of well–known companies such as Skype and Yahoo use PgSQL databases. Controlling PgSQL databases is as easy as MySQL, due to the intuitive user interface of the Database Manager.

PgSQL databases are provided automatically inside of the most sophisticated web hosting bundles. For the basic packages, they’re presented as upgrades.

With Interplanets Webhost, you shall inevitably find the most up–to–date build of MySQL plus the default MySQL storage engine – InnoDB, set up.

InnoDB is definitely more reliable in comparison to the earlier storage engine’s edition – MyISAM. It is ACID–compliant and, even more importantly – it gives you full transaction support. You’ll find, it takes advantage of row–level locking, as a substitute for MyISAM’s table–level locking, that would always trigger effectiveness problems at high usage times.

Tracking the load caused by the databases in your powerful website makes it possible to avoid virtually any overload problems that can slow it down and ward off website visitors. For this specific purpose, we’ve built in a descriptive Database Stats tool into the Online Control Panel. There you shall find comprehensive info on the arriving requests to your databases for every hour, day and month.

In line with the volume of daily and by the hour queries, you are able to determine which databases are being used the most and consider steps to optimize their load.