Databases Manager

Supervising your databases is much easier than ever, thanks to the Web Hosting Control Panel interface for MySQL and PgSQL management! Even if you do not have thorough knowledge in managing databases, it will be simple to manage Address Hosting’s Databases Manager.

You can create a new database just by specifying the username and password or produce a database backup with merely a mouse click. Moreover, with the Data Manager you will get direct access to the administrator area for each and every database, so its possible to efficiently alter it.

We have designed the manual database back–up formation into a quite easy task. To execute this: inside the Databases Manager, click the ’clock’ symbol next to the database that you would like to back up and then wait around for a couple of seconds for the backup process to take place. With regards to the size of the database, the generation of a backup file will need between a couple of seconds and a minute.

You may create as many back–ups per database as you desire. We’ve not determined any restrictions on the amount of databases you could back up either.

You are going to find PgSQL support in every one of our Linux cloud web hosting bundles. PgSQL databases may not be as famous and commonly used as MySQL, but they offer the greatest level of safety for your website content and articles. Therefore, several widely known companies such as Skype and Yahoo utilize PgSQL databases. Managing PgSQL databases is as easy and simple as MySQL, because of the easy–to–use interface of the Databases Manager.

PgSQL databases are integrated automatically within the most advanced web hosting bundles. For the standard bundles, they are offered as upgrades.

We have installed InnoDB – the brand new default MySQL database engine on every one of our servers. InnoDB is perfect for large database websites that demand high levels of general performance and scalability. Tests demonstrate that sites applying InnoDB based tables attain a 3–fold performance grow for very large joins, as compared to those utilizing MyISAM tables.

InnoDB works by using row–level locking as a way to take away the performance problems spotted at the top consumption times of the prior variant of the database engine – MyISAM, which uses table–level locking.

Via the all–inclusive database stats tool built–into the Web Hosting Control Panel, you will be able to keep a record of the load produced by your active web sites twenty–four hours a day. Every overload issue with your web sites could reduce the loading speeds and have a bad impact on the online experience of your respective visitors. Which means that, having information for the database work instantly, it will be possible to mend overload troubles in a timely manner.

The database stats user interface reveals data of the amount of daily, hourly and monthly lookups, meaning you can evaluate the way the load is allocated over various time periods.