Database Manager

Managing your databases is much easier than ever, on account of the Web Hosting Control Panel user interface for MySQL and PgSQL control! Assuming you do not have extensive knowledge of making use of databases, it will be easy to use the Database Manager.

You may create a whole new database by only typing the username and password or make a database backup with simply a click of the mouse. Likewise, from the Data Manager you’ll possess direct access to the administration area for every single database, allowing you to instantly alter it.

Through the Database Manager it is simple to produce an archived backup of your database when you need! Thus, you will always have a back–up of your operating information if your site gets compromised or you mistakenly delete a database. To generate a backup: click on the ’clock’ image on the side of any database and after that wait for a couple of seconds for the process to be performed.

There won’t be any limits for the number of databases you are able to back up or the number of backup copies you can make for a database.

A majority of our hosting packages feature PgSQL support. Whilst dropping behind MySQL regarding level of popularity and application, PgSQL databases are famous for providing the greatest level of protection for your website content. It is the key reason why companies like Skype and Yahoo use PgSQL databases as a substitute for MySQL.

When considering database administration, PgSQL is identically simple and easy as MySQL.

With SluHost, you’ll invariably discover the most recent variant of MySQL plus the default MySQL storage engine – InnoDB, mounted.

InnoDB is much more stable in comparison to the earlier storage engine’s version – MyISAM. It is ACID–compliant and, most significantly – it has complete transaction support. What’s more, it takes advantage of row–level locking, in contrast to MyISAM’s table–level locking, that previously used to cause performance troubles at peak usage occasions.

Keeping tabs on the load accumulated by the databases on your busy website will help you reduce any overload issues that might slow it down and ward off site visitors. For this reason, we have bundled a detailed Database Stats tool directly into the Web Hosting Control Panel. There you shall find extensive info about the inbound requests to your databases for every single hour, day and month.

Based on the volume of daily and by the hour queries, you’ll be able to determine which databases are used the most and then take steps to enhance their work.