Database Manager

Overseeing your databases is less complicated than ever before, due to the Control Panel interface for MySQL and PgSQL management! Even if you do not have detailed experience of utilizing databases, you will find it simple to work with Host Composer’s Database Manager.

You may create a brand new database by only keying in the user name and security password or produce a database back–up with merely a click of the mouse. Also, through the Data Manager you will get direct access to the administrator area for every database, meaning you can conveniently edit it.

Assuming you have dealt with databases, you are aware that generating a manual database backup is just not a simple task. So as to change this, we have made an effortless to use tool that will back up your whole database with merely one click. The back–up file shall be prepared for you in less than a minute, based on the size of the selected database.

There aren’t any confines on how many copies you can make for a selected database.

PgSQL databases are much less sought after as compared to the widespread MySQL databases. Nevertheless, they’re a favorite alternative for developers who are looking for the uttermost security for their websites and web apps. Through the intuitive Database Manager built into the Host Composer Control Panel, you can administer your PostgreSQL databases with only a click of the mouse.

You will find PgSQL databases bundled by default with the best Linux shared website hosting packages. If you are using a regular hosting package, it’s possible to request PgSQL databases to be included in your website hosting account as upgrades.

With Host Composer, you’ll consistently discover the most current build of MySQL and the default MySQL storage engine – InnoDB, installed.

InnoDB is definitely more stable in comparison to the past storage engine’s edition – MyISAM. It is ACID–compliant and, above all – it has complete transaction support. You’ll find, it takes advantage of row–level locking, as an alternative for MyISAM’s table–level locking, that used to result in performance problems at high usage periods.

Through the in–depth database stats tool included in the Control Panel, you are going to be able to keep track of the stress generated by your active web sites at any hour. Any overload problem with your websites could lower the loading speeds and have a bad influence over the online experience of your respective site visitors. So, having information for the database load immediately, you’ll be able to mend overload troubles in a timely manner.

The database data user interface displays information of the number of daily, hourly and monthly lookups, so you’re able to assess just how the load is distributed over several periods of time.