Databases Manager

Taking control of your databases is easier than ever before, on account of the Hosting Control Panel user interface for MySQL and PgSQL administration! Even though you may not have extensive experience of managing databases, it will be easy to manage Broadmax - ERPNODE’s Databases Manager.

You can create a new database just by keying in the username and password or create a database back–up with merely a mouse click. Also, via the Data Manager you will have direct access to the administrative area for each and every database, to help you to instantly alter it.

Assuming you have dealt with databases, you know that making a manual database back–up is just not a basic task. In order to change this, we have developed an effortless to use tool that can back up your complete database with a single click of the mouse. The backup file will be prepared for you in less than a minute, with respect to the size of the chosen database.

There aren’t any restrictions on the total number of back–ups you can create for a selected database.

You will find PgSQL support in each of our cloud website hosting plans packages. PgSQL databases may not be as popular and widespread as MySQL, nonetheless they supply you with the highest possible level of protection for your website content. For this reason, a lot of well–known companies such as Skype and Yahoo take advantage of PgSQL databases. Taking care of PgSQL databases is as simple as MySQL, as a result of the intuitive interface of the Databases Manager.

PgSQL databases are bundled by default inside the most advanced web hosting plans. For the regular bundles, they’re included as upgrades.

We have added InnoDB – the brand new default MySQL database engine on our servers. InnoDB is perfect for big database sites which need high levels of functionality and scalability. Trials have shown that web sites employing InnoDB based tables achieve a 3–fold efficiency increase for huge joins, in comparison with those working with MyISAM tables.

InnoDB uses row–level locking as a way to remove the overall performance difficulties witnessed at the high usage times of the previous release of the database engine – MyISAM, which uses table–level locking.

Keeping tabs on the load generated by the databases on your active web site makes it possible to reduce all sorts of overload issues that could slow it down and ward off website visitors. For that reason, we have designed a in–depth Database Stats tool directly into the Hosting Control Panel. There you will find all–inclusive info on the inbound requests to your databases for each and every hour, day and month.

Depending on the number of day–to–day and hourly queries, you are able to determine which databases are being used the most and take steps to optimize their work.