Database Manager

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.

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.

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.

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.

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.