The Databases Manager inside the Site Control Panel provides a powerful yet convenient–to–use interface. You can set up a whole new MySQL or PostgreSQL database by just specifying a user name and security password. Furthermore, you may create a back–up file or customize the password of any database with merely a mouse click.

Within the Databases Manager you have immediate access to the admin area for all your databases, so its possible to make simple and easy alterations if you happen to need to.

With the Databases Manager you are able to generate an archived copy of your database whenever you desire! This way, you’ll always have a back–up of your active content material in case your website gets hacked or if you incorrectly get rid of a database. To create a back–up: click the ’clock’ symbol alongside a certain database and afterwards simply wait for a couple of seconds for the backup process to be performed.

There aren’t any restrictions about the amount of databases you would be able to back up or the number of backup copies you can create for any database.

A lot of the shared website hosting services bundles provide PgSQL support. Whilst falling behind MySQL regarding popularity and application, PgSQL databases are renowned for presenting the best level of security for your web site content. This is the main reason why brands like Skype and Yahoo employ PgSQL databases instead of MySQL.

When considering database administration, PgSQL is just as hassle–free as MySQL.

With www, you shall regularly find the most up–to–date version of MySQL along with the default MySQL storage engine – InnoDB, mounted.

InnoDB is definitely more secure than the earlier storage engine’s edition – MyISAM. It’s ACID–compliant and, even more importantly – it has total transaction support. Additionally, it works by using row–level locking, in contrast to MyISAM’s table–level locking, that seemed to lead to functionality problems at high usage periods.

Via the complete database statistics tool included in the Site Control Panel, you are able to keep a record of the load created through your busy sites 24 / 7. Any overload trouble with your sites could slow the loading rates and have a negative influence over the online experience of your respective site visitors. Consequently, having data about the database load live, it will be easy to resolve overload issues right away.

The database statistics user interface displays info of the volume of daily, hourly and monthly queries, so you’re able to assess just how the load is distributed over different periods of time.