Databases Manager

The Databases Manager in our Online Control Panel provides a refined yet uncomplicated interface. You’re able to configure a brand new MySQL or PostgreSQL database by just typing in a username and security password. Additionally, you can create a backup file or modify the security password of a database with just a click of the mouse.

With the Databases Manager you have immediate access to the administrator area for all your databases, so that you can make hassle–free alterations in case you have to.

Assuming you have dealt with databases, you already know that making a manual database back–up is simply not a simple task. In order to change this, we’ve developed a simple and easy to use tool that can back up the entire database with one mouse click. The backup file will be prepared for you in under a minute, with respect to the size of the chosen database.

There are not any limits on just how many back–ups you could make for a particular database.

PgSQL databases are much less popular compared to the prevalent MySQL databases. Even so, they represent a favored option for web developers seeking the best protection for their sites and web applications. Due to the intuitive Databases Manager incorporated into the Foxetech Hosting Control Panel, you can administer your PostgreSQL databases with only a mouse click.

You’ll find PgSQL databases integrated automatically within the top Linux cloud packages packages. In case you are with a basic hosting package, it is possible to request PgSQL databases to be added in your cloud hosting account as upgrades.

We’ve installed InnoDB – the brand new default MySQL database engine on our web servers. InnoDB is designed for big database websites that require high effectiveness and scalability. Tests indicate that web sites applying InnoDB based tables reach a 3–fold operation boost for large joins, as compared to those applying MyISAM tables.

InnoDB makes use of row–level locking as a way to clear away the overall performance difficulties spotted at the peak usage times of the earlier variant of the database engine – MyISAM, which uses table–level locking.

Via the all–inclusive database statistics tool incorporated into the Online Control Panel, it’s possible to make a record of the stress generated from your active web sites twenty–four hours a day. Any overload issue with your sites can slow the loading rates and have a bad effect on the overall experience of your site visitors. Thus, having data for the database load immediately, it’s possible to resolve overload difficulties promptly.

The database statistics interface reveals information of the quantity of daily, hourly and monthly queries, so you can analyze just how the load is allocated over various time periods.