Databases Manager

The Databases Manager inside the Control Panel boasts a refined nevertheless simplified interface. You can easily configure a brand new MySQL or PostgreSQL database by simply entering a username and password. Furthermore, you can make a back–up file or alter the security password of your database with a click of the mouse.

Via the Databases Manager you’ll possess immediate access to the administrative area for all your databases, so its possible to make effortless alterations if you happen to have to.

We have changed the manual database back–up generation into a quite easy job. To execute that: in the Databases Manager, click the ’clock’ image near the database that you would like to back up and after that wait for a couple of seconds for the process to take place. With respect to the size of your database, the building of any backup file is going to take somewhere between a few seconds and a minute.

You can make as many copies per database as you desire. We haven’t specified any confines on the quantity of databases you can back up too.

You can find PgSQL support in all our shared web hosting packages. PgSQL databases aren’t as sought after and widespread as MySQL, but they deliver the maximum level of safety for your web site content. For this reason, a number of popular brands like Skype and Yahoo use PgSQL databases. Taking care of PgSQL databases is as easy as MySQL, because of the incredibly user–friendly user interface of the Databases Manager.

PgSQL databases are bundled by default with the most advanced web hosting bundles. For the regular packages, they are suggested as upgrades.

We’ve added InnoDB – the brand new default MySQL database engine on all our servers. InnoDB is made for sizeable database websites that require high levels of effectiveness and scalability. Tests demonstrate that web sites using InnoDB based tables reach a 3–fold effectiveness grow for large joins, as opposed to those making use of MyISAM tables.

InnoDB uses row–level locking so as to take away the performance issues noticed at the high consumption times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.

Via the in–depth database stats tool incorporated into the Control Panel, it will be possible to keep track of the stress generated from your dynamic sites 24 hour a day. Any overload difficulty with your sites can slow the loading rates and have a bad impact on the overall impression of your respective visitors. Hence, having info about the database load in real time, you’ll be able to mend overload issues immediately.

The database data user interface reveals data of the number of daily, hourly and monthly queries, to help you to evaluate how the load is allocated over several time frames.