Databases Manager

Database management may sound like a difficult task to inexperienced hosting clients, but with our Databases Manager, it’s in fact really simple! To set up a brand new database, you just need to type in the username and password. Database backups are only a mouse click away as well.People that want to examine their databases and then alter them are able to use the phpMyAdmin and phpPgAdmin tools.

Within the Databases Manager you’ll be able to generate an archived copy of your database anytime you want! Therefore, you will always have a back–up of your dynamic content material in the event your website gets broken into or you erroneously remove a database. To generate a backup: click the ’clock’ icon beside a particular database and then simply wait for a couple of seconds for the process to be completed.

There won’t be any limits for the amount of databases you can back up or the number of back–ups you may make for a database.

PgSQL databases are much less common when compared to the prevalent MySQL databases. Even so, they’re a favored choice for designers who are looking for the greatest protection for their web sites and web apps. Because of the intuitive Databases Manager integrated into the ekkhost Control Panel, you can manage all your PostgreSQL databases with a mouse click.

You can find PgSQL databases included by default inside the best Linux shared hosting packages. Provided that you are with a standard hosting package, it’s possible to ask for PgSQL databases to be added to your hosting account as upgrades.

The MySQL databases on ekkhost’s servers use the most recent release of the InnoDB storage engine. InnoDB was developed to ensure the optimum performance for sites that deal with significant amounts of data. It offers CPU efficiency that can not be matched by any other disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, so that you can update/insert/create/alter/drop a couple of times for a single "operation" of your web app. Additionally, it utilizes row–level locking rather than MyISAM’s table–level locking, that raises multi–user concurrency and performance.

Keeping track of the load made by the databases for your powerful site assists you to prevent all sorts of overload troubles that could slow it down and ward off website visitors. For this reason, we have integrated a detailed Database Stats tool directly into the Site Control Panel. There you will find all–encompassing information about the inbound requests to your databases for each hour, day and month.

Based on the volume of daily and by the hour queries, it will be easier to find out what databases are being used the most as well as take actions to optimize their load.