Databases Manager

Administering your databases is much simpler than in the past, because of the Web Control Panel interface for MySQL and PgSQL control! Assuming you do not have detailed experience in dealing with databases, you will find it very easy to deal with our Databases Manager.

You may create a whole new database just by typing the user name and security password or generate a database back–up with merely a mouse click. Furthermore, with the Data Manager you will possess direct access to the administrator area for every single database, so that you can conveniently modify it.

Via the Databases Manager you can make an archived duplicate of your database anytime you need! For this reason, you will always have a backup of your operating content material if your website gets hacked or you erroneously remove a database. To generate a backup: click the ’clock’ symbol beside a certain database and afterwards simply wait for a couple of seconds for the process to be done.

There are no boundaries for the amount of databases you are able to back up or the volume of back–ups you can create for a database.

PgSQL databases are significantly less common than the popular MySQL databases. Even so, they represent a preferred alternative for designers seeking the ultimate stability for their web sites and web apps. Because of the incredibly user–friendly Databases Manager incorporated into the PLR Planet Control Panel, you can control your PostgreSQL databases with a simple mouse click.

You can discover PgSQL databases provided by default inside of the advanced Linux shared hosting services packages. Provided that you are with a basic hosting package, you can easily ask for PgSQL databases to be included in your cloud hosting account as upgrades.

The MySQL databases on our web servers utilize the latest release of the InnoDB storage engine. InnoDB is developed to ensure the highest possible performance for web sites that deal with substantial amounts of data. It grants CPU efficiency that could not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and provides 100% transaction support, which means it is possible to update/insert/create/alter/drop many times for one "operation" of your web application. Additionally, it employs row–level locking instead of MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

With the all–encompassing database statistics tool built into the Web Control Panel, you are going to be able to keep track of the stress produced by your busy websites twenty–four hours a day. Virtually any overload difficulty with your web sites can reduce the loading rates and have a negative impact on the overall experience of your website visitors. Therefore, by having info for the database work immediately, it will be easier to mend overload issues promptly.

The database stats user interface shows details of the quantity of daily, hourly and monthly lookups, allowing you to assess just how the load is spread over various time periods.