Database Manager

Administering your databases is much easier than in the past, thanks to the Online Control Panel user interface for MySQL and PgSQL administration! Provided you do not have extensive experience of managing databases, you will find it easy to deal with the Database Manager.

You can make a brand new database by simply keying in the user name and security password or make a database back–up with merely a click of the mouse. Moreover, within the Data Manager you will get direct access to the administrative area for every single database, which means you can easily manage it.

We’ve developed the manual database back–up generation into a quite easy activity. To do so: within the Database Manager, click on the ’clock’ image beside the database that you intend to back up and after that wait for a couple of seconds for the process to take place. With respect to the size of the database, the building of any backup file will require somewhere between a couple of seconds and a minute.

You can create as many backup copies of a database as you desire. We have not determined any limits for the quantity of databases that you could back up either.

Most of the cloud website hosting bundles grant PgSQL support. Whilst falling behind MySQL regarding popularity and application, PgSQL databases are famous for delivering the highest level of safety for your web site content and articles. It is the reason why businesses like Skype and Yahoo go with PgSQL databases in lieu of MySQL.

When considering database management, PgSQL is as simple as MySQL.

With DataTide.com, you shall always discover the newest version of MySQL along with the default MySQL storage engine – InnoDB, installed.

InnoDB is much more stable in comparison to the former storage engine’s edition – MyISAM. It’s ACID–compliant and, most importantly – it includes total transaction support. Furthermore, it utilizes row–level locking, as a substitute for MyISAM’s table–level locking, that used to result in performance problems at high usage periods.

With the detailed database stats tool built–into the Online Control Panel, you’ll be able to make a record of the stress generated through your dynamic websites twenty–four hours a day. Every single overload problem with your websites could lower the loading speeds and have a bad influence over the overall impression of your website visitors. Consequently, having data about the database work live, it will be possible to fix overload difficulties at once.

The database stats interface shows information of the quantity of daily, hourly and monthly queries, which means you can assess the way the load is spread over several periods of time.