Database Manager

Managing your databases is easier than in the past, because of the Site Control Panel interface for MySQL and PgSQL control! Even if you do not have thorough experience in dealing with databases, it will be easy to use the Database Manager.

You may create a completely new database by only entering the user name and password or generate a database back–up with a simple click of the mouse. Furthermore, within the Data Manager you have direct access to the administration area for each and every database, meaning you can quickly edit it.

Provided you have worked with databases, you know creating a manual database back–up is not really a simple task. In order to change this, we’ve made a simple tool that will back up the entire database with one mouse click. The back–up file shall be completely ready for you in less than a minute, depending upon the size of the selected database.

There are no limitations on the number of backup copies you may make for a selected database.

Just about all of Simple Hosting’s shared hosting packages feature PgSQL support. Whilst dropping behind MySQL with regards to reputation and usage, PgSQL databases are renowned for presenting the maximum level of stability for your site content and articles. This is the key reason why brands like Skype and Yahoo make use of PgSQL databases as an alternative to MySQL.

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

We’ve set up InnoDB – the new standard MySQL database engine on every one of our servers. InnoDB is good for significant database web sites which require high functionality and scalability. Trials have established that websites making use of InnoDB based tables achieve a 3–fold performance increase for huge joins, as opposed to those using MyISAM tables.

InnoDB takes advantage of row–level locking in order to eliminate efficiency issues discovered at the peak usage times of the prior release of the database engine – MyISAM, which employs table–level locking.

We supply you a very easy way for you to keep an eye on the database use for your busy sites. From the descriptive database stats interface, that’s integrated into the Site Control Panel, you’re able to record the load produced by your dynamic web sites in real time. The delivered details will allow you to analyze the database load fluctuations every hour, each day or monthly.

You’ll be able to keep an eye on the database load for all your sites through the Database Stats part of the Site Control Panel. The table on–screen presents the database queries created in the present month. To assess details for a past month, simply click on the back arrows situated at the top.