Database Manager

Supervising your databases now is easier than ever before, on account of the Website Control Panel user interface for MySQL and PgSQL control! Even though you may not have substantial knowledge of making use of databases, it will be simple to handle the Database Manager.

You can make a completely new database merely by typing the username and password or generate a database backup with just a click of the mouse. Moreover, via the Data Manager you will possess direct access to the administration area for each and every database, allowing you to effortlessly modify it.

Assuming you have dealt with databases, you are aware that creating a manual database backup is simply not an elementary task. In order to change this, we’ve created an easy to understand tool that will back up the entire database with merely one mouse click. The backup file shall be ready for you in under a minute, depending on the size of the chosen database.

There aren’t any confines on the total number of copies you could make for a specific database.

PgSQL databases are less widespread than the common MySQL databases. Nonetheless, they are a favored selection for web developers seeking the best safety for their web sites and web apps. Due to the intuitive Database Manager integrated into the Host Sniper Control Panel, you can control all your PostgreSQL databases with only a mouse click.

You will find PgSQL databases included automatically with the top shared website hosting packages. Assuming that you are using a basic hosting package, it is possible to request PgSQL databases to be added in your website hosting account as upgrades.

The MySQL databases on our web servers work with the most current version of the InnoDB storage engine. InnoDB has been designed to guarantee the highest possible functionality for web sites that operate with huge amounts of data. It provides CPU effectiveness that can not be matched up by other different disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, which means that you’ll be able to update/insert/create/alter/drop a couple of times for a single "operation" of your web application. Additionally, it uses row–level locking in place of MyISAM’s table–level locking, that boosts multi–user concurrency and functionality.

Keeping tabs on the load accumulated by the databases on your active web site will help you avoid all sorts of overload difficulties that might slow it down and ward off visitors. Therefore, we have integrated a in–depth Database Stats tool in the Website Control Panel. There you will find broad info on the arriving requests to your databases for every single hour, day and month.

Using the number of daily and by the hour queries, it will be easy to determine which databases are employed the most and take actions to optimize their load.