Database Manager

Administering your databases is much easier than ever before, due to the Web Hosting Control Panel user interface for MySQL and PgSQL control! In case you do not have extensive expertise in working with databases, you will find it an easy task to use Lokihost’s Database Manager.

You may create a completely new database by merely specifying the user name and security password or make a database back–up with just a click of the mouse. Moreover, within the Data Manager you will possess direct access to the admin area for each individual database, meaning you can almost instantly edit it.

We have designed the manual database backup creation into a very easy task. To do this: inside of the Database Manager, click on the ’clock’ icon on the side of the database that you want to back up and afterwards wait for a couple of seconds for the process to take place. With respect to the size of the database, the building of any back–up file can take somewhere between a couple of seconds and a minute.

You can create as many backups of a database as you desire. We haven’t set any restrictions on the amount of databases you could back up as well.

Just about all of our cloud hosting services plans grant PgSQL support. Although falling behind MySQL in terms of level of popularity and usage, PgSQL databases are famous for offering up the top level of protection for your web site content and articles. That’s the primary reason why companies like Skype and Yahoo rely on PgSQL databases instead of MySQL.

In terms of database management, PgSQL is equally easy to understand as MySQL.

The MySQL databases on Lokihost’s machines utilize the newest release of the InnoDB storage engine. InnoDB is intended to guarantee the optimum functionality for web sites that work with sizeable volumes of data. It provides CPU performance that could not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and gives complete transaction support, which means you can easily update/insert/create/alter/drop several times for a single "operation" of your web app. Furthermore, it takes advantage of row–level locking as an alternative to MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.

Monitoring the load produced by the databases in your dynamic web site will help you prevent any sort of overload difficulties that might slow it down and ward off site visitors. As a result, we have designed a descriptive Database Stats tool within the Web Hosting Control Panel. There you can get all–encompassing information on the incoming requests to your databases for each hour, day and month.

Using the quantity of daily and per hour queries, you’ll be able to determine which databases are being used the most as well as consider procedures to optimize their load.