Database Manager

Taking control of your databases is much simpler than ever, because of the Site Control Panel user interface for MySQL and PgSQL control! Provided you do not have detailed experience in working with databases, you will find it easy to deal with 4 Web Host’s Database Manager.

You could make a brand new database merely by typing the user name and security password or make a database back–up with a simple mouse click. At the same time, from the Data Manager you will get direct access to the management area for each database, so its possible to effortlessly alter it.

Assuming you have worked with databases, you are aware that generating a manual database backup is not really a simple task. So as to change this, we’ve created a simple tool that can back up your complete database with a single click. The backup file will be prepared for you in under a minute, based on the size of the selected database.

You won’t notice any limits on just how many backup copies you could make for a specific database.

Just about all of 4 Web Host’s Linux website hosting packages grant PgSQL support. Although falling behind MySQL with respect to acceptance and application, PgSQL databases are renowned for giving the maximum level of safety for your website content material. That is the basic reason why companies such as Skype and Yahoo rely on PgSQL databases as an alternative to MySQL.

When considering database management, PgSQL is as quick as MySQL.

The MySQL databases on our web servers use the most recent build of the InnoDB storage engine. InnoDB has been developed to ensure the highest effectiveness for web sites that deal with substantial volumes of data. It offers CPU performance that can not be matched up by any other different disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, meaning it is possible to update/insert/create/alter/drop several times for one "operation" of your application. Also, it works by using row–level locking as an alternative for MyISAM’s table–level locking, that boosts multi–user concurrency and effectiveness.

Through the thorough database stats tool built–into the Site Control Panel, you’ll be able to keep a record of the load generated by your dynamic sites around the clock. Any overload trouble with your sites could reduce the loading rates and have a damaging impact on the overall experience of your website visitors. Which means that, by having data for the database load live, it will be easier to eliminate overload troubles straight away.

The database data interface displays info of the number of daily, hourly and monthly lookups, in order to assess the way the load is allocated over various periods of time.