Database Manager

Managing your databases is less complicated than ever before, on account of the Web Site Control Panel user interface for MySQL and PgSQL administration! In case you do not have in depth experience in handling databases, you will find it very easy to use Domain400’s Database Manager.

You could make a new database by merely entering the user name and password or create a database backup with merely a click of the mouse. Furthermore, from the Data Manager you’ll get direct access to the admin area for each and every database, so you’re able to effortlessly modify it.

Within the Database Manager you are able to produce an archived duplicate of your database anytime you want! That way, you’ll always have a back–up of your operating content in case your web site gets compromised or if you mistakenly eliminate a database. To produce a backup: click the ’clock’ icon alongside a particular database and then wait for a couple of seconds for the process to be finalized.

There are not any limitations about the volume of databases you would be able to back up or the number of backup copies you may make for a database.

PgSQL databases are less famous compared to the popular MySQL databases. Then again, they are a favorite option for web developers who seek the maximum safety for their sites and applications. Due to the intuitive Database Manager built–into the Domain400 Control Panel, you can manage all your PostgreSQL databases with only a mouse click.

You can find PgSQL databases included by default with the best web hosting packages. If you are using a basic hosting package, you’ll be able to request PgSQL databases to be added in your cloud hosting account as upgrades.

We have incorporated InnoDB – the new standard MySQL database engine on all our web servers. InnoDB is ideal for substantial database web sites that demand high levels of functionality and scalability. Experiments have revealed that websites working with InnoDB based tables achieve a 3–fold overall performance increase for large joins, in contrast to those making use of MyISAM tables.

InnoDB works by using row–level locking in order to be able to clear away the overall performance problems observed at the top usage times of the previous release of the database engine – MyISAM, which uses table–level locking.

From the complete database statistics tool built–into the Web Site Control Panel, you’re going to be able to keep track of the stress accumulated from your active websites at any hour. Virtually any overload issue with your websites can slow the loading rates and have a bad impact on the overall impression of your respective visitors. Therefore, having details about the database load in real time, you’ll be able to mend overload difficulties as fast as possible.

The database stats interface shows details of the volume of daily, hourly and monthly queries, so you can examine just how the load is spread over various time frames.