Databases Manager

Taking control of your databases now is easier than ever, thanks to the Online Control Panel user interface for MySQL and PgSQL administration! Assuming you do not have thorough experience in managing databases, it will be an easy task to manage Add Host’s Databases Manager.

You may create a whole new database by merely specifying the user name and security password or make a database backup with just a click of the mouse. Likewise, via the Data Manager you will possess direct access to the management area for each individual database, which means you can effortlessly update it.

With the Databases Manager you are able to create an archived duplicate of your database whenever you wish! Thus, you will always have a data backup of your dynamic content in case your web site gets hacked or if you accidentally eliminate a database. To produce a backup: click on the ’clock’ icon on the side of a certain database and then wait for a few seconds for the backup process to be performed.

There won’t be any restrictions for 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 common when compared to the popular MySQL databases. Then again, they’re a favored option for programmers who seek the best stability for their web sites and apps. Through the easy–to–use Databases Manager included in the Add Host Control Panel, you can manage all of your PostgreSQL databases with merely a mouse click.

You’ll find PgSQL databases provided automatically with the top Linux shared packages packages. Assuming that you are using a standard hosting package, you’re able to request PgSQL databases to be added in your web hosting account as upgrades.

We have set up InnoDB – the brand new standard MySQL database engine on our web servers. InnoDB is great for massive database websites which need high levels of general performance and scalability. Experiments indicate that web sites using InnoDB based tables reach a 3–fold efficiency increase for very large joins, as compared with those utilizing MyISAM tables.

InnoDB uses row–level locking as a way to eliminate the effectiveness difficulties seen at the maximum consumption times of the prior version of the database engine – MyISAM, which utilizes table–level locking.

We provide you a hassle–free method to keep tabs on the database utilization for your powerful web sites. From the detailed database statistics user interface, which is incorporated into the Online Control Panel, it is possible to track the load produced from your busy websites in real time. The presented info will enable you to evaluate the database load fluctuations every hour, per day or monthly.

You’ll be able to keep track of the database load for all your web sites in the Database Stats area of the Online Control Panel. The table onscreen reveals the database queries accumulated within the present month. To take a look at details for an earlier month, click on the back arrows placed at the top.