Databases Manager

The Databases Manager in our Web Site Control Panel provides a robust but still simple to operate user interface. It’s possible to set up a brand new MySQL or PostgreSQL database by just entering a username and password. What’s more, you can create a backup file or modify the password of an database with merely a click of the mouse.

Within the Databases Manager you will possess direct access to the administrator area for every one of your databases, so its possible to make simple and easy alterations should you need to.

From the Databases Manager you are able to produce an archived backup of your database whenever you need! Therefore, you’ll always have a back–up of your operating content in case your web site gets broken into or if you accidentally delete a database. To make a back–up: click the ’clock’ symbol next to a certain database and then simply wait for a few seconds for the backup process to be completed.

There aren’t any confines for the volume of databases you would be able to back up or the volume of backup copies you can create for any database.

A majority of our Linux cloud packages packages deliver PgSQL support. Whilst dropping behind MySQL when it comes to level of popularity and employment, PgSQL databases are famous for presenting the top level of protection for your site content material. It is the primary reason why companies such as Skype and Yahoo rely on PgSQL databases as an alternative to MySQL.

With regard to database management, PgSQL is just as effortless to use as MySQL.

The MySQL databases on Sonic Hosting’s web servers utilize the most current release of the InnoDB storage engine. InnoDB has been meant to ensure the top efficiency for websites that deal with large volumes of data. It grants CPU performance that can not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and provides complete transaction support, so that it is possible to update/insert/create/alter/drop several times for one "operation" of your app. Additionally, it utilizes row–level locking as an alternative to MyISAM’s table–level locking, that raises multi–user concurrency and performance.

Through the all–encompassing database statistics tool built into the Web Site Control Panel, you’ll be able to keep tabs of the load created through your dynamic sites 24 hour a day. Any overload difficulty with your websites can lower the loading speeds and have a negative effect on the online experience of your site visitors. Therefore, by having details about the database load live, it will be straightforward to resolve overload difficulties as quickly as possible.

The database stats interface displays info of the quantity of daily, hourly and monthly queries, which enables you to evaluate just how the load is spread over several time periods.