With the Databases Manager built–into the Web Hosting Control Panel, it will be easy to set–up brand new MySQL and PgSQL databases straight away! Moreover, you will have immediate access to the administrator area software programs (phpMyAdmin and phpPgAdmin, respectively), so you’re able to effortlessly manage the database you want.
An Intuitive User interface
Deal with your databases with just a mouse click
Administering your databases is simpler than before, due to the Web Hosting Control Panel user interface for MySQL and PgSQL control! In case you do not have substantial knowledge in utilizing databases, you will find it very easy to manage PIXELSPECK’s Databases Manager.
You can make a new database by simply entering the user name and security password or make a database backup with a simple mouse click. Additionally, with the Data Manager you have direct access to the administrator area for each and every database, so its possible to almost instantly edit it.
Easy Database Backup
Back up your databases in a minute
We have designed the manual database back–up creation into a very simple activity. To execute this: inside the Databases Manager, click on the ’clock’ image near the database that you want to back up and then wait for a couple of seconds for the process to take place. Depending upon the size of your database, the building of a backup file will need somewhere between a few seconds and a minute.
You may create as many copies of a database as you want. We haven’t set any limits about the quantity of databases that you can back up as well.
The most secure open source databases
A majority of our Linux shared website hosting plans offer PgSQL support. While dropping behind MySQL with respect to reputation and employment, PgSQL databases are renowned for giving the maximum level of protection for your site content. This is the key reason why brands like Skype and Yahoo rely on PgSQL databases as a substitute for MySQL.
When it comes to database administration, PgSQL is identically simple as MySQL.
The fresh face of MySQL
We have integrated InnoDB – the brand new default MySQL database engine on all our web servers. InnoDB is great for huge database sites which require high levels of efficiency and scalability. Tests have demonstrated that web sites applying InnoDB based tables achieve a 3–fold functionality boost for very large joins, compared with those making use of MyISAM tables.
InnoDB employs row–level locking so as to clear away the overall performance difficulties detected at the top consumption times of the previous version of the database engine – MyISAM, which uses table–level locking.
Detailed Database Stats
Detailed statistics for all your databases
Keeping tabs on the load made by the databases within your active website assists you to stop all kinds of overload issues that might slow it down and ward off site visitors. For this purpose, we have bundled a detailed Database Stats tool straight into the Web Hosting Control Panel. There you shall find detailed information on the arriving requests to your databases for every single hour, day and month.
Using the amount of day–to–day and by the hour queries, you are able to determine which databases are being used the most and take steps to optimize their load.