Databases Manager

Administering your databases is much easier than ever, as a result of Web Hosting Control Panel interface for MySQL and PgSQL control! Assuming you do not have thorough expertise in making use of databases, it will be effortless to work with the Databases Manager.

You can create a whole new database merely by entering the username and security password or produce a database backup with just a click of the mouse. At the same time, with the Data Manager you’ll possess direct access to the admin area for each database, so that you can effectively manage it.

From the Databases Manager you’ll be able to produce an archived backup of your database whenever you wish! For this reason, you’ll always have a data backup of your dynamic information in case your web site gets compromised or you incorrectly remove a database. To produce a back–up: click on the ’clock’ symbol alongside a given database and then wait for a couple of seconds for the backup process to be performed.

There aren’t any confines on the amount of databases you are able to back up or the quantity of backup copies you may make for any database.

You will find PgSQL support in all our shared hosting service plans. PgSQL databases are not as popular and widespread as MySQL, nonetheless they give the top level of protection for your web site content and articles. Due to this, a lot of widely known companies such as Skype and Yahoo employ PgSQL databases. Handling PgSQL databases is as simple and easy as MySQL, thanks to the easy–to–use user interface of the Databases Manager.

PgSQL databases are included by default with the most sophisticated web hosting packages. For the regular packages, they’re offered as upgrades.

With Hostomedia, you will always find the most recent edition of MySQL as well as the default MySQL storage engine – InnoDB, mounted.

InnoDB is definitely more stable when compared to the previous storage engine’s version – MyISAM. It’s ACID–compliant and, most importantly – it includes 100% transaction support. Furthermore, it uses row–level locking, as a substitute for MyISAM’s table–level locking, that seemed to cause efficiency issues at high usage times.

Tracking the load generated by the databases for your active website will let you prevent all kinds of overload issues that might slow it down and ward off visitors. For that reason, we have designed a descriptive Database Stats tool inside the Web Hosting Control Panel. There you can see broad info about the inbound requests to your databases for every single hour, day and month.

In line with the amount of day–to–day and per hour queries, you are able to find out which databases are utilized the most and then take procedures to enhance their work.