Databases Manager

Supervising your databases now is easier than in the past, because of the Web Site Control Panel user interface for MySQL and PgSQL control! In case you do not have considerable experience of making use of databases, you will find it easy to manage Apache Website Hosting’s Databases Manager.

You could make a completely new database merely by typing the username and security password or generate a database backup with a simple mouse click. Moreover, within the Data Manager you’ll possess direct access to the management area for every database, so you’re able to quickly edit it.

We have developed the manual database back–up formation into a simple activity. To do so: inside of the Databases Manager, click on the ’clock’ icon beside the database that you plan to back up and then wait around for a few seconds for the backup process to take place. Depending on the size of your database, the building of any back–up file is going to take somewhere between a few seconds and a minute.

You can make as many back–ups of a database as you desire. We haven’t determined any limits for the volume of databases you can back up either.

Almost all of Apache Website Hosting’s cloud hosting bundles feature PgSQL support. Whilst falling behind MySQL with regards to acceptance and usage, PgSQL databases are renowned for offering the highest level of safety for your web site content. That’s the basic reason why brands like Skype and Yahoo go with PgSQL databases as an alternative to MySQL.

In terms of database administration, PgSQL is just as simple as MySQL.

We’ve set up InnoDB – the new default MySQL database engine on our web servers. InnoDB is great for significant database sites that require high general performance and scalability. Tests show that sites utilizing InnoDB based tables attain a 3–fold effectiveness increase for substantial joins, as compared with those applying MyISAM tables.

InnoDB uses row–level locking in an effort to eliminate functionality issues found at the high usage times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

Our company offers you a pretty simple technique to observe the database utilization on your busy sites. Through the in depth database statistics user interface, which is integrated into the Web Site Control Panel, you’ll be able to keep track of the load generated through your busy sites in real time. The provided info will enable you to evaluate the database load variations per hour, daily or per month.

You’ll be able to keep track of the database load for your websites through the Database Stats part of the Web Site Control Panel. The table on–screen features the database lookups created during the present month. To check information and facts for an earlier month, simply click on the back arrows situated at the top.