Databases Manager

Taking control of your databases is easier than before, on account of the Web Control Panel interface for MySQL and PgSQL administration! Provided you do not have detailed knowledge in making use of databases, you will find it an easy task to manage our Databases Manager.

You may create a brand new database by just entering the user name and security password or generate a database back–up with a click of the mouse. Moreover, through the Data Manager you’ll have direct access to the administrator area for every database, allowing you to quickly edit it.

We have evolved the manual database back–up formation into a very simple task. To execute that: inside the Databases Manager, click the ’clock’ image on the side of the database that you want to back up and wait for a couple of seconds for the backup process to take place. Depending on the size of your database, the creation of a backup file is going to take somewhere between a few seconds and a minute.

You may make as many copies of a database as you wish. We have not fixed any restrictions for the amount of databases that you can back up either.

You’ll find PgSQL support in our hosting plans. PgSQL databases are not as popular and widely used as MySQL, nonetheless they provide you with the greatest level of protection for your web site content. Due to this, a lot of widely known companies such as Skype and Yahoo use PgSQL databases. Managing PgSQL databases is as elementary as MySQL, due to the user–friendly user interface of the Databases Manager.

PgSQL databases are provided automatically inside the most advanced web hosting bundles. For the basic plans, they are offered as upgrades.

The MySQL databases on Web Hosting Online Services’s machines use the most up–to–date build of the InnoDB storage engine. InnoDB has been created to ensure the maximum functionality for web sites that process significant amounts of data. It offers CPU effectiveness that could not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, meaning it is easy to update/insert/create/alter/drop several times for a single "operation" of your application. In addition, it uses row–level locking in contrast to MyISAM’s table–level locking, that increases multi–user concurrency and performance.

With the comprehensive database stats tool built into the Web Control Panel, it’s possible to keep track of the stress produced by your dynamic websites 24 x 365. Virtually any overload trouble with your websites could reduce the loading speeds and have a negative effect on the overall impression of your respective visitors. Thus, having data for the database work right away, it will be possible to eliminate overload troubles right away.

The database data user interface displays information of the quantity of daily, hourly and monthly lookups, so you’re able to examine just how the load is spread over several periods of time.