Database Manager

Managing your databases is much easier than in the past, thanks to the Web Site Control Panel user interface for MySQL and PgSQL control! In case you do not have in depth expertise in making use of databases, it will be an easy task to work with our Database Manager.

You may create a new database simply by typing the user name and security password or create a database backup with merely a click of the mouse. Likewise, from the Data Manager you’ll possess direct access to the administrator area for every database, which means you can quickly revise it.

We have transformed the manual database backup creation into a quite simple job. To do this: inside the Database Manager, click the ’clock’ symbol near the database that you intend to back up and afterwards wait around for a couple of seconds for the process to take place. Depending on the size of your database, the generation of the back–up file will need between a couple of seconds and a minute.

You may make as many back–ups per database as you wish. We’ve not set any restrictions about the amount of databases you could back up too.

You can find PgSQL support in our shared web hosting offers. PgSQL databases might not be as popular and commonly used as MySQL, but they supply the top level of security for your web site content and articles. For this reason, several widely known brands like Skype and Yahoo apply PgSQL databases. Handling PgSQL databases is as elementary as MySQL, thanks to the easy–to–use user interface of the Database Manager.

PgSQL databases are included automatically within the most advanced web hosting packages. For the basic bundles, they’re offered as upgrades.

We have set up InnoDB – the new standard MySQL database engine on each of our machines. InnoDB is made for big database sites that need high levels of effectiveness and scalability. Experiments have established that websites employing InnoDB based tables attain a 3–fold efficiency boost for substantial joins, as compared to those using MyISAM tables.

InnoDB employs row–level locking in an effort to get rid of the overall performance difficulties spotted at the high usage times of the previous release of the database engine – MyISAM, which uses table–level locking.

Keeping tabs on the load produced by the databases in your active website will help you prevent any overload troubles that could slow it down and ward off visitors. For this specific purpose, we’ve integrated a thorough Database Stats tool within the Web Site Control Panel. There you can see thorough info about the arriving requests to your databases for every single hour, day and month.

In line with the number of daily and per hour queries, you are going to be able to determine which databases are employed the most and then take steps to optimize their load.