Database Manager

The Database Manager inside the Site Control Panel includes a powerful yet simple to operate interface. You can easily configure a whole new MySQL or PostgreSQL database by simply specifying a username and password. Also, you can create a backup file or customize the password of an database with simply a mouse click.

Within the Database Manager you’ve got immediate access to the administrative area for all your databases, so you can make easy adjustments if you happen to need to.

With the Database Manager it’s possible to generate an archived backup of your database when you desire! This way, you’ll always have a back–up of your active content in case your website gets broken into or if you erroneously get rid of a database. To create a back–up: click on the ’clock’ symbol alongside any database and then wait for a few seconds for the process to be carried out.

There are no confines for the number of databases you are able to back up or the volume of backups you can create for any database.

PgSQL databases are much less famous as opposed to the well–known MySQL databases. However, they represent a favored choice for developers seeking the utmost protection for their sites and applications. Via the easy–to–use Database Manager incorporated into the lumenhost Control Panel, you can administer your PostgreSQL databases with just a click of the mouse.

You can discover PgSQL databases bundled automatically inside the top hosting packages. If you are using a basic hosting package, you are able to request PgSQL databases to be included in your hosting account as upgrades.

We’ve incorporated InnoDB – the brand new standard MySQL database engine on every one of our machines. InnoDB is great for huge database web sites that require high levels of overall performance and scalability. Trials have indicated that web sites working with InnoDB based tables attain a 3–fold performance grow for large joins, as opposed to those utilizing MyISAM tables.

InnoDB utilizes row–level locking in an effort to get rid of the efficiency difficulties detected at the maximum consumption times of the previous variant of the database engine – MyISAM, which employs table–level locking.

Keeping track of the load produced by the databases in your busy website will let you stop all sorts of overload difficulties that can slow it down and chase away site visitors. For this purpose, we’ve included a descriptive Database Stats tool into the Site Control Panel. There you shall find broad info on the arriving requests to your databases for each hour, day and month.

Based on the volume of daily and per hour queries, you will be able to find out what databases are used the most and consider actions to enhance their work.