Database Manager

Administering your databases is simpler than before, due to the Website Control Panel interface for MySQL and PgSQL control! Provided you do not have substantial experience of managing databases, you will find it effortless to use Web Hosting Experts’s Database Manager.

You can create a new database simply by entering the user name and password or create a database backup with only a click of the mouse. In addition, via the Data Manager you will possess direct access to the administrator area for every database, so its possible to almost instantly modify it.

Through the Database Manager you’re able to create an archived duplicate of your database when you wish! This way, you’ll always have a data backup of your operating content in the event your site gets compromised or you mistakenly get rid of a database. To make a back–up: click the ’clock’ icon next to a particular database and then wait for a few seconds for the backup process to be finished.

There won’t be any restrictions on the quantity of databases you can back up or the volume of back–ups you can create for any database.

You can find PgSQL support in all our Linux cloud packages offers. PgSQL databases might not be as popular and widely used as MySQL, nonetheless they provide you with the greatest level of safety for your web site content and articles. For this reason, many famous businesses like Skype and Yahoo utilize PgSQL databases. Dealing with PgSQL databases is as elementary as MySQL, on account of the incredibly user–friendly user interface of the Database Manager.

PgSQL databases are provided automatically inside the most advanced web hosting plans. For the basic plans, they’re featured as upgrades.

We’ve incorporated InnoDB – the new standard MySQL database engine on our machines. InnoDB is perfect for huge database web sites that demand high performance and scalability. Experiments have indicated that sites utilizing InnoDB based tables attain a 3–fold functionality increase for very big joins, in comparison to those making use of MyISAM tables.

InnoDB takes advantage of row–level locking in order to be able to clear away the effectiveness difficulties discovered at the top usage times of the prior variant of the database engine – MyISAM, which uses table–level locking.

Via the in depth database statistics tool included in the Website Control Panel, you’re going to be able to keep a record of the stress created by your busy web sites 24 x 365. Every single overload problem with your websites could reduce the loading speeds and have a damaging effect on the overall experience of your site visitors. So, having details about the database load in real time, you are able to solve overload troubles without delay.

The database statistics user interface reveals info of the quantity of daily, hourly and monthly lookups, in order to analyze the way the load is allocated over various time frames.