Database Manager

Administering your databases is easier than before, because of the Hosting Control Panel interface for MySQL and PgSQL administration! Assuming you do not have in depth experience in working with databases, you will find it an easy task to use the Database Manager.

You may create a new database by merely entering the username and security password or produce a database back–up with just a mouse click. Moreover, through the Data Manager you’ll possess direct access to the admin area for every database, so that you can easily modify it.

We have made the manual database back–up formation into a simple job. To do so: inside the Database Manager, click the ’clock’ icon near the database that you would like to back up and then wait around for a few seconds for the backup process to take place. Depending on the size of your database, the generation of any backup file will need somewhere between a couple of seconds and a minute.

You can make as many backups per database as you wish. We haven’t fixed any restrictions for the number of databases that you could back up as well.

PgSQL databases are less famous compared to the widespread MySQL databases. However, they represent a favorite option for programmers seeking the utmost security for their websites and applications. Due to the easy–to–use Database Manager incorporated into the Westind Technologies LLC Control Panel, you can control all your PostgreSQL databases with only a click of the mouse.

You’re going to find PgSQL databases bundled automatically within the top Linux web hosting packages packages. If you are using a regular hosting package, it is easy to request PgSQL databases to be added to your account as upgrades.

We have installed InnoDB – the brand new standard MySQL database engine on all of our web servers. InnoDB is designed for sizeable database websites that need high levels of general performance and scalability. Trials show that sites using InnoDB based tables reach a 3–fold overall performance boost for huge joins, in comparison to those working with MyISAM tables.

InnoDB takes advantage of row–level locking in an effort to get rid of the functionality problems seen at the top consumption times of the previous version of the database engine – MyISAM, which utilizes table–level locking.

From the broad database statistics tool built into the Hosting Control Panel, you will be able to keep track of the stress generated through your busy sites 24 hour a day. Every single overload problem with your web sites could reduce the loading rates and have a damaging impact on the overall impression of your respective website visitors. Therefore, by having information for the database load in real time, it will be easier to fix overload issues promptly.

The database data interface displays information of the amount of daily, hourly and monthly queries, to help you to analyze how the load is spread over different time frames.