Database Manager

The Database Manager in our Web Hosting Control Panel contains a powerful yet easy to navigate interface. You’re able to set up a brand new MySQL or PostgreSQL database by just specifying a user name and security password. What’s more, you may create a back–up file or alter the password of any database with a click of the mouse.

Through the Database Manager you will possess immediate access to the administration area for each of your databases, so that you can make hassle–free alterations if you happen to have to.

With the Database Manager it’s easy to create an archived copy of your database whenever you want! That way, you will always have a backup of your active information in case your website gets broken into or you erroneously eliminate a database. To produce a backup: click the ’clock’ symbol alongside a certain database and after that wait for a few seconds for the backup process to be carried out.

There are not any restricts for the volume of databases you can back up or the volume of backup copies you can make for a database.

PgSQL databases are less widespread when compared to the prevalent MySQL databases. Then again, they’re a preferred choice for developers who seek the maximum protection for their web sites and applications. Due to the easy–to–use Database Manager integrated into the One Key Hosting Control Panel, you can manage all your PostgreSQL databases with a simple click of the mouse.

You’ll find PgSQL databases bundled by default inside the top Linux hosting packages. Provided that you are using a basic hosting package, it is possible to request PgSQL databases to be added to your account as upgrades.

The MySQL databases on our servers make use of the most recent release of the InnoDB storage engine. InnoDB is intended to ensure the highest possible functionality for websites that work with significant volumes of data. It provides CPU efficiency that can not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, so that it is possible to update/insert/create/alter/drop more than once for a single "operation" of your app. Moreover, it makes use of row–level locking as a substitute for MyISAM’s table–level locking, that increases multi–user concurrency and effectiveness.

One Key Hosting offers you an effortless approach to observe the database usage for your busy websites. Via the in depth database statistics user interface, which is built–into the Web Hosting Control Panel, it is easy to track the load made by your dynamic websites in real time. The offered information will enable you to assess the database load variations each hour, each day or on a monthly basis.

You’re able to monitor the database load for all of your sites within the Database Stats portion of the Web Hosting Control Panel. The table on–screen features the database queries created within the present month. To inspect details for a past month, click on the back arrows placed at the top.