Databases Manager

Database management may seem like a difficult job to new website hosting customers, but with True Cloud Hosting’s Databases Manager, it’s in fact relatively easy! To make a brand new database, you only need to enter in the username and password. Database backups are simply a click away as well.People that need to examine their databases and alter them should use the phpMyAdmin and phpPgAdmin tools.

From the Databases Manager you can easily make an archived duplicate of your database when you wish! Therefore, you will always have a back–up of your operating content in the event your web site gets broken into or if you accidentally erase a database. To make a back–up: click on the ’clock’ image alongside a particular database and then just wait for a few seconds for the process to be performed.

There are not any restricts about the volume of databases you can back up or the number of backups you can make for any database.

The majority of True Cloud Hosting’s cloud web hosting bundles deliver PgSQL support. Whilst dropping behind MySQL with respect to acceptance and employment, PgSQL databases are renowned for delivering the greatest level of stability for your site content material. It is the main reason why companies like Skype and Yahoo use PgSQL databases as a substitute for MySQL.

In terms of database management, PgSQL is identically easy to use as MySQL.

We have incorporated InnoDB – the new default MySQL database engine on our servers. InnoDB is ideal for sizeable database web sites that need high effectiveness and scalability. Experiments have revealed that sites applying InnoDB based tables attain a 3–fold operation grow for large joins, in contrast to those utilizing MyISAM tables.

InnoDB makes use of row–level locking in order to eliminate functionality problems observed at the peak usage times of the prior version of the database engine – MyISAM, which utilizes table–level locking.

From your comprehensive database statistics tool built into the Hosting Control Panel, you’ll be able to keep tabs of the load created through your active websites around the clock. Any overload difficulty with your sites could reduce the loading speeds and have a damaging influence over the online experience of your website visitors. Which means that, having information about the database load live, it’s possible to mend overload problems in a timely manner.

The database statistics interface displays data of the quantity of daily, hourly and monthly queries, so you can analyze the way the load is distributed over several periods of time.