Database Manager

The Database Manager in the Website Control Panel incorporates a refined nevertheless straightforward interface. It’s possible to set up a brand new MySQL or PostgreSQL database by just typing in a user name and security password. Also, you may create a backup file or customize the password of a database with a click of the mouse.

Within the Database Manager you have direct access to the management area for all of your databases, in order to make simple and easy alterations if you happen to have to.

Provided you have worked with databases, you know creating a manual database backup is not a simple task. As a way to change this, we have developed a simple and easy to use tool that can back up the entire database with just one mouse click. The back–up file is going to be prepared for you in less than a minute, depending on the size of the selected database.

There are no confines on exactly how many backups you may make for a chosen database.

PgSQL databases are much less widespread in comparison to the popular MySQL databases. However, they are a favored alternative for programmers seeking the ultimate stability for their sites and web apps. Via the intuitive Database Manager integrated into the byowebhosting Control Panel, you can administer all of your PostgreSQL databases with simply a mouse click.

You can find PgSQL databases incorporated by default within the advanced cloud web hosting plans packages. If you are with a basic hosting package, it is possible to ask for PgSQL databases to be added in your website hosting account as upgrades.

We have incorporated InnoDB – the new standard MySQL database engine on our web servers. InnoDB is perfect for massive database websites which need high levels of performance and scalability. Trials have established that sites working with InnoDB based tables achieve a 3–fold effectiveness grow for large joins, compared to those applying MyISAM tables.

InnoDB works by using row–level locking in an effort to eliminate effectiveness difficulties spotted at the top usage times of the previous variant of the database engine – MyISAM, which utilizes table–level locking.

Through the thorough database stats tool built–into the Website Control Panel, you are going to be able to keep a record of the load accumulated from your busy sites twenty–four hours a day. Any overload trouble with your web sites could lower the loading rates and have a negative influence over the overall experience of your respective visitors. Hence, by having information about the database load right away, it is also possible to fix overload problems as fast as possible.

The database stats user interface reveals information of the quantity of daily, hourly and monthly queries, allowing you to examine how the load is distributed over several time periods.