Database Manager

The Database Manager within our Hosting Control Panel features a robust nevertheless intuitive interface. It’s possible to configure a brand new MySQL or PostgreSQL database by just specifying a user name and security password. Additionally, you may create a back–up file or customize the password of an database with a mouse click.

Within the Database Manager you’ll have immediate access to the administrator area for all your databases, allowing you to make simple and easy changes if you happen to have to.

With the Database Manager it’s possible to create an archived copy of your database whenever you desire! Therefore, you’ll always have a data backup of your active content material in case your website gets compromised or you erroneously get rid of a database. To produce a back–up: click the ’clock’ icon on the side of any database and afterwards wait for a couple of seconds for the process to be completed.

There aren’t any confines for the number of databases you would be able to back up or the amount of back–ups you can create for any database.

A lot of the shared hosting bundles present PgSQL support. While falling behind MySQL with regards to level of popularity and application, PgSQL databases are famous for providing the maximum level of protection for your website content material. It is the main reason why companies such as Skype and Yahoo use PgSQL databases instead of MySQL.

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

The MySQL databases on DO-TO.us’s machines utilize the most up–to–date release of the InnoDB storage engine. InnoDB has been designed to ensure the max effectiveness for sites that operate with huge amounts of data. It delivers CPU performance that could not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives 100% transaction support, meaning that you can easily update/insert/create/alter/drop many times for one "operation" of your web app. Also, it uses row–level locking as an alternative to MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

Tracking the load caused by the databases in your busy web site assists you to stop all sorts of overload problems that could slow it down and ward off website visitors. As a result, we’ve built in a in depth Database Stats tool within the Hosting Control Panel. There you can get detailed info on the inbound requests to your databases for every single hour, day and month.

Based on the volume of daily and by the hour queries, you are going to be able to find out what databases are employed the most and then take measures to optimize their work.