From the Database Manager integrated into the Hosting Control Panel, it is possible to make brand new MySQL and PgSQL databases straight away! Also, you will possess direct access to the admin area software programs (phpMyAdmin and phpPgAdmin, respectively), to help you to comfortably manage the database you want.
Neat and Straightforward Interface
Command all your databases from just one place
The Database Manager inside the Hosting Control Panel contains a powerful nevertheless user friendly interface. You can configure a brand new MySQL or PostgreSQL database by simply typing in a user name and password. Additionally, you may create a backup file or alter the password of the database with just a mouse click.
From the Database Manager you’ll possess immediate access to the administrative area for all your databases, allowing you to make effortless adjustments if you ever need to.
Easy and fast Database Backup
Database backup copies are just a click away
From the Database Manager you can easily create an archived copy of your database anytime you need! Therefore, you will always have a back–up of your operating information in the event your site gets hacked or if you accidentally remove a database. To generate a backup: click on the ’clock’ icon alongside a certain database and afterwards simply wait for a couple of seconds for the backup process to be finalized.
There won’t be any limits on the quantity of databases you would be able to back up or the volume of back–ups you can make for a database.
Support for PgSQL
Assured safety for your databases
PgSQL databases are less sought after as compared to the widespread MySQL databases. Even so, they are a preferred selection for designers who are looking for the best safety for their sites and web apps. Thanks to the easy–to–use Database Manager built into the Snaphost Web Hosting Control Panel, you can administer your PostgreSQL databases with only a click of the mouse.
Yow will discover PgSQL databases included automatically in the advanced Linux web hosting packages packages. Assuming that you are using a regular hosting package, it is possible to ask for PgSQL databases to be added to your cloud hosting account as upgrades.
The fresh new face of MySQL
We have added InnoDB – the new default MySQL database engine on all our machines. InnoDB is great for massive database web sites which require high levels of effectiveness and scalability. Experiments show that websites utilizing InnoDB based tables achieve a 3–fold overall performance increase for significant joins, in contrast to those employing MyISAM tables.
InnoDB employs row–level locking as a way to eliminate the overall performance difficulties found at the maximum consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Thorough statistics for all of your databases
With the all–inclusive database stats tool incorporated into the Hosting Control Panel, it is possible to keep track of the load created by your busy sites 24 x 365. Every overload trouble with your websites can slow the loading speeds and have a damaging influence over the overall impression of your website visitors. So, having data about the database load instantly, it will be straightforward to eliminate overload issues promptly.
The database stats user interface reveals info of the amount of daily, hourly and monthly queries, so you’re able to examine just how the load is distributed over various time frames.