Databases Manager

Administering your databases is less complicated than in the past, on account of the Web Control Panel user interface for MySQL and PgSQL control! Even if you do not have substantial experience of working with databases, it will be easy to deal with SupremEXCloud’s Databases Manager.

You can make a whole new database simply by keying in the username and password or produce a database backup with a simple mouse click. In addition, from the Data Manager you will get direct access to the management area for every single database, which enables you to quickly alter it.

We have evolved the manual database backup creation into a quite easy task. To do this: within the Databases Manager, click the ’clock’ icon on the side of the database that you want to back up and hang on for a few seconds for the backup process to take place. With respect to the size of the database, the creation of any backup file will need between a couple of seconds and a minute.

You may make as many copies of a database as you want. We’ve not set any limitations for the number of databases you could back up either.

Just about all of our Linux shared website hosting packages offer PgSQL support. Whilst dropping behind MySQL regarding acceptance and usage, PgSQL databases are famous for presenting the best level of security for your website content material. It is the main reason why businesses like Skype and Yahoo make use of PgSQL databases as a substitute for MySQL.

With regard to database management, PgSQL is identically simple as MySQL.

The MySQL databases on our web servers utilize the most recent version of the InnoDB storage engine. InnoDB is made to guarantee the max performance for web sites that deal with sizeable amounts of data. It features CPU efficiency that could not be matched up by any other different disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, which means that you are able to update/insert/create/alter/drop a couple of times for one "operation" of your application. Moreover, it works by using row–level locking in contrast to MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

With the broad database statistics tool integrated into the Web Control Panel, you are able to keep track of the load created from your busy web sites 24 / 7. Every overload issue with your websites can reduce the loading speeds and have a bad effect on the online experience of your respective visitors. Thus, by having details about the database work instantly, you are able to mend overload issues as fast as possible.

The database statistics user interface displays details of the amount of daily, hourly and monthly lookups, so that you can analyze the way the load is distributed over different periods of time.