Database Manager

The Database Manager inside the Site Control Panel provides an effective but user–friendly interface. You’ll be able to set up a new MySQL or PostgreSQL database simply by entering a user name and security password. What’s more, you can make a back–up file or modify the security password of the database with a mouse click.

Via the Database Manager you’ll possess direct access to the management area for all your databases, which enables you to make quick changes in case you have to.

In case you have worked with databases, you are aware that generating a manual database backup just isn’t a simple job. So as to change this, we have made an effortless to use tool that can back up your entire database with merely a single mouse click. The backup file shall be available for you in under a minute, depending on the size of the selected database.

There aren’t any confines on the amount of back–ups you can make for a specific database.

Almost all of the Linux cloud website hosting packages grant PgSQL support. Whilst falling behind MySQL when considering reputation and application, PgSQL databases are famous for offering the highest level of safety for your web site content. This is the reason why companies such as Skype and Yahoo rely upon PgSQL databases rather than MySQL.

When it comes to database management, PgSQL is equally simple as MySQL.

We’ve incorporated InnoDB – the new default MySQL database engine on every one of our machines. InnoDB is good for substantial database websites which need high efficiency and scalability. Trials show that websites utilizing InnoDB based tables reach a 3–fold overall performance boost for substantial joins, as opposed to those applying MyISAM tables.

InnoDB makes use of row–level locking as a way to get rid of the functionality issues found at the high consumption times of the earlier release of the database engine – MyISAM, which employs table–level locking.

From your broad database statistics tool incorporated into the Site Control Panel, it is possible to make a record of the load produced through your dynamic web sites twenty–four hours a day. Virtually any overload problem with your sites can reduce the loading speeds and have a negative impact on the overall impression of your respective visitors. Therefore, by having information about the database work instantly, it will be easy to mend overload difficulties at once.

The database stats interface reveals data of the volume of daily, hourly and monthly lookups, which enables you to analyze how the load is distributed over several periods of time.