Database Manager

Administering your databases is much easier than ever before, thanks to the Online Control Panel interface for MySQL and PgSQL control! Even though you may not have extensive knowledge of dealing with databases, it will be very easy to handle HostLoaded.com’s Database Manager.

You could make a brand new database merely by typing the user name and password or create a database backup with only a mouse click. Furthermore, with the Data Manager you will get direct access to the administrator area for each individual database, so you’re able to immediately manage it.

We have transformed the manual database backup generation into a very easy job. To do so: inside the Database Manager, click on the ’clock’ image next to the database that you intend to back up and after that wait around for a few seconds for the process to take place. Depending on the size of your database, the creation of any back–up file can take somewhere between a couple of seconds and a minute.

You can make as many copies of a database as you want. We’ve not fixed any limitations for the number of databases that you could back up as well.

You’re going to find PgSQL support in all our Linux cloud hosting offers. PgSQL databases aren’t as well–known and widely used as MySQL, nevertheless they offer the top level of security for your web site content. Because of this, many widely known companies like Skype and Yahoo take advantage of PgSQL databases. Controlling PgSQL databases is as easy and simple as MySQL, as a result of the incredibly user–friendly interface of the Database Manager.

PgSQL databases are provided automatically within the most innovative web hosting plans. For the regular plans, they’re presented as upgrades.

We have installed InnoDB – the brand new default MySQL database engine on each of our machines. InnoDB is good for significant database sites which require high general performance and scalability. Experiments show that websites using InnoDB based tables reach a 3–fold functionality boost for big joins, when compared with those working with MyISAM tables.

InnoDB uses row–level locking in order to eliminate the performance difficulties spotted at the peak usage times of the previous release of the database engine – MyISAM, which uses table–level locking.

With the detailed database stats tool included in the Online Control Panel, you’re going to be able to keep a record of the stress created through your busy web sites around the clock. Every single overload problem with your web sites can reduce the loading speeds and have a negative influence over the online experience of your website visitors. Consequently, by having data for the database load instantly, it’s possible to fix overload troubles as soon as possible.

The database stats interface shows information of the volume of daily, hourly and monthly lookups, which means you can review the way the load is distributed over various periods of time.