Databases Manager

The Databases Manager inside our Website Control Panel provides an effective but straightforward interface. It is easy to set up a completely new MySQL or PostgreSQL database by just specifying a username and password. Furthermore, you may create a back–up file or change the password of your database with merely a click of the mouse.

Through the Databases Manager you will possess immediate access to the admin area for each of your databases, so you can make effortless adjustments in the event you need to.

Through the Databases Manager it is easy to generate an archived copy of your database anytime you need! This way, you are going to always have a data backup of your dynamic content material in case your website gets broken into or you accidentally delete a database. To make a back–up: click on the ’clock’ image beside a particular database and then just wait for a couple of seconds for the process to be done.

There aren’t any restrictions about the quantity of databases you are able to back up or the quantity of backups you may make for a database.

You are going to find PgSQL support in all our Linux cloud web hosting packages packages. PgSQL databases aren’t as famous and widely used as MySQL, nevertheless they provide the highest possible level of safety for your website content and articles. Therefore, many popular companies such as Skype and Yahoo implement PgSQL databases. Taking care of PgSQL databases is as elementary as MySQL, on account of the intuitive interface of the Databases Manager.

PgSQL databases are included automatically inside of the most innovative web hosting bundles. For the basic plans, they’re included as upgrades.

The MySQL databases on our web servers employ the newest release of the InnoDB storage engine. InnoDB was designed to ensure the optimum performance for sites that deal with sizeable amounts of data. It presents CPU effectiveness that could not be equalled by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives 100% transaction support, meaning you’re able to update/insert/create/alter/drop more than once for a single "operation" of your application. Moreover, it makes use of row–level locking as an alternative to MyISAM’s table–level locking, that increases multi–user concurrency and performance.

From your broad database stats tool integrated into the Website Control Panel, it’s possible to keep tabs of the load produced from your active web sites around the clock. Every single overload difficulty with your sites could lower the loading rates and have a negative impact on the online experience of your site visitors. So, having info for the database work in real time, it will be easy to resolve overload problems immediately.

The database stats interface shows info of the volume of daily, hourly and monthly queries, so its possible to assess the way the load is allocated over different time frames.