Databases Manager

Supervising your databases is less complicated than ever before, thanks to the Web Control Panel user interface for MySQL and PgSQL management! Assuming you do not have extensive expertise in managing databases, it will be easy to deal with the Databases Manager.

You can create a brand new database by only entering the user name and security password or make a database back–up with simply a click of the mouse. In addition, with the Data Manager you have direct access to the administrative area for each and every database, which enables you to instantly revise it.

We’ve transformed the manual database backup generation into a quite simple job. To execute that: inside of the Databases Manager, click on the ’clock’ icon next to the database that you want to back up and then hang on for a few seconds for the backup process to take place. Depending on the size of your database, the generation of a backup file will need somewhere between a few seconds and a minute.

You may make as many backups per database as you would like. We haven’t fixed any boundaries on the number of databases that you can back up as well.

A majority of SuperLinx.NET’s cloud hosting plans plans present PgSQL support. Whilst dropping behind MySQL when considering popularity and employment, PgSQL databases are renowned for giving the greatest level of protection for your web site content. This is the basic reason why companies such as Skype and Yahoo use PgSQL databases instead of MySQL.

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

With SuperLinx.NET, you will regularly discover the most current edition of MySQL plus the default MySQL storage engine – InnoDB, mounted.

InnoDB is far more stable when compared to the former storage engine’s version – MyISAM. It’s ACID–compliant and, even more importantly – it gives you full transaction support. You’ll find, it makes use of row–level locking, as opposed to MyISAM’s table–level locking, that previously used to trigger effectiveness problems at high usage periods.

Tracking the load accumulated by the databases on your active website assists you to stop all overload difficulties that can slow it down and ward off website visitors. As a result, we’ve designed a comprehensive Database Stats tool within the Web Control Panel. There you can get extensive info about the arriving requests to your databases for each hour, day and month.

Based on the quantity of day–to–day and by the hour queries, it will be easy to find out which databases are employed the most and consider measures to optimize their load.