Database Manager

Overseeing your databases is less complicated than ever before, thanks to the Control Panel interface for MySQL and PgSQL control! Assuming you do not have substantial knowledge in working with databases, it will be very easy to handle the Database Manager.

You can make a whole new database by simply specifying the username and password or make a database back–up with a mouse click. Likewise, through the Data Manager you have direct access to the administration area for each and every database, which means you can quite easily edit it.

We’ve transformed the manual database back–up generation into a quite easy activity. To execute that: in the Database Manager, click the ’clock’ image next to the database that you would like to back up and then wait around for a few seconds for the process to take place. Depending upon the size of the database, the building of the back–up file can take between a couple of seconds and a minute.

You may create as many backups of a database as you desire. We haven’t fixed any confines about the amount of databases that you could back up either.

You can find PgSQL support in our cloud hosting plans plans. PgSQL databases aren’t as sought after and widespread as MySQL, however they deliver the greatest level of safety for your web site content and articles. Due to this, a lot of famous businesses like Skype and Yahoo use PgSQL databases. Managing PgSQL databases is as easy and simple as MySQL, because of the user–friendly interface of the Database Manager.

PgSQL databases are provided by default inside the most sophisticated web hosting plans. For the standard bundles, they are presented as upgrades.

With OpenHost, you shall consistently find the latest edition of MySQL and also the default MySQL storage engine – InnoDB, mounted.

InnoDB is much more secure when compared to the previous storage engine’s version – MyISAM. It’s ACID–compliant and, above all – it gives full transaction support. In addition, it takes advantage of row–level locking, as an alternative for MyISAM’s table–level locking, that seemed to cause efficiency troubles at high usage periods.

Via the detailed database stats tool included in the Control Panel, you are able to make a record of the stress created through your active web sites twenty–four hours a day. Every overload difficulty with your websites could slow the loading speeds and have a damaging influence over the online experience of your respective website visitors. Which means that, by having details for the database load right away, you will be able to solve overload difficulties as soon as possible.

The database stats interface shows data of the quantity of daily, hourly and monthly lookups, meaning you can examine how the load is allocated over several time periods.