Databases Manager

Taking control of your databases is much simpler than ever, on account of the Online Control Panel interface for MySQL and PgSQL control! In case you do not have thorough knowledge in working with databases, you will find it effortless to deal with our Databases Manager.

You may create a whole new database simply by specifying the user name and security password or produce a database back–up with simply a click of the mouse. Moreover, via the Data Manager you’ll have direct access to the administration area for every database, so that you can efficiently update it.

We’ve designed the manual database backup creation into a simple activity. To execute that: within the Databases Manager, click the ’clock’ icon beside the database that you would like to back up and after that wait for a few seconds for the process to take place. Depending on the size of your database, the generation of any backup file will take between a couple of seconds and a minute.

You may make as many copies of a database as you desire. We’ve not fixed any limitations for the amount of databases you could back up too.

PgSQL databases are much less popular compared to the common MySQL databases. On the other hand, they’re a preferred selection for web developers who are looking for the utmost stability for their websites and apps. Thanks to the incredibly user–friendly Databases Manager integrated into the ThouHost Control Panel, you can manage all your PostgreSQL databases with only a mouse click.

You can find PgSQL databases integrated automatically inside the advanced Linux shared service packages. Assuming that you are using a basic hosting package, it is easy to ask for PgSQL databases to be included in your cloud hosting account as upgrades.

The MySQL databases on ThouHost’s servers work with the most recent build of the InnoDB storage engine. InnoDB has been developed to ensure the maximum efficiency for sites that work with significant volumes of data. It supplies CPU performance that can not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, which means you’re able to update/insert/create/alter/drop repeatedly for a single "operation" of your web application. In addition, it works by using row–level locking as a substitute for MyISAM’s table–level locking, that raises multi–user concurrency and efficiency.

From the in depth database statistics tool included in the Online Control Panel, you’ll be able to keep track of the stress generated by your active websites 24 x 365. Any overload problem with your sites could slow the loading speeds and have a bad influence over the overall experience of your site visitors. Consequently, having info about the database load right away, you’ll be able to mend overload troubles as fast as possible.

The database stats interface reveals info of the quantity of daily, hourly and monthly queries, in order to examine the way the load is distributed over several time periods.