Database Manager

Database management may appear like a difficult job to novice cloud hosting users, however with our Database Manager, it’s in fact really simple! To create a new database, you only have to provide the username and password. Database back–ups are a mouse click away also.People that would like to examine their databases and also change them are able to use the phpMyAdmin and phpPgAdmin tools.

We’ve evolved the manual database backup generation into a simple activity. To execute this: inside of the Database Manager, click the ’clock’ image beside the database that you intend to back up and wait around for a couple of seconds for the process to take place. With regards to the size of your database, the generation of any backup file can take somewhere between a couple of seconds and a minute.

You can make as many copies per database as you want. We’ve not specified any restrictions for the amount of databases you could back up too.

A lot of Avallach Technology’s cloud hosting packages bundles deliver PgSQL support. While dropping behind MySQL regarding acceptance and utilization, PgSQL databases are famous for giving the maximum level of security for your site content and articles. This is the reason why companies such as Skype and Yahoo make use of PgSQL databases as opposed to MySQL.

With respect to database management, PgSQL is as straightforward as MySQL.

The MySQL databases on Avallach Technology’s machines use the most recent build of the InnoDB storage engine. InnoDB is designed to ensure the top effectiveness for web sites that process sizeable volumes of data. It features CPU efficiency that can not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and gives full transaction support, which means that you are able to update/insert/create/alter/drop a couple of times for one "operation" of your app. Additionally, it takes advantage of row–level locking in lieu of MyISAM’s table–level locking, that increases multi–user concurrency and functionality.

We provide you a simple and easy way for you to keep tabs on the database usage for your busy web sites. Via the thorough database stats user interface, that’s built into the Web Site Control Panel, you’ll be able to track the load produced from your busy sites in real time. The provided details will help you assess the database load fluctuations each hour, daily or each month.

You’re able to keep track of the database load for all of your websites through the Database Stats area of the Web Site Control Panel. The table onscreen reveals the database lookups accumulated within the present month. To look at information for a previous month, simply click on the back arrows positioned at the top.