We grant you a convenient–to–use Database Manager, bundled inside our Online Control Panel, from where you could create brand–new MySQL and PgSQL databases immediately. What’s more, you are enabled to command each of their settings with the quick access presented to the phpMyAdmin and phpPgAdmin software instruments.
A Convenient–to–use User interface
Maintain your databases with merely a click of the mouse
Managing your databases is simpler than in the past, on account of the Online Control Panel user interface for MySQL and PgSQL administration! Provided you do not have extensive experience in working with databases, you will find it simple to handle Loyalty Hosting’s Database Manager.
You may create a completely new database by just keying in the username and password or create a database backup with simply a mouse click. Also, through the Data Manager you will have direct access to the admin area for every database, allowing you to quite simply modify it.
Quick Database Data backup
Back up your databases in just a moment
We have transformed the manual database backup generation into a simple task. To execute this: inside of the Database Manager, click on the ’clock’ icon beside the database that you intend to back up and afterwards wait for a couple of seconds for the backup process to take place. With respect to the size of your database, the building of any backup file will take somewhere between a couple of seconds and a minute.
You may make as many backups of a database as you wish. We haven’t fixed any limits on the volume of databases you can back up too.
PgSQL Support
By far the most protected open source databases
A majority of the cloud website hosting plans offer PgSQL support. While falling behind MySQL when it comes to global recognition and utilization, PgSQL databases are renowned for offering up the highest level of security for your site content and articles. That is the primary reason why companies such as Skype and Yahoo rely upon PgSQL databases instead of MySQL.
In terms of database management, PgSQL is equally hassle–free as MySQL.
InnoDB Databases
The fresh face of MySQL
We’ve added InnoDB – the brand new standard MySQL database engine on all our machines. InnoDB is great for massive database web sites that demand high levels of overall performance and scalability. Tests have indicated that sites employing InnoDB based tables achieve a 3–fold effectiveness boost for large joins, in comparison to those applying MyISAM tables.
InnoDB makes use of row–level locking in order to be able to eliminate the operation problems observed at the maximum usage times of the prior release of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Detailed stats for your databases
Keeping tabs on the load produced by the databases for your powerful site makes it possible to prevent all overload issues that might slow it down and chase away visitors. For that reason, we have built in a in–depth Database Stats tool inside the Online Control Panel. There you can get in depth information regarding the inbound requests to your databases for each and every hour, day and month.
Based on the amount of daily and per hour queries, it’s possible to find out what databases are being used the most and then consider steps to enhance their work.
