Database Manager

Overseeing your databases is much simpler than ever before, as a result of Site Control Panel interface for MySQL and PgSQL administration! Provided you do not have extensive knowledge of dealing with databases, it will be very easy to deal with Savant Hosting’s Database Manager.

You may create a completely new database by just keying in the user name and password or produce a database backup with a click of the mouse. Also, with the Data Manager you will have direct access to the administrative area for every single database, meaning you can easily modify it.

Provided you have dealt with databases, you know making a manual database backup just isn’t a simple job. So as to change this, we’ve created a simple tool that can back up your whole database with merely one click. The data backup file shall be all set for you in under a minute, depending upon the size of the chosen database.

There aren’t any restrictions on the actual number of backup copies you could make for any particular database.

PgSQL databases are significantly less famous than the widespread MySQL databases. Then again, they represent a favored alternative for developers who are looking for the utmost safety for their web sites and apps. Because of the incredibly user–friendly Database Manager incorporated into the Savant Hosting Control Panel, you can manage all your PostgreSQL databases with simply a click of the mouse.

You can discover PgSQL databases incorporated automatically in the best Linux cloud web hosting plans packages. Provided that you are using a standard hosting package, it is easy to ask for PgSQL databases to be added to your web hosting account as upgrades.

We’ve incorporated InnoDB – the new default MySQL database engine on each of our web servers. InnoDB is good for massive database web sites that require high levels of efficiency and scalability. Tests demonstrate that web sites making use of InnoDB based tables attain a 3–fold general performance increase for huge joins, as opposed to those working with MyISAM tables.

InnoDB employs row–level locking as a way to remove the overall performance issues noticed at the top consumption times of the earlier variant of the database engine – MyISAM, which uses table–level locking.

Via the all–inclusive database stats tool incorporated into the Site Control Panel, it’s possible to keep track of the stress generated from your dynamic web sites at any hour. Virtually any overload issue with your web sites could lower the loading speeds and have a negative effect on the overall impression of your website visitors. Which means that, having data about the database load instantly, it will be straightforward to solve overload issues right away.

The database statistics interface displays data of the amount of daily, hourly and monthly lookups, so that you can review just how the load is spread over different time frames.