Databases Manager

The Databases Manager inside the Online Control Panel contains a refined yet user friendly user interface. You’ll be able to set up a whole new MySQL or PostgreSQL database by just entering a username and security password. In addition, you may create a back–up file or customize the password of the database with only a mouse click.

From the Databases Manager you’ll have immediate access to the administrator area for each of your databases, in order to make easy corrections in the event you have to.

Via the Databases Manager you can easily produce an archived backup of your database anytime you desire! That way, you are going to always have a data backup of your operating content in case your website gets hacked or if you erroneously get rid of a database. To create a backup: click on the ’clock’ image beside any database and afterwards just wait for a couple of seconds for the process to be carried out.

There are not any boundaries for the volume of databases you are able to back up or the quantity of back–ups you may make for a database.

You can find PgSQL support in all our Linux shared web hosting packages offers. PgSQL databases might not be as well–known and frequently used as MySQL, nonetheless they provide the highest possible level of protection for your website content. Due to this, a number of well–known businesses like Skype and Yahoo take advantage of PgSQL databases. Maintaining PgSQL databases is as elementary as MySQL, thanks to the intuitive interface of the Databases Manager.

PgSQL databases are incorporated automatically with the most advanced web hosting packages. For the basic bundles, they’re suggested as upgrades.

We have installed InnoDB – the brand new standard MySQL database engine on every one of our web servers. InnoDB is designed for huge database web sites which need high effectiveness and scalability. Tests have revealed that websites working with InnoDB based tables achieve a 3–fold overall performance boost for massive joins, as compared to those using MyISAM tables.

InnoDB uses row–level locking as a way to clear away the effectiveness issues seen at the top usage times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.

Keeping track of the load made by the databases within your dynamic website will help you avoid all sorts of overload troubles that can slow it down and chase away website visitors. Therefore, we’ve designed a comprehensive Database Stats tool inside the Online Control Panel. There you can get in–depth info about the incoming requests to your databases for every hour, day and month.

Depending on the amount of daily and per hour queries, you are going to be able to find out which databases are being used the most and take actions to enhance their load.