Databases Manager

Managing your databases is much easier than ever, on account of the Hosting Control Panel interface for MySQL and PgSQL administration! Even though you may not have extensive knowledge in dealing with databases, you will find it effortless to deal with our Databases Manager.

You can make a new database by only keying in the user name and security password or create a database backup with a mouse click. Likewise, via the Data Manager you’ll possess direct access to the admin area for every database, so you’re able to easily edit it.

Through the Databases Manager it is easy to generate an archived duplicate of your database when you wish! Thus, you’ll always have a data backup of your operating information in the event your site gets compromised or you mistakenly eliminate a database. To produce a backup: click on the ’clock’ image beside a given database and then just wait for a couple of seconds for the backup process to be carried out.

There are not any restricts about the volume of databases you can back up or the amount of backup copies you can make for any database.

Just about all of our cloud web hosting bundles present PgSQL support. Whilst dropping behind MySQL with regard to popularity and usage, PgSQL databases are famous for offering up the maximum level of protection for your web site content and articles. This is the key reason why companies such as Skype and Yahoo rely on PgSQL databases as an alternative to MySQL.

In relation to database administration, PgSQL is as simple and easy as MySQL.

We’ve installed InnoDB – the new default MySQL database engine on all of our web servers. InnoDB is ideal for substantial database web sites which require high effectiveness and scalability. Tests show that websites using InnoDB based tables attain a 3–fold performance increase for very large joins, compared to those employing MyISAM tables.

InnoDB employs row–level locking as a way to eliminate the overall performance issues seen at the high consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

From the thorough database statistics tool incorporated into the Hosting Control Panel, you will be able to make a record of the load produced by your dynamic sites around the clock. Every single overload problem with your web sites could slow the loading rates and have a negative impact on the overall experience of your website visitors. Hence, by having data for the database work instantly, you are able to resolve overload difficulties immediately.

The database stats interface shows information of the amount of daily, hourly and monthly queries, so its possible to assess how the load is spread over different time frames.