Database Manager

Taking control of your databases is easier than in the past, because of the Online Control Panel user interface for MySQL and PgSQL control! Assuming you do not have in depth experience in making use of databases, it will be simple to deal with our Database Manager.

You can create a new database merely by specifying the username and security password or make a database backup with merely a mouse click. Likewise, from the Data Manager you’ll have direct access to the management area for every single database, so its possible to quite simply manage it.

We have designed the manual database back–up creation into a very simple activity. To do so: inside of the Database Manager, click on the ’clock’ icon near the database that you want to back up and afterwards wait for a couple of seconds for the process to take place. With respect to the size of your database, the building of the back–up file is going to take between a few seconds and a minute.

You can create as many backup copies per database as you want. We’ve not determined any boundaries on the amount of databases that you can back up either.

You will find PgSQL support in our Linux website hosting packages offers. PgSQL databases might not be as popular and widespread as MySQL, however they provide the highest level of protection for your web site content and articles. For this reason, a number of well–known businesses like Skype and Yahoo implement PgSQL databases. Handling PgSQL databases is as elementary as MySQL, due to the easy–to–use user interface of the Database Manager.

PgSQL databases are included automatically inside of the most sophisticated web hosting packages. For the basic packages, they’re suggested as upgrades.

The MySQL databases on IDC Thailand Co. Ltd.’s servers work with the most current build of the InnoDB storage engine. InnoDB has been developed to ensure the highest performance for websites that work with large amounts of data. It boasts CPU efficiency that could not be matched by any other different disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, which means that you can update/insert/create/alter/drop several times for one "operation" of your application. Additionally, it makes use of row–level locking in lieu of MyISAM’s table–level locking, that raises multi–user concurrency and efficiency.

Tracking the load made by the databases on your active web site makes it possible to prevent any sort of overload problems that might slow it down and ward off website visitors. Therefore, we have integrated a comprehensive Database Stats tool into your Online Control Panel. There you can get all–encompassing info on the inbound requests to your databases for each and every hour, day and month.

Depending on the number of daily and by the hour queries, you are able to find out what databases are used the most as well as take procedures to enhance their work.