Database Manager

Database management might sound like a difficult job to inexperienced website hosting users, but with Apni Hosting’s Database Manager, it’s in fact pretty simple! To configure a brand new database, you just need to enter your username and password. Database back–ups are just a mouse click away also.People that choose to look into their databases and then change them should use the phpMyAdmin and phpPgAdmin tools.

With the Database Manager it is easy to produce an archived duplicate of your database whenever you want! Thus, you will always have a back–up of your operating information in case your website gets broken into or if you mistakenly remove a database. To produce a backup: click on the ’clock’ symbol alongside a given database and after that simply wait for a couple of seconds for the backup process to be carried out.

There aren’t any restrictions about the number of databases you are able to back up or the volume of backup copies you can make for a database.

PgSQL databases are significantly less sought after as compared to the widespread MySQL databases. Nevertheless, they are a favored alternative for web developers who are looking for the utmost protection for their web sites and apps. Via the incredibly user–friendly Database Manager built into the Apni Hosting Control Panel, you can control all your PostgreSQL databases with merely a mouse click.

You are going to find PgSQL databases incorporated by default with the best Linux web hosting packages. In case you are using a regular hosting package, you are able to ask for PgSQL databases to be included in your hosting account as upgrades.

The MySQL databases on Apni Hosting’s web servers utilize the most current build of the InnoDB storage engine. InnoDB was created to ensure the optimum effectiveness for sites that process big volumes of data. It provides CPU performance that can not be matched by any other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, so that you can easily update/insert/create/alter/drop a couple of times for one "operation" of your web application. Additionally, it employs row–level locking as an alternative for MyISAM’s table–level locking, that increases multi–user concurrency and performance.

Checking the load made by the databases in your busy site will let you prevent virtually any overload troubles that might slow it down and ward off site visitors. For this specific purpose, we have included a in depth Database Stats tool into the Hosting Control Panel. There you shall find broad information on the inbound requests to your databases for every single hour, day and month.

Using the number of daily and per hour queries, you will be able to determine which databases are employed the most and take procedures to optimize their work.