Database Manager

Overseeing your databases now is easier than ever before, because of the Control Panel user interface for MySQL and PgSQL control! Even though you may not have detailed experience in managing databases, it will be an easy task to manage the Database Manager.

You may create a brand new database by simply specifying the user name and password or create a database back–up with only a mouse click. Additionally, within the Data Manager you have direct access to the management area for each and every database, to help you to immediately modify it.

We have transformed the manual database backup creation into a quite easy activity. To do this: in the Database Manager, click on the ’clock’ image beside the database that you want to back up and after that wait for a couple of seconds for the backup process to take place. Depending upon the size of your database, the creation of any backup file will take between a few seconds and a minute.

You can create as many backup copies of a database as you want. We have not set any confines on the quantity of databases that you could back up too.

PgSQL databases are less sought after compared to the prevalent MySQL databases. However, they’re a favorite alternative for developers seeking the utmost security for their websites and web apps. Thanks to the easy–to–use Database Manager built into the Innovator Host Control Panel, you can manage all your PostgreSQL databases with just a click of the mouse.

You’re going to find PgSQL databases integrated automatically inside of the best cloud website hosting plans packages. If you are with a regular hosting package, you’ll be able to request PgSQL databases to be included in your hosting account as upgrades.

The MySQL databases on our machines make use of the latest build of the InnoDB storage engine. InnoDB was made to ensure the maximum effectiveness for web sites that work with substantial volumes of data. It supplies CPU performance that can not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers full transaction support, meaning that it is easy to update/insert/create/alter/drop a couple of times for one "operation" of your application. Also, it makes use of row–level locking as an alternative to MyISAM’s table–level locking, that enhances multi–user concurrency and performance.

Our company offers you a simple and easy option to keep track of the database usage of your busy websites. Via the in depth database statistics interface, that’s incorporated into the Control Panel, you’ll be able to keep an eye on the load made by your active web sites in real time. The supplied data will allow you to analyze the database load fluctuations by the hour, on a daily basis or on a monthly basis.

You’ll be able to observe the database load for all your web sites from the Database Stats portion of the Control Panel. The table onscreen features the database queries made within the present month. To check information and facts for an earlier month, simply click on the back arrows placed at the top.