Database Manager

The Database Manager in our Site Control Panel includes a robust nevertheless intuitive interface. It’s possible to configure a completely new MySQL or PostgreSQL database by simply typing in a user name and password. What’s more, you can make a back–up file or alter the password of your database with only a mouse click.

With the Database Manager you’ll have direct access to the management area for each of your databases, so that you can make easy adjustments should you need to.

If you have worked with databases, you know that making a manual database back–up isn’t a basic task. In an effort to change this, we’ve developed a simple tool that can back up your complete database with just a single click. The back–up file will be completely ready for you in less than a minute, based on the size of the selected database.

You won’t notice any confines on the total number of back–ups you could make for a particular database.

Almost all of our Linux web hosting services packages offer PgSQL support. While dropping behind MySQL with regard to reputation and application, PgSQL databases are famous for offering the maximum level of stability for your web site content material. It is the basic reason why companies such as Skype and Yahoo go with PgSQL databases rather than MySQL.

With regards to database administration, PgSQL is as hassle–free as MySQL.

With WebHostingPlex, you shall consistently discover the latest edition of MySQL as well as the default MySQL storage engine – InnoDB, mounted.

InnoDB is definitely more dependable as compared to the previous storage engine’s version – MyISAM. It’s ACID–compliant and, most importantly – it has total transaction support. Additionally, it takes advantage of row–level locking, in contrast to MyISAM’s table–level locking, that used to result in effectiveness problems at high usage occasions.

With the detailed database stats tool included in the Site Control Panel, you will be able to make a record of the load accumulated through your dynamic websites 24 x 365. Every single overload problem with your websites could reduce the loading speeds and have a damaging effect on the overall impression of your website visitors. Therefore, having details for the database load live, it will be straightforward to eliminate overload problems in a timely manner.

The database data interface displays data of the amount of daily, hourly and monthly queries, so you can evaluate the way the load is allocated over several periods of time.