From the Database Manager included in the Web Control Panel, it is possible to create brand new MySQL and PgSQL databases immediately! Additionally, you’ll have immediate access to the admin area software programs (phpMyAdmin and phpPgAdmin, respectively), meaning you can immediately revise the database you want.
A Simple to use User interface
The simplest database management interface
Database management may sound like a complicated job to unskilled hosting users, but with Cheap Hosting’s Database Manager, it’s actually reasonably easy! To configure a brand new database, you simply have to provide your username and password. Database backup copies are a mouse click away at the same time.Those who desire to examine their databases and then revise them can make use of the phpMyAdmin and phpPgAdmin tools.
Rapid Database Data backup
Back up your databases in a minute
We’ve designed the manual database back–up formation into a very easy job. To execute this: within the Database Manager, click on the ’clock’ image beside the database that you plan to back up and afterwards wait for a couple of seconds for the process to take place. With regards to the size of your database, the building of the back–up file is going to take somewhere between a couple of seconds and a minute.
You may create as many back–ups per database as you would like. We haven’t set any boundaries on the quantity of databases you could back up as well.
The most risk–free open source databases
Nearly all of Cheap Hosting’s cloud plans bundles grant PgSQL support. Although falling behind MySQL with regards to reputation and usage, PgSQL databases are renowned for delivering the top level of stability for your website content. That is the reason why companies such as Skype and Yahoo employ PgSQL databases instead of MySQL.
When considering database administration, PgSQL is equally hassle–free as MySQL.
The fresh face of MySQL
We’ve set up InnoDB – the new default MySQL database engine on all our web servers. InnoDB is made for substantial database websites which need high levels of performance and scalability. Tests indicate that websites working with InnoDB based tables achieve a 3–fold overall performance increase for significant joins, in contrast to those applying MyISAM tables.
InnoDB works by using row–level locking in order to be able to clear away the operation difficulties detected at the peak usage times of the prior variant of the database engine – MyISAM, which employs table–level locking.
Detailed Database Stats
Complete statistics for your databases
Keeping track of the load accumulated by the databases on your busy website will let you avoid all kinds of overload issues that might slow it down and chase away website visitors. For that reason, we have built in a thorough Database Stats tool inside the Web Control Panel. There you can see in depth information regarding the inbound requests to your databases for each hour, day and month.
Depending on the number of daily and hourly queries, you’ll be able to find out which databases are being used the most and then consider steps to optimize their work.