Databases Manager

The Databases Manager in the Hosting Control Panel contains a refined but still easy to use interface. You can configure a brand new MySQL or PostgreSQL database by just typing in a username and password. Additionally, you can make a back–up file or modify the password of any database with only a mouse click.

From the Databases Manager you’ve got immediate access to the admin area for each of your databases, so its possible to make quick corrections in the event you have to.

We’ve designed the manual database backup creation into a quite simple task. To execute that: inside the Databases Manager, click on the ’clock’ symbol on the side of the database that you intend to back up and afterwards hang on for a couple of seconds for the backup process to take place. With respect to the size of the database, the creation of a backup file will require between a couple of seconds and a minute.

You may create as many back–ups per database as you want. We haven’t set any restrictions for the amount of databases you could back up either.

Just about all of the shared website hosting plans bundles grant PgSQL support. While falling behind MySQL when it comes to level of popularity and application, PgSQL databases are renowned for offering the top level of security for your site content and articles. That’s the basic reason why brands like Skype and Yahoo make use of PgSQL databases rather than MySQL.

With regards to database management, PgSQL is just as effortless to use as MySQL.

The MySQL databases on apluschoice’s servers utilize the newest version of the InnoDB storage engine. InnoDB has been built to ensure the top functionality for websites that deal with big amounts of data. It supplies CPU effectiveness that could not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives 100% transaction support, which means it is easy to update/insert/create/alter/drop a couple of times for a single "operation" of your application. At the same time, it takes advantage of row–level locking in lieu of MyISAM’s table–level locking, that raises multi–user concurrency and effectiveness.

Keeping track of the load accumulated by the databases within your dynamic website makes it possible to stop any sort of overload issues that could slow it down and chase away visitors. For this specific purpose, we’ve integrated a in–depth Database Stats tool in the Hosting Control Panel. There you will find in–depth information on the arriving requests to your databases for every single hour, day and month.

Using the volume of day–to–day and by the hour queries, you are able to determine which databases are utilized the most and also take measures to optimize their work.