Database Manager

Database management may sound like a hard task to unskilled website hosting users, however with the Database Manager, it’s in fact quite simple! To create a new database, you only have to enter in the username and password. Database backups are only a click away as well.Those who need to examine their databases and then modify them can make use of the phpMyAdmin and phpPgAdmin tools.

Within the Database Manager you can easily produce an archived copy of your database when you want! Therefore, you will always have a data backup of your active information in case your site gets compromised or you incorrectly remove a database. To create a backup: click on the ’clock’ icon next to a certain database and after that simply wait for a few seconds for the process to be executed.

There aren’t any boundaries on the volume of databases you can back up or the number of backups you can create for any database.

PgSQL databases are significantly less sought after as compared to the well–known MySQL databases. However, they are a preferred option for web developers seeking the utmost safety for their web sites and apps. Via the intuitive Database Manager built–into the Cheap Australian Web Hosting Control Panel, you can control all your PostgreSQL databases with only a click of the mouse.

You can discover PgSQL databases incorporated automatically inside the advanced Linux cloud packages packages. Assuming that you are using a regular hosting package, it’s possible to request PgSQL databases to be added in your cloud hosting account as upgrades.

The MySQL databases on our web servers utilize the most up–to–date version of the InnoDB storage engine. InnoDB is created to ensure the optimum efficiency for web sites that process sizeable amounts of data. It supplies CPU effectiveness that could not be matched by alternative disk–based relational database engines.

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

With the all–encompassing database stats tool integrated into the Site Control Panel, it is possible to keep a record of the load produced through your dynamic web sites at any hour. Every single overload issue with your web sites could lower the loading speeds and have a damaging impact on the online experience of your visitors. Which means that, by having information for the database load instantly, it is possible to solve overload issues as soon as possible.

The database stats user interface reveals info of the volume of daily, hourly and monthly queries, so you can examine just how the load is distributed over different periods of time.