Via the Databases Manager integrated into the Online Control Panel, you’ll be able to build new MySQL and PgSQL databases straight away! At the same time, you’ll have immediate access to the administrator area software tools (phpMyAdmin and phpPgAdmin, respectively), meaning you can easily edit the database you want.
Neat and User–friendly Interface
Command all your databases from one location
The Databases Manager in the Online Control Panel features a refined nevertheless straightforward user interface. You can easily configure a brand new MySQL or PostgreSQL database simply by specifying a user name and security password. Furthermore, you can create a backup file or modify the security password of an database with simply a mouse click.
Within the Databases Manager you’ve got immediate access to the administration area for all your databases, which enables you to make simple adjustments in the event you have to.
Simple Database Backup
Guard your database information with merely a click of the mouse
Provided you have worked with databases, you know that making a manual database backup isn’t an elementary job. So as to change this, we’ve made a simple and easy to use tool that will back up your entire database with a single mouse click. The backup file shall be completely ready for you in under a minute, depending upon the size of the chosen database.
You won’t notice any restrictions on the actual number of backups you could make for a specific database.
PgSQL Databases Support
Essentially the most risk–free open source databases
You’ll find PgSQL support in all of our shared hosting service offers. PgSQL databases aren’t as sought after and frequently used as MySQL, however they supply the highest level of protection for your site content and articles. Therefore, many well–known brands like Skype and Yahoo take advantage of PgSQL databases. Maintaining PgSQL databases is as simple as MySQL, thanks to the intuitive user interface of the Databases Manager.
PgSQL databases are included automatically inside of the most sophisticated web hosting plans. For the regular packages, they are included as upgrades.
InnoDB Databases
The fresh face of MySQL
With AdTrafficHost, you shall invariably find the most recent version of MySQL as well as the default MySQL storage engine – InnoDB, set up.
InnoDB is a lot more reliable compared to the earlier storage engine’s edition – MyISAM. It is ACID–compliant and, even more importantly – it grants complete transaction support. Furthermore, it uses row–level locking, as opposed to MyISAM’s table–level locking, that used to result in efficiency problems at peak usage occasions.
Detailed Database Stats
Complete statistics for all your databases
Checking the load generated by the databases on your powerful site will help you prevent any overload troubles that might slow it down and ward off visitors. As a result, we have integrated a detailed Database Stats tool inside the Online Control Panel. There you will find in depth information regarding the arriving requests to your databases for every hour, day and month.
Based on the amount of day–to–day and per hour queries, you are able to find out which databases are utilized the most and take steps to optimize their work.
