Databases Manager

The Databases Manager within our Web Site Control Panel comes with an effective nevertheless user friendly user interface. It is easy to set up a completely new MySQL or PostgreSQL database by simply typing a username and security password. In addition, you could make a back–up file or customize the password of your database with a mouse click.

From the Databases Manager you have immediate access to the administrator area for each of your databases, in order to make simple and easy adjustments in case you have to.

Within the Databases Manager you’re able to generate an archived copy of your database whenever you need! That way, you will always have a back–up of your operating content in case your site gets compromised or if you accidentally eliminate a database. To make a back–up: click the ’clock’ image next to any database and then just wait for a few seconds for the backup process to be completed.

There are no restrictions on the number of databases you are able to back up or the number of back–ups you can make for any database.

You’re going to find PgSQL support in all of our Linux cloud packages bundles. PgSQL databases may not be as sought after and commonly used as MySQL, nonetheless they offer the highest possible level of protection for your site content. Therefore, many widely known companies such as Skype and Yahoo make use of PgSQL databases. Taking care of PgSQL databases is as simple as MySQL, as a result of the easy–to–use user interface of the Databases Manager.

PgSQL databases are provided by default within the most sophisticated web hosting bundles. For the standard packages, they’re suggested as upgrades.

We have installed InnoDB – the new default MySQL database engine on all our servers. InnoDB is good for significant database sites that demand high levels of performance and scalability. Trials have demonstrated that websites working with InnoDB based tables achieve a 3–fold functionality grow for substantial joins, as compared to those employing MyISAM tables.

InnoDB uses row–level locking as a way to remove the effectiveness issues noticed at the top usage times of the prior release of the database engine – MyISAM, which utilizes table–level locking.

From your all–inclusive database stats tool incorporated into the Web Site Control Panel, it’s possible to keep track of the load created by your busy websites at any hour. Every single overload trouble with your sites can slow the loading speeds and have a bad impact on the overall experience of your respective visitors. Hence, having information about the database load instantly, it will be easy to eliminate overload issues in a timely manner.

The database data user interface reveals details of the quantity of daily, hourly and monthly lookups, so you can analyze how the load is spread over several time frames.