Database Manager

Database management might sound like a complicated job to unskilled cloud hosting clients, nevertheless with izemhost’s Database Manager, it’s in fact relatively easy! To set up a brand new database, you only have to key in the username and password. Database back–ups are a click away on top of that.Those who would like to explore their databases and then update them may use the phpMyAdmin and phpPgAdmin tools.

Within the Database Manager it’s possible to create an archived backup of your database whenever you want! That way, you’ll always have a data backup of your dynamic information if your website gets compromised or if you mistakenly get rid of a database. To create a back–up: click on the ’clock’ symbol on the side of a certain database and then simply wait for a couple of seconds for the backup process to be executed.

There are no limitations on the volume of databases you would be able to back up or the amount of back–ups you can create for a database.

A majority of the Linux hosting packages bundles deliver PgSQL support. Although dropping behind MySQL with respect to popularity and usage, PgSQL databases are renowned for offering the best level of security for your site content and articles. This is the reason why businesses like Skype and Yahoo rely on PgSQL databases and not MySQL.

With regards to database management, PgSQL is just as uncomplicated as MySQL.

The MySQL databases on izemhost’s machines utilize the latest build of the InnoDB storage engine. InnoDB was intended to guarantee the highest efficiency for sites that process substantial volumes of data. It features CPU effectiveness that could not be equalled by other disk–based relational database engines.

InnoDB is ACID–compliant and provides total transaction support, meaning that you’ll be able to update/insert/create/alter/drop many times for one "operation" of your app. Furthermore, it makes use of row–level locking in place of MyISAM’s table–level locking, that raises multi–user concurrency and functionality.

Checking the load made by the databases for your busy site will help you reduce virtually any overload troubles that might slow it down and ward off site visitors. Therefore, we have integrated a in–depth Database Stats tool straight into the Online Control Panel. There you can find in–depth information on the arriving requests to your databases for each and every hour, day and month.

Depending on the number of day–to–day and by the hour queries, you are going to be able to determine which databases are used the most and also consider steps to optimize their load.