Databases Manager

The Databases Manager in the Web Hosting Control Panel comes with an effective but still straightforward interface. It’s possible to set up a new MySQL or PostgreSQL database by just typing a username and security password. Also, you may create a back–up file or customize the security password of your database with merely a click of the mouse.

With the Databases Manager you will have immediate access to the administrative area for every one of your databases, so that you can make simple adjustments when you have to.

Through the Databases Manager you can produce an archived duplicate of your database whenever you desire! This way, you’ll always have a data backup of your dynamic content in case your web site gets hacked or you mistakenly remove a database. To create a backup: click on the ’clock’ symbol next to a given database and afterwards wait for a couple of seconds for the backup process to be executed.

There won’t be any boundaries about the amount of databases you would be able to back up or the amount of back–ups you can make for a database.

You will find PgSQL support in all of our Linux cloud website hosting packages offers. PgSQL databases might not be as popular and frequently used as MySQL, nevertheless they provide you with the maximum level of safety for your web site content. For this reason, many famous companies like Skype and Yahoo utilize PgSQL databases. Dealing with PgSQL databases is as simple and easy as MySQL, due to the incredibly user–friendly interface of the Databases Manager.

PgSQL databases are provided by default in the most sophisticated web hosting plans. For the regular plans, they’re suggested as upgrades.

The MySQL databases on our machines utilize the latest release of the InnoDB storage engine. InnoDB is created to guarantee the top performance for sites that deal with significant amounts of data. It boasts CPU effectiveness that can not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and gives full transaction support, which means you can update/insert/create/alter/drop more than once for one "operation" of your application. Furthermore, it takes advantage of row–level locking rather than MyISAM’s table–level locking, that enhances multi–user concurrency and efficiency.

From the comprehensive database statistics tool built into the Web Hosting Control Panel, you will be able to make a record of the stress generated by your active web sites at any hour. Any overload problem with your websites could slow the loading speeds and have a bad impact on the overall experience of your site visitors. Consequently, having details for the database work in real time, you are able to mend overload troubles as soon as possible.

The database data interface displays information of the volume of daily, hourly and monthly lookups, which means you can evaluate how the load is spread over different time frames.