Database Manager

Taking control of your databases is less complicated than in the past, on account of the Online Control Panel interface for MySQL and PgSQL control! Assuming you do not have substantial knowledge in working with databases, you will find it very easy to handle our Database Manager.

You can create a new database simply by keying in the username and password or create a database backup with merely a mouse click. Moreover, from the Data Manager you will get direct access to the administrative area for each individual database, to help you to immediately manage it.

We have developed the manual database back–up formation into a very easy activity. To execute that: inside the Database Manager, click on the ’clock’ image on the side of the database that you plan to back up and hang on for a couple of seconds for the backup process to take place. With regards to the size of the database, the creation of any backup file can take somewhere between a couple of seconds and a minute.

You may create as many copies of a database as you want. We haven’t set any boundaries about the number of databases that you could back up either.

PgSQL databases are less popular when compared to the well–known MySQL databases. Having said that, they represent a preferred choice for web developers seeking the uttermost safety for their websites and apps. Due to the easy–to–use Database Manager built–into the Affordable Web Hosting for Small Business Control Panel, you can control your PostgreSQL databases with simply a click of the mouse.

You are going to find PgSQL databases included by default within the advanced Linux shared hosting packages. If you are using a regular hosting package, you’ll be able to request PgSQL databases to be included in your hosting account as upgrades.

The MySQL databases on our web servers employ the newest release of the InnoDB storage engine. InnoDB is developed to guarantee the maximum efficiency for websites that operate with huge volumes of data. It presents CPU efficiency that could not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, meaning that you are able to update/insert/create/alter/drop many times for a single "operation" of your web application. At the same time, it employs row–level locking instead of MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

We offer you an easy solution to track the database utilization for your powerful web sites. From the descriptive database statistics interface, that is integrated into the Online Control Panel, you are able to observe the load produced from your busy sites in real time. The offered data will help you analyze the database load changes each hour, daily or monthly.

You’re able to monitor the database load for your websites in the Database Stats section of the Online Control Panel. The table on–screen presents the database lookups generated in the present month. To inspect information and facts for an earlier month, simply click on the back arrows positioned at the top.