Databases Manager

The Databases Manager inside our Online Control Panel boasts a robust but still user–friendly user interface. You are able to set up a new MySQL or PostgreSQL database by just entering a user name and password. In addition, you may create a backup file or modify the security password of a database with only a mouse click.

Via the Databases Manager you will have direct access to the administrator area for every one of your databases, meaning you can make uncomplicated corrections should you need to.

If you have worked with databases, you are aware that generating a manual database back–up is simply not an elementary task. In an effort to change this, we have made a simple and easy to use tool that can back up your complete database with simply a single click. The backup file will be completely ready for you in under a minute, with regards to the size of the chosen database.

There are not any limits on the actual number of copies you may make for any particular database.

PgSQL databases are significantly less widespread as compared to the common MySQL databases. Then again, they’re a favorite selection for developers who are looking for the ultimate security for their sites and apps. Because of the intuitive Databases Manager integrated into the Xerdec Web Solutions Control Panel, you can control all of your PostgreSQL databases with a simple mouse click.

You’re going to find PgSQL databases incorporated by default in the best Linux shared website hosting packages. Provided that you are with a regular hosting package, it’s possible to ask for PgSQL databases to be included in your website hosting account as upgrades.

The MySQL databases on Xerdec Web Solutions’s servers make use of the newest build of the InnoDB storage engine. InnoDB is intended to ensure the highest possible efficiency for web sites that process substantial amounts of data. It provides CPU performance that could not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and gives 100% transaction support, meaning that it is possible to update/insert/create/alter/drop more than once for a single "operation" of your app. In addition, it takes advantage of row–level locking in contrast to MyISAM’s table–level locking, that enhances multi–user concurrency and efficiency.

Keeping track of the load made by the databases in your busy web site will let you avoid virtually any overload troubles that might slow it down and chase away website visitors. For this purpose, we have built–in a descriptive Database Stats tool into the Online Control Panel. There you shall find extensive info about the incoming requests to your databases for each hour, day and month.

Depending on the quantity of day–to–day and per hour queries, you will be able to determine which databases are being used the most as well as take steps to optimize their work.