Database Manager

Overseeing your databases is much easier than ever, due to the Web Hosting Control Panel interface for MySQL and PgSQL control! Assuming you do not have extensive experience in working with databases, it will be an easy task to manage the Database Manager.

You can create a new database by only typing the user name and security password or generate a database back–up with a mouse click. Also, via the Data Manager you will have direct access to the administrative area for each individual database, so you’re able to quickly edit it.

Within the Database Manager it is easy to make an archived duplicate of your database when you want! This way, you are going to always have a backup of your active content in case your web site gets broken into or if you erroneously remove a database. To create a back–up: click the ’clock’ image on the side of a particular database and after that simply wait for a few seconds for the backup process to be performed.

There aren’t any boundaries about the quantity of databases you are able to back up or the amount of backups you can create for a database.

Just about all of A Local Website’s Linux cloud hosting plans bundles grant PgSQL support. While dropping behind MySQL when considering reputation and application, PgSQL databases are famous for supplying the top level of protection for your website content and articles. This is the basic reason why companies such as Skype and Yahoo make use of PgSQL databases as a substitute for MySQL.

When it comes to database administration, PgSQL is just as effortless to use as MySQL.

With A Local Website, you shall inevitably find the most up–to–date version of MySQL plus the default MySQL storage engine – InnoDB, mounted.

InnoDB is more stable compared to the old storage engine’s edition – MyISAM. It is ACID–compliant and, above all – it gives full transaction support. Furthermore, it employs row–level locking, in contrast to MyISAM’s table–level locking, that previously used to trigger performance problems at peak usage times.

We provide you an easy way for you to track the database usage of your powerful websites. From the in–depth database statistics interface, that is built into the Web Hosting Control Panel, you’re able to monitor the load made through your active websites in real time. The offered information will help you to assess the database load changes per hour, daily or monthly.

It is easy to observe the database load for all of your web sites from the Database Stats portion of the Web Hosting Control Panel. The table onscreen features the database queries made within the present month. To have a look at information for a previous month, all you have to do is click on the back arrows situated at the top.