Databases Manager

Overseeing your databases is less complicated than ever, thanks to the Control Panel user interface for MySQL and PgSQL control! Provided you do not have considerable knowledge in making use of databases, you will find it an easy task to use Benoks Hosting’s Databases Manager.

You can make a brand new database by only keying in the username and password or create a database back–up with only a mouse click. At the same time, via the Data Manager you will possess direct access to the admin area for each and every database, so that you can instantly edit it.

Via the Databases Manager it is easy to produce an archived duplicate of your database whenever you want! That way, you’ll always have a back–up of your operating content if your site gets broken into or if you mistakenly eliminate a database. To produce a back–up: click the ’clock’ icon on the side of any database and after that simply wait for a few seconds for the process to be executed.

There are not any limits about the number of databases you can back up or the quantity of backup copies you may make for any database.

PgSQL databases are significantly less famous as compared to the well–known MySQL databases. Having said that, they are a favorite selection for web developers who are looking for the uttermost security for their websites and apps. Via the incredibly user–friendly Databases Manager built–into the Benoks Hosting Control Panel, you can control your PostgreSQL databases with merely a click of the mouse.

You are going to find PgSQL databases incorporated automatically inside of the top Linux shared packages packages. In case you are using a regular hosting package, you can request PgSQL databases to be added to your account as upgrades.

The MySQL databases on Benoks Hosting’s web servers employ the latest release of the InnoDB storage engine. InnoDB has been created to ensure the highest possible performance for web sites that process massive amounts of data. It provides CPU effectiveness that can not be matched up by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, which means that it is possible to update/insert/create/alter/drop more than once for a single "operation" of your web app. At the same time, it uses row–level locking instead of MyISAM’s table–level locking, that boosts multi–user concurrency and performance.

From the detailed database stats tool built into the Control Panel, you are able to keep a record of the stress generated from your active websites 24 x 365. Every overload problem with your web sites can lower the loading rates and have a bad impact on the overall impression of your website visitors. So, by having data about the database work immediately, it will be possible to fix overload difficulties straight away.

The database statistics user interface displays details of the volume of daily, hourly and monthly lookups, so that you can analyze how the load is allocated over several periods of time.