Databases Manager

Database management may appear like a complicated job to novice website hosting customers, but with the Databases Manager, it’s in fact pretty simple! To create a new database, you simply need to key in the username and password. Database back–ups are only a mouse click away also.People that wish to explore their databases as well as change them can make use of the phpMyAdmin and phpPgAdmin tools.

We’ve evolved the manual database backup formation into a very simple job. To execute that: within the Databases Manager, click on the ’clock’ icon near the database that you want to back up and wait for a couple of seconds for the process to take place. Depending upon the size of the database, the creation of any backup file can take somewhere between a couple of seconds and a minute.

You may create as many backup copies per database as you want. We’ve not specified any limits for the amount of databases that you can back up too.

PgSQL databases are less common as opposed to the popular MySQL databases. On the other hand, they’re a favored option for designers who seek the utmost security for their web sites and web applications. Due to the user–friendly Databases Manager built–into the Bcn Cluster Control Panel, you can control your PostgreSQL databases with merely a click of the mouse.

You can discover PgSQL databases included automatically inside of the top cloud website hosting packages. Provided that you are using a regular hosting package, it is possible to request PgSQL databases to be included in your web hosting account as upgrades.

We have set up InnoDB – the new default MySQL database engine on all of our servers. InnoDB is great for massive database sites which require high levels of effectiveness and scalability. Trials have shown that sites utilizing InnoDB based tables achieve a 3–fold general performance increase for substantial joins, when compared with those applying MyISAM tables.

InnoDB works by using row–level locking in order to clear away the operation difficulties noticed at the maximum consumption times of the prior version of the database engine – MyISAM, which employs table–level locking.

Through the thorough database stats tool included in the Online Control Panel, it is possible to keep tabs of the stress generated through your active web sites 24 / 7. Every overload trouble with your websites could slow the loading speeds and have a negative influence over the overall impression of your respective website visitors. Consequently, by having info about the database work right away, you are able to fix overload problems in a timely manner.

The database statistics interface displays details of the number of daily, hourly and monthly queries, so you can evaluate just how the load is allocated over various time periods.