Databases Manager

Administering your databases is much easier than in the past, thanks to the Site Control Panel interface for MySQL and PgSQL control! In case you do not have considerable knowledge in dealing with databases, you will find it effortless to deal with our Databases Manager.

You can create a new database by merely keying in the user name and security password or make a database backup with simply a mouse click. Furthermore, with the Data Manager you have direct access to the management area for each and every database, which enables you to quite easily modify it.

Within the Databases Manager it is easy to generate an archived backup of your database when you want! For this reason, you are going to always have a data backup of your active content material in case your site gets broken into or you incorrectly remove a database. To produce a back–up: click on the ’clock’ icon beside any database and then wait for a few seconds for the backup process to be finished.

There are no confines for the volume of databases you would be able to back up or the number of backups you can create for any database.

You will find PgSQL support in our cloud hosting plans. PgSQL databases aren’t as sought after and commonly used as MySQL, however they provide the greatest level of protection for your site content and articles. Because of this, a number of well–known companies such as Skype and Yahoo employ PgSQL databases. Maintaining PgSQL databases is as simple and easy as MySQL, as a result of the user–friendly user interface of the Databases Manager.

PgSQL databases are included by default inside of the most advanced web hosting plans. For the standard plans, they’re presented as upgrades.

We have incorporated InnoDB – the brand new default MySQL database engine on all of our servers. InnoDB is great for massive database web sites which need high functionality and scalability. Trials have shown that websites making use of InnoDB based tables reach a 3–fold overall performance grow for substantial joins, in comparison to those utilizing MyISAM tables.

InnoDB uses row–level locking in order to be able to clear away the effectiveness problems seen at the peak consumption times of the previous release of the database engine – MyISAM, which uses table–level locking.

With the in depth database statistics tool built–into the Site Control Panel, it’s possible to make a record of the load produced through your busy sites 24 x 365. Every single overload trouble with your web sites could slow the loading speeds and have a damaging effect on the online experience of your visitors. Hence, by having info for the database work instantly, it’s possible to resolve overload difficulties promptly.

The database stats user interface displays information of the number of daily, hourly and monthly lookups, so you’re able to assess how the load is allocated over several periods of time.