Database Manager

Managing your databases is easier than ever before, as a result of Control Panel interface for MySQL and PgSQL control! In case you do not have substantial experience in handling databases, you will find it easy to deal with the Database Manager.

You can make a completely new database just by keying in the user name and password or make a database back–up with a simple mouse click. Furthermore, via the Data Manager you will get direct access to the administrator area for every database, meaning you can easily alter it.

Via the Database Manager it’s easy to create an archived copy of your database anytime you want! That way, you are going to always have a data backup of your active content in the event your website gets broken into or you incorrectly delete a database. To generate a backup: click the ’clock’ image alongside a certain database and after that simply wait for a couple of seconds for the process to be performed.

There aren’t any boundaries about the number of databases you would be able to back up or the volume of backups you can create for a database.

PgSQL databases are much less popular compared to the popular MySQL databases. However, they represent a preferred choice for programmers who are looking for the ultimate safety for their web sites and web apps. Via the easy–to–use Database Manager included in the onegeneUK Control Panel, you can control all of your PostgreSQL databases with a simple click of the mouse.

You will find PgSQL databases included automatically inside the advanced Linux cloud web hosting packages packages. If you are using a basic hosting package, it is easy to request PgSQL databases to be added in your web hosting account as upgrades.

With onegeneUK, you will invariably discover the most recent release of MySQL along with the default MySQL storage engine – InnoDB, set up.

InnoDB is definitely more stable compared to the past storage engine’s version – MyISAM. It’s ACID–compliant and, most significantly – it gives you 100% transaction support. It also works by using row–level locking, as an alternative for MyISAM’s table–level locking, that would always cause functionality problems at peak usage times.

From the all–inclusive database statistics tool included in the Control Panel, you will be able to keep track of the load generated from your dynamic websites twenty–four hours a day. Virtually any overload difficulty with your web sites can lower the loading rates and have a bad influence over the overall impression of your respective visitors. Consequently, by having information about the database load immediately, you’ll be able to eliminate overload issues promptly.

The database stats interface reveals information of the amount of daily, hourly and monthly lookups, allowing you to review the way the load is distributed over different time periods.