Database Manager

The Database Manager inside our Control Panel incorporates a refined but uncomplicated user interface. It is easy to set up a brand new MySQL or PostgreSQL database by just typing in a username and security password. Additionally, you could make a back–up file or customize the password of an database with just a mouse click.

Through the Database Manager you will have immediate access to the management area for every one of your databases, meaning you can make quick alterations if you happen to have to.

With the Database Manager it’s easy to generate an archived copy of your database whenever you desire! That way, you will always have a data backup of your active content in the event your web site gets compromised or you incorrectly delete a database. To create a back–up: click the ’clock’ icon next to a given database and then wait for a few seconds for the backup process to be finished.

There are no limits about the amount of databases you can back up or the amount of backups you may make for a database.

PgSQL databases are less popular as opposed to the popular MySQL databases. Having said that, they represent a favorite alternative for designers seeking the ultimate security for their websites and apps. Through the intuitive Database Manager built–into the The Online Source Control Panel, you can control all of your PostgreSQL databases with a simple mouse click.

Yow will discover PgSQL databases integrated automatically with the advanced cloud website hosting packages. Assuming that you are with a standard hosting package, you can easily ask for PgSQL databases to be included in your website hosting account as upgrades.

We’ve set up InnoDB – the new standard MySQL database engine on every one of our web servers. InnoDB is made for large database websites that need high effectiveness and scalability. Tests show that web sites making use of InnoDB based tables achieve a 3–fold performance grow for very large joins, compared with those applying MyISAM tables.

InnoDB takes advantage of row–level locking in an effort to eliminate the effectiveness difficulties spotted at the maximum usage times of the previous version of the database engine – MyISAM, which utilizes table–level locking.

From your in depth database statistics tool built into the Control Panel, it will be possible to keep a record of the stress accumulated by your busy websites twenty–four hours a day. Every overload issue with your sites can reduce the loading speeds and have a negative influence over the overall experience of your respective website visitors. Hence, by having data about the database work live, it’s possible to mend overload difficulties in a timely manner.

The database statistics interface displays info of the amount of daily, hourly and monthly lookups, meaning you can review just how the load is distributed over various time frames.