Database Manager

Supervising your databases now is easier than ever before, on account of the Online Control Panel user interface for MySQL and PgSQL control! Assuming you do not have thorough knowledge in making use of databases, you will find it an easy task to work with the Database Manager.

You could make a whole new database by merely keying in the user name and security password or make a database back–up with merely a click of the mouse. Moreover, from the Data Manager you will have direct access to the management area for every single database, which enables you to easily alter it.

Assuming you have dealt with databases, you are aware that generating a manual database back–up is not a basic job. In order to change this, we have created very simple tool that can back up your whole database with a single click. The backup file will be all set for you in under a minute, based on the size of the selected database.

There are not any limits on the amount of backups you may make for any chosen database.

PgSQL databases are much less popular compared to the common MySQL databases. Having said that, they represent a favorite alternative for programmers who seek the best safety for their websites and apps. Because of the intuitive Database Manager built–into the 5StarWebsiteHosting.com Control Panel, you can manage all of your PostgreSQL databases with a click of the mouse.

You’ll find PgSQL databases included automatically with the advanced Linux shared web hosting packages. Provided that you are with a standard hosting package, you’ll be able to ask for PgSQL databases to be added to your account as upgrades.

We have integrated InnoDB – the new standard MySQL database engine on all of our machines. InnoDB is perfect for substantial database web sites which require high levels of general performance and scalability. Trials have revealed that sites working with InnoDB based tables achieve a 3–fold overall performance increase for massive joins, as compared to those working with MyISAM tables.

InnoDB makes use of row–level locking in order to be able to eliminate the overall performance problems observed at the top consumption times of the previous variant of the database engine – MyISAM, which employs table–level locking.

5StarWebsiteHosting.com offers you a fairly easy route to monitor the database use for your active web sites. Through the thorough database stats interface, which is built into the Online Control Panel, it’s possible to keep track of the load created from your dynamic websites in real time. The provided information will enable you to analyze the database load fluctuations every hour, on a daily basis or monthly.

It is easy to monitor the database load for your sites within the Database Stats portion of the Online Control Panel. The table on–screen presents the database lookups made within the present month. To inspect information and facts for an earlier month, click on the back arrows positioned at the top.