Databases Manager

Database management may seem like a hard task to new cloud hosting users, however with the Databases Manager, it’s actually reasonably easy! To create a brand new database, you only have to type in your username and password. Database back–ups are a click away on top of that.Those who desire to look into their databases as well as modify them may use the phpMyAdmin and phpPgAdmin tools.

Within the Databases Manager you’ll be able to make an archived backup of your database when you wish! Thus, you’ll always have a back–up of your dynamic content material in the event your website gets hacked or if you accidentally get rid of a database. To generate a back–up: click the ’clock’ image next to a given database and after that just wait for a couple of seconds for the backup process to be finalized.

There aren’t any confines about the amount of databases you can back up or the quantity of backups you may make for a database.

Just about all of the shared website hosting packages offer PgSQL support. Although falling behind MySQL with regards to level of popularity and usage, PgSQL databases are renowned for delivering the greatest level of security for your web site content and articles. That’s the reason why brands like Skype and Yahoo go with PgSQL databases as an alternative to MySQL.

With respect to database management, PgSQL is equally quick as MySQL.

The MySQL databases on our machines make use of the most up–to–date version of the InnoDB storage engine. InnoDB is created to ensure the optimum efficiency for web sites that operate with big volumes of data. It features CPU performance that could not be matched by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants 100% transaction support, meaning you are able to update/insert/create/alter/drop repeatedly for a single "operation" of your app. Additionally, it makes use of row–level locking and not MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

Monitoring the load accumulated by the databases for your dynamic website assists you to reduce all overload difficulties that can slow it down and ward off site visitors. For this reason, we’ve included a descriptive Database Stats tool within the Online Control Panel. There you can see all–encompassing info on the incoming requests to your databases for every single hour, day and month.

In line with the number of daily and per hour queries, it’s possible to find out which databases are being used the most and also consider steps to optimize their work.