Database Manager

The Database Manager inside our Web Hosting Control Panel incorporates a robust but still intuitive interface. You’re able to configure a whole new MySQL or PostgreSQL database simply by entering a user name and security password. What’s more, you can make a backup file or alter the security password of any database with simply a click of the mouse.

Via the Database Manager you’ll possess immediate access to the management area for each of your databases, meaning you can make simple adjustments when you have to.

With the Database Manager it’s easy to generate an archived duplicate of your database anytime you need! Therefore, you will always have a backup of your active information in case your web site gets broken into or if you accidentally eliminate a database. To generate a backup: click on the ’clock’ symbol on the side of a certain database and afterwards wait for a couple of seconds for the process to be finalized.

There aren’t any restricts on the volume of databases you are able to back up or the quantity of backups you can make for a database.

A majority of our shared hosting plans plans offer PgSQL support. Although falling behind MySQL in terms of level of popularity and application, PgSQL databases are renowned for presenting the maximum level of safety for your website content. That’s the reason why brands like Skype and Yahoo rely on PgSQL databases instead of MySQL.

With regard to database administration, PgSQL is identically straightforward as MySQL.

We’ve set up InnoDB – the brand new default MySQL database engine on our web servers. InnoDB is designed for huge database websites that require high effectiveness and scalability. Trials have indicated that sites working with InnoDB based tables achieve a 3–fold efficiency increase for huge joins, compared with those employing MyISAM tables.

InnoDB takes advantage of row–level locking in order to eliminate effectiveness issues detected at the top usage times of the previous version of the database engine – MyISAM, which utilizes table–level locking.

Checking the load accumulated by the databases on your powerful web site makes it possible to avoid any kind of overload issues that could slow it down and chase away visitors. As a result, we’ve bundled a descriptive Database Stats tool into the Web Hosting Control Panel. There you can find in depth info on the incoming requests to your databases for each and every hour, day and month.

Depending on the volume of daily and hourly queries, it will be straightforward to determine which databases are utilized the most and then consider actions to enhance their load.