We grant you a user–friendly and uncomplicated Database Manager, included within our Online Control Panel, from where you can create brand–new MySQL and PgSQL databases instantly. Moreover, you’re able to command each of their adjustments via the quick access given to the phpMyAdmin and phpPgAdmin software tools.
A User–friendly User interface
The easiest to use database administration user interface
Database management might sound like a difficult task to newbie cloud hosting clients, however with our Database Manager, it’s actually really simple! To configure a completely new database, you simply have to enter in your username and password. Database backup copies are a click away on top of that.People that would like to explore their databases and edit them may use the phpMyAdmin and phpPgAdmin tools.
Easy Database Back up
Back up your databases in a moment
We have changed the manual database backup generation into a simple job. To execute that: inside the Database Manager, click on the ’clock’ symbol on the side of the database that you would like to back up and wait around for a few seconds for the process to take place. With regards to the size of the database, the building of the backup file is going to take somewhere between a couple of seconds and a minute.
You may make as many backup copies per database as you desire. We haven’t set any boundaries on the number of databases you can back up either.
By far the most stable open source databases
Almost all of Magical Webhost’s cloud website hosting plans grant PgSQL support. Whilst dropping behind MySQL in terms of acceptance and application, PgSQL databases are famous for offering up the best level of stability for your site content material. That is the basic reason why companies such as Skype and Yahoo rely upon PgSQL databases and not MySQL.
When it comes to database management, PgSQL is as straightforward as MySQL.
The fresh face of MySQL
We’ve incorporated InnoDB – the brand new standard MySQL database engine on all of our servers. InnoDB is perfect for huge database sites which need high levels of general performance and scalability. Tests have demonstrated that web sites utilizing InnoDB based tables reach a 3–fold effectiveness grow for very big joins, compared to those utilizing MyISAM tables.
InnoDB works by using row–level locking in order to be able to eliminate efficiency problems found at the peak consumption times of the prior version of the database engine – MyISAM, which employs table–level locking.
Detailed Database Stats
Complete stats for all your databases
Keeping tabs on the load accumulated by the databases within your powerful website makes it possible to prevent any sort of overload difficulties that might slow it down and chase away website visitors. For that reason, we’ve bundled a thorough Database Stats tool into your Online Control Panel. There you can get detailed information on the incoming requests to your databases for every hour, day and month.
Depending on the amount of daily and per hour queries, you’ll be able to find out which databases are employed the most and also take actions to optimize their work.