Database Manager

Supervising your databases is easier than before, due to the Web Hosting Control Panel interface for MySQL and PgSQL control! Even though you may not have considerable expertise in managing databases, you will find it very easy to use ZEZZOIC.COM’s Database Manager.

You can create a completely new database by merely keying in the username and security password or generate a database back–up with just a mouse click. Likewise, from the Data Manager you’ll get direct access to the administrative area for every single database, so you can almost instantly update it.

We’ve developed the manual database back–up formation into a quite easy activity. To do this: inside the Database Manager, click on the ’clock’ symbol beside the database that you plan to back up and afterwards wait around for a couple of seconds for the process to take place. With regards to the size of your database, the creation of the back–up file will take between a few seconds and a minute.

You can create as many back–ups of a database as you want. We’ve not determined any limits on the amount of databases you can back up too.

You’re going to find PgSQL support in each of our website hosting plans offers. PgSQL databases are not as well–known and widespread as MySQL, however they offer the greatest level of stability for your website content. For this reason, a number of well–known businesses like Skype and Yahoo use PgSQL databases. Dealing with PgSQL databases is as easy as MySQL, due to the user–friendly interface of the Database Manager.

PgSQL databases are provided by default within the most sophisticated web hosting packages. For the basic bundles, they’re suggested as upgrades.

The MySQL databases on our machines work with the most up–to–date version of the InnoDB storage engine. InnoDB has been created to ensure the optimum efficiency for sites that deal with massive amounts of data. It grants CPU performance that could not be equalled by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, meaning you’ll be able to update/insert/create/alter/drop repeatedly for one "operation" of your web application. At the same time, it utilizes row–level locking in contrast to MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.

Checking the load made by the databases on your active site makes it possible to avoid all sorts of overload issues that can slow it down and ward off visitors. Therefore, we’ve bundled a comprehensive Database Stats tool in the Web Hosting Control Panel. There you shall find all–encompassing information regarding the inbound requests to your databases for every hour, day and month.

Depending on the number of day–to–day and hourly queries, it will be straightforward to find out what databases are used the most and also take measures to optimize their load.