Databases Manager

The Databases Manager in our Web Hosting Control Panel has an effective but still user friendly user interface. It is possible to configure a completely new MySQL or PostgreSQL database by just specifying a username and security password. Moreover, you can create a back–up file or customize the password of any database with merely a click of the mouse.

From the Databases Manager you have immediate access to the admin area for every one of your databases, which enables you to make easy changes should you need to.

Through the Databases Manager it’s possible to generate an archived duplicate of your database anytime you wish! For this reason, you are going to always have a data backup of your operating information in case your website gets broken into or you mistakenly eliminate a database. To create a back–up: click on the ’clock’ symbol alongside a given database and then just wait for a couple of seconds for the backup process to be performed.

There are no limits on the volume of databases you can back up or the number of backup copies you may make for any database.

PgSQL databases are much less widespread in comparison to the widespread MySQL databases. Then again, they are a favorite choice for web developers who are looking for the maximum security for their sites and web applications. Because of the user–friendly Databases Manager built into the K-AXIS Control Panel, you can control all your PostgreSQL databases with simply a mouse click.

You can find PgSQL databases integrated automatically within the advanced Linux shared website hosting packages packages. Assuming that you are using a basic hosting package, you’re able to ask for PgSQL databases to be added to your cloud hosting account as upgrades.

The MySQL databases on K-AXIS’s servers work with the most up–to–date version of the InnoDB storage engine. InnoDB is designed to guarantee the top functionality for web sites that operate with significant amounts of data. It offers CPU performance that could not be equalled by any other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies full transaction support, which means that it is possible to update/insert/create/alter/drop several times for a single "operation" of your app. Furthermore, it uses row–level locking instead of MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.

Keeping tabs on the load generated by the databases for your active web site makes it possible to stop all kinds of overload troubles that might slow it down and chase away website visitors. As a result, we have provided a complete Database Stats tool straight into the Web Hosting Control Panel. There you shall find extensive information about the incoming requests to your databases for each and every hour, day and month.

Depending on the quantity of day–to–day and by the hour queries, you’re going to be able to find out which databases are being used the most and then take measures to enhance their work.