Databases Manager

The Databases Manager inside our Site Control Panel boasts a powerful but simple to operate user interface. You’ll be able to set up a whole new MySQL or PostgreSQL database simply by typing in a user name and password. Furthermore, you could make a backup file or alter the password of an database with only a mouse click.

Within the Databases Manager you will have immediate access to the administrative area for each of your databases, so you’re able to make simple and easy modifications should you have to.

We’ve developed the manual database backup creation into a quite easy job. To do so: in the Databases Manager, click on the ’clock’ icon near the database that you intend to back up and then hang on for a few seconds for the process to take place. Depending on the size of the database, the building of the back–up file will take between a couple of seconds and a minute.

You can make as many backups of a database as you wish. We haven’t determined any boundaries about the amount of databases that you could back up either.

Almost all of our Linux shared website hosting bundles offer PgSQL support. While falling behind MySQL with respect to popularity and usage, PgSQL databases are famous for providing the greatest level of safety for your website content material. That’s the reason why brands like Skype and Yahoo employ PgSQL databases as opposed to MySQL.

When it comes to database administration, PgSQL is just as straightforward as MySQL.

The MySQL databases on Mark Love’s web servers make use of the newest release of the InnoDB storage engine. InnoDB was made to guarantee the top efficiency for websites that process substantial amounts of data. It delivers CPU effectiveness that can not be matched by any other disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, so that it is easy to update/insert/create/alter/drop more than once for one "operation" of your web application. At the same time, it uses row–level locking in place of MyISAM’s table–level locking, that boosts multi–user concurrency and efficiency.

Keeping track of the load made by the databases within your powerful web site will let you avoid virtually any overload troubles that can slow it down and ward off website visitors. For this specific purpose, we have designed a thorough Database Stats tool into your Site Control Panel. There you can get comprehensive info about the inbound requests to your databases for every hour, day and month.

In line with the amount of day–to–day and per hour queries, it will be straightforward to determine which databases are employed the most and consider actions to enhance their load.