Database Manager

The Database Manager within our Online Control Panel has a robust yet straightforward user interface. You can easily configure a brand new MySQL or PostgreSQL database by simply specifying a username and security password. What’s more, you could make a back–up file or alter the security password of any database with only a mouse click.

From the Database Manager you’ve got immediate access to the administration area for all your databases, so its possible to make convenient alterations when you have to.

Within the Database Manager it is easy to make an archived backup of your database when you desire! For this reason, you’ll always have a data backup of your active information if your website gets hacked or if you incorrectly get rid of a database. To make a back–up: click the ’clock’ icon beside a given database and after that simply wait for a couple of seconds for the process to be performed.

There won’t be any limitations on the volume of databases you would be able to back up or the quantity of backup copies you may make for any database.

You’re going to find PgSQL support in every one of our shared hosting packages. PgSQL databases aren’t as famous and frequently used as MySQL, however they supply the highest level of protection for your site content and articles. For this reason, several popular companies like Skype and Yahoo use PgSQL databases. Handling PgSQL databases is as simple as MySQL, on account of the easy–to–use interface of the Database Manager.

PgSQL databases are integrated by default inside the most advanced web hosting bundles. For the normal plans, they’re offered as upgrades.

We have set up InnoDB – the brand new default MySQL database engine on all our web servers. InnoDB is ideal for massive database websites that need high levels of performance and scalability. Tests have indicated that websites making use of InnoDB based tables achieve a 3–fold general performance increase for huge joins, in comparison to those making use of MyISAM tables.

InnoDB utilizes row–level locking in order to be able to take away the operation problems seen at the maximum usage times of the prior version of the database engine – MyISAM, which utilizes table–level locking.

Through the complete database stats tool included in the Online Control Panel, you are going to be able to keep tabs of the load created through your dynamic web sites round the clock. Every single overload problem with your sites can lower the loading rates and have a negative impact on the overall impression of your respective website visitors. Thus, by having info for the database load immediately, you will be able to solve overload problems straight away.

The database stats interface reveals data of the volume of daily, hourly and monthly queries, which enables you to examine the way the load is spread over several time periods.