Database Manager

Administering your databases is less complicated than ever before, as a result of Control Panel user interface for MySQL and PgSQL management! Provided you do not have thorough knowledge of working with databases, you will find it effortless to use the Database Manager.

You could make a whole new database by just specifying the user name and security password or make a database back–up with merely a click of the mouse. Likewise, with the Data Manager you will get direct access to the management area for every database, so you’re able to almost instantly revise it.

We’ve changed the manual database back–up creation into a quite simple task. To do this: inside of the Database Manager, click on the ’clock’ icon near the database that you want to back up and after that wait for a few seconds for the backup process to take place. Depending on 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 backups per database as you want. We’ve not determined any confines on the volume of databases you could back up too.

A lot of HostExcel’s shared hosting plans deliver PgSQL support. Although dropping behind MySQL with respect to level of popularity and utilization, PgSQL databases are renowned for delivering the highest level of protection for your website content and articles. That’s the main reason why companies such as Skype and Yahoo use PgSQL databases as opposed to MySQL.

When considering database management, PgSQL is just as straightforward as MySQL.

With HostExcel, you shall consistently discover the newest build of MySQL and the default MySQL storage engine – InnoDB, mounted.

InnoDB is more stable than the old storage engine’s edition – MyISAM. It’s ACID–compliant and, most of all – it has total transaction support. Furthermore, it employs row–level locking, instead of MyISAM’s table–level locking, that seemed to lead to effectiveness troubles at peak usage times.

We supply you a very easy approach to observe the database consumption on your dynamic web sites. From your in–depth database statistics user interface, that is integrated into the Control Panel, you are able to observe the load accumulated through your dynamic sites in real time. The presented data will let you assess the database load fluctuations every hour, every day or each month.

You can keep an eye on the database load for all of your websites through the Database Stats section of the Control Panel. The table on–screen features the database queries made in the present month. To examine information and facts for a past month, all you have to do is click on the back arrows placed at the top.