Databases Manager

Administering your databases is much simpler than in the past, thanks to the Hosting Control Panel user interface for MySQL and PgSQL control! Even though you may not have thorough experience in working with databases, you will find it easy to manage our Databases Manager.

You can create a brand new database by merely entering the user name and security password or generate a database backup with simply a click of the mouse. Also, through the Data Manager you have direct access to the admin area for each database, to help you to almost instantly update it.

In case you have dealt with databases, you are aware that creating a manual database back–up is not an elementary job. So as to change this, we’ve developed an effortless to use tool that will back up your complete database with simply one click. The back–up file will be completely ready for you in under a minute, based on the size of the chosen database.

There aren’t any limitations on just how many copies you could make for any chosen database.

You will find PgSQL support in each of our shared web hosting plans packages. PgSQL databases may not be as famous and frequently used as MySQL, nonetheless they supply you with the highest level of stability for your website content and articles. Therefore, several well–known brands like Skype and Yahoo apply PgSQL databases. Handling PgSQL databases is as simple and easy as MySQL, as a result of the easy–to–use user interface of the Databases Manager.

PgSQL databases are included automatically inside of the most sophisticated web hosting packages. For the standard packages, they’re offered as upgrades.

We have incorporated InnoDB – the brand new default MySQL database engine on each of our machines. InnoDB is perfect for substantial database websites which require high levels of efficiency and scalability. Experiments have shown that web sites utilizing InnoDB based tables attain a 3–fold efficiency increase for very big joins, when compared to those making use of MyISAM tables.

InnoDB works by using row–level locking as a way to remove the effectiveness issues noticed at the peak consumption times of the earlier release of the database engine – MyISAM, which utilizes table–level locking.

Monitoring the load made by the databases on your powerful site makes it possible to stop all sorts of overload troubles that can slow it down and chase away website visitors. For that reason, we have integrated a detailed Database Stats tool into your Hosting Control Panel. There you shall find in–depth information regarding the inbound requests to your databases for every hour, day and month.

In line with the number of day–to–day and hourly queries, you are going to be able to find out what databases are utilized the most and consider measures to enhance their load.