Database Manager

The Database Manager within our Online Control Panel includes an effective nevertheless uncomplicated user interface. You’re able to configure a whole new MySQL or PostgreSQL database by just typing in a user name and security password. Moreover, you may create a backup file or change the password of your database with only a click of the mouse.

Through the Database Manager you’ve got direct access to the administration area for all your databases, which means you can make uncomplicated alterations if you ever need to.

Provided you have worked with databases, you know generating a manual database backup just isn’t a basic job. In an effort to change this, we have made a simple tool that will back up the entire database with one click of the mouse. The back–up file will be available for you in less than a minute, with regards to the size of the selected database.

There are not any limits on the total number of copies you can make for any particular database.

PgSQL databases are significantly less widespread in comparison to the prevalent MySQL databases. However, they represent a preferred choice for web developers who are looking for the maximum security for their websites and web apps. Because of the intuitive Database Manager included in the Host Acadiana Control Panel, you can control your PostgreSQL databases with a simple click of the mouse.

Yow will discover PgSQL databases bundled by default in the best shared services packages. Provided that you are with a standard hosting package, it’s possible to request PgSQL databases to be added to your web hosting account as upgrades.

We’ve installed InnoDB – the new standard MySQL database engine on all of our servers. InnoDB is made for large database web sites which require high functionality and scalability. Trials have indicated that web sites applying InnoDB based tables reach a 3–fold general performance increase for large joins, in comparison with those utilizing MyISAM tables.

InnoDB employs row–level locking in order to eliminate operation difficulties observed at the top consumption times of the previous release of the database engine – MyISAM, which utilizes table–level locking.

From your detailed database statistics tool integrated into the Online Control Panel, you are going to be able to make a record of the stress produced from your active websites around the clock. Any overload trouble with your web sites can reduce the loading rates and have a negative effect on the overall experience of your respective website visitors. Therefore, by having data for the database load instantly, it will be easy to resolve overload issues as soon as possible.

The database data interface displays details of the amount of daily, hourly and monthly queries, to help you to review the way the load is allocated over different periods of time.