Databases Manager

Database management might sound like a difficult job to newbie website hosting clients, however with the Databases Manager, it’s in fact quite simple! To create a new database, you just have to provide your username and password. Database back–ups are just a mouse click away too.Those who wish to explore their databases and edit them are able to use the phpMyAdmin and phpPgAdmin tools.

Via the Databases Manager you can easily generate an archived copy of your database when you would like! That way, you’ll always have a backup of your operating content in the event your web site gets hacked or if you incorrectly remove a database. To make a backup: click on the ’clock’ symbol alongside any database and after that just wait for a couple of seconds for the backup process to be finished.

There are not any restricts for the quantity of databases you are able to back up or the number of backups you can make for a database.

PgSQL databases are less common compared to the well–known MySQL databases. On the other hand, they represent a preferred alternative for web developers seeking the best safety for their websites and web apps. Because of the user–friendly Databases Manager integrated into the ONLINE.UK Control Panel, you can control all your PostgreSQL databases with just a click of the mouse.

You can discover PgSQL databases incorporated automatically with the advanced Linux shared hosting services packages. Provided that you are with a basic hosting package, you are able to ask for PgSQL databases to be added to your cloud hosting account as upgrades.

The MySQL databases on our machines make use of the newest build of the InnoDB storage engine. InnoDB was intended to guarantee the max functionality for websites that process large amounts of data. It offers CPU efficiency that can not be matched up by other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, so that it’s possible to update/insert/create/alter/drop several times for one "operation" of your app. At the same time, it utilizes row–level locking and not MyISAM’s table–level locking, that enhances multi–user concurrency and performance.

Via the broad database stats tool incorporated into the Website Control Panel, you are going to be able to keep track of the stress accumulated by your dynamic web sites at any hour. Every overload trouble with your web sites can reduce the loading rates and have a bad effect on the overall experience of your site visitors. So, by having data about the database work immediately, it is possible to eliminate overload problems immediately.

The database data user interface reveals information of the number of daily, hourly and monthly queries, meaning you can examine the way the load is spread over various time periods.