Databases Manager

Taking control of your databases now is easier than ever before, on account of the Online Control Panel interface for MySQL and PgSQL management! Provided you do not have substantial experience in handling databases, you will find it simple to work with wanahost’s Databases Manager.

You may create a whole new database by only specifying the user name and password or generate a database back–up with just a mouse click. In addition, with the Data Manager you will have direct access to the administrative area for each database, so that you can easily edit it.

Through the Databases Manager you’re able to create an archived backup of your database anytime you want! Therefore, you will always have a backup of your active content in the event your web site gets broken into or you erroneously get rid of a database. To produce a backup: click on the ’clock’ icon next to a particular database and afterwards simply wait for a couple of seconds for the process to be finished.

There are not any restricts on the number of databases you can back up or the quantity of backups you can create for any database.

You’re going to find PgSQL support in our cloud website hosting plans offers. PgSQL databases are not as popular and commonly used as MySQL, however they provide the greatest level of safety for your web site content and articles. Because of this, a number of popular companies like Skype and Yahoo use PgSQL databases. Handling PgSQL databases is as simple as MySQL, as a result of the incredibly user–friendly user interface of the Databases Manager.

PgSQL databases are provided automatically with the most advanced web hosting packages. For the regular bundles, they’re included as upgrades.

We have set up InnoDB – the brand new default MySQL database engine on our machines. InnoDB is made for massive database web sites which need high levels of effectiveness and scalability. Trials demonstrate that websites using InnoDB based tables attain a 3–fold operation increase for big joins, compared to those employing MyISAM tables.

InnoDB works by using row–level locking in order to eliminate the overall performance difficulties noticed at the top usage times of the earlier variant of the database engine – MyISAM, which utilizes table–level locking.

Monitoring the load produced by the databases for your active web site will let you reduce any sort of overload difficulties that could slow it down and chase away visitors. As a result, we have built in a in depth Database Stats tool straight into the Online Control Panel. There you can see all–encompassing info about the incoming requests to your databases for every single hour, day and month.

Using the amount of daily and hourly queries, it’s possible to find out what databases are utilized the most as well as consider actions to optimize their work.