Database Manager

The Database Manager within our Control Panel has a robust but uncomplicated interface. You’re able to set up a new MySQL or PostgreSQL database by just typing a username and password. Moreover, you could make a backup file or customize the password of the database with simply a mouse click.

Through the Database Manager you’ve got immediate access to the management area for all of your databases, so its possible to make effortless changes in the event you have to.

We’ve evolved the manual database back–up generation into a quite simple job. To do this: inside of the Database Manager, click the ’clock’ image on the side of the database that you plan to back up and wait around for a couple of seconds for the process to take place. Depending upon the size of the database, the generation of a backup file will require between a few seconds and a minute.

You may create as many backups per database as you want. We haven’t determined any boundaries for the number of databases that you can back up as well.

PgSQL databases are less common than the popular MySQL databases. On the other hand, they are a favored choice for programmers seeking the ultimate security for their websites and web applications. Because of the incredibly user–friendly Database Manager built–into the AceHoster.com Control Panel, you can control your PostgreSQL databases with merely a mouse click.

You will find PgSQL databases integrated automatically inside the advanced shared website hosting plans packages. Assuming that you are with a standard hosting package, it is possible to ask for PgSQL databases to be included in your cloud hosting account as upgrades.

We have installed InnoDB – the new standard MySQL database engine on all of our servers. InnoDB is ideal for large database sites that require high levels of effectiveness and scalability. Tests demonstrate that web sites working with InnoDB based tables achieve a 3–fold general performance increase for very big joins, when compared to those utilizing MyISAM tables.

InnoDB takes advantage of row–level locking in an effort to remove the performance issues discovered at the high consumption times of the previous version of the database engine – MyISAM, which utilizes table–level locking.

From the in depth database stats tool integrated into the Control Panel, it is possible to keep track of the stress accumulated through your dynamic websites at any hour. Virtually any overload issue with your websites could reduce the loading rates and have a damaging impact on the overall experience of your website visitors. Consequently, having details for the database work live, you will be able to eliminate overload difficulties at once.

The database data user interface shows information of the number of daily, hourly and monthly queries, allowing you to assess just how the load is spread over various time periods.