Inside the ZanyHosting.com Web Control Panel you will find a fully–fledged, simple point and click Database Manager! Utilize it to experience total command over all your databases. You can easily configure new MySQL and PgSQL databases and administer them through the phpMyAdmin and phpPgAdmin software tools, respectively.
A User friendly User interface
The most effective database administration interface
Database management may seem like a difficult job to novice cloud hosting users, nevertheless with the Database Manager, it’s in fact pretty simple! To create a brand new database, you simply ought to provide your username and password. Database backup copies are only a click away as well.People that choose to explore their databases and then alter them may use the phpMyAdmin and phpPgAdmin tools.
Effortless Database Data backup
Take care of your database content with only a click of the mouse
Provided you have worked with databases, you already know that making a manual database back–up is just not a basic task. In order to change this, we’ve created an easy to understand tool that can back up your complete database with only one click. The back–up file shall be ready for you in under a minute, depending upon the size of the selected database.
There are not any restrictions on the number of copies you may make for a selected database.
Essentially the most risk–free open source databases
A lot of our shared website hosting plans plans deliver PgSQL support. Although dropping behind MySQL when considering acceptance and application, PgSQL databases are renowned for presenting the maximum level of stability for your web site content. It is the basic reason why businesses like Skype and Yahoo rely upon PgSQL databases as an alternative to MySQL.
In terms of database administration, PgSQL is as simple and easy as MySQL.
The newest face of MySQL
We’ve installed InnoDB – the new standard MySQL database engine on all our servers. InnoDB is ideal for significant database web sites that demand high levels of functionality and scalability. Experiments have established that web sites applying InnoDB based tables achieve a 3–fold efficiency boost for large joins, compared with those using MyISAM tables.
InnoDB uses row–level locking in an effort to eliminate the performance issues noticed at the top consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Precise statistics for all your databases
Tracking the load produced by the databases in your active website will help you prevent all kinds of overload troubles that might slow it down and chase away site visitors. Therefore, we have included a in–depth Database Stats tool directly into the Web Control Panel. There you can find thorough information about the incoming requests to your databases for each and every hour, day and month.
Depending on the number of daily and per hour queries, it will be easy to find out which databases are being used the most and then consider steps to enhance their load.