Databases Manager

Managing your databases is much easier than in the past, as a result of Web Site Control Panel user interface for MySQL and PgSQL administration! Even if you do not have thorough experience in handling databases, it will be simple to handle the Databases Manager.

You can create a whole new database by only specifying the username and security password or generate a database backup with simply a mouse click. Additionally, from the Data Manager you will get direct access to the administrative area for each database, which enables you to quite easily alter it.

We have designed the manual database backup generation into a simple activity. To do this: within the Databases Manager, click the ’clock’ icon near the database that you want to back up and then wait around for a few seconds for the backup process to take place. Depending on the size of your database, the generation of a backup file can take somewhere between a few seconds and a minute.

You may create as many copies of a database as you desire. We have not determined any confines for the quantity of databases that you can back up too.

You’ll find PgSQL support in our Linux shared hosting services packages. PgSQL databases may not be as well–known and commonly used as MySQL, nevertheless they provide you with the maximum level of stability for your site content. Due to this, several widely known companies such as Skype and Yahoo employ PgSQL databases. Taking care of PgSQL databases is as elementary as MySQL, as a result of the user–friendly interface of the Databases Manager.

PgSQL databases are incorporated by default inside the most sophisticated web hosting plans. For the standard packages, they’re suggested as upgrades.

The MySQL databases on Waffihosting’s servers employ the most recent release of the InnoDB storage engine. InnoDB has been built to ensure the top efficiency for sites that work with big volumes of data. It boasts CPU performance that can not be matched up by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants complete transaction support, meaning that you’re able to update/insert/create/alter/drop many times for one "operation" of your web application. At the same time, it employs row–level locking as an alternative for MyISAM’s table–level locking, that boosts multi–user concurrency and performance.

From the all–inclusive database statistics tool built into the Web Site Control Panel, you’ll be able to keep tabs of the load accumulated by your active web sites 24 hour a day. Virtually any overload problem with your web sites could reduce the loading rates and have a negative influence over the online experience of your site visitors. So, having details about the database work immediately, it will be possible to solve overload difficulties without delay.

The database statistics interface shows information of the quantity of daily, hourly and monthly lookups, in order to assess how the load is spread over several time frames.