Database Manager

Database management may sound like a hard task to novice web hosting customers, nevertheless with the Database Manager, it’s actually really simple! To set up a brand new database, you only ought to enter the username and password. Database backups are simply a mouse click away too.Those who choose to look into their databases and then edit them can use the phpMyAdmin and phpPgAdmin tools.

Within the Database Manager you can easily make an archived copy of your database whenever you would like! This way, you are going to always have a back–up of your dynamic content material if your website gets hacked or if you incorrectly delete a database. To make a backup: click on the ’clock’ icon alongside a particular database and after that wait for a couple of seconds for the process to be finalized.

There are not any restrictions for the quantity of databases you would be able to back up or the quantity of back–ups you can make for a database.

A majority of the Linux shared web hosting packages present PgSQL support. Although dropping behind MySQL with regard to popularity and usage, PgSQL databases are renowned for offering the best level of safety for your web site content. That is the key reason why companies like Skype and Yahoo use PgSQL databases as a substitute for MySQL.

When it comes to database administration, PgSQL is equally uncomplicated as MySQL.

The MySQL databases on our servers employ the most up–to–date release of the InnoDB storage engine. InnoDB is meant to guarantee the maximum functionality for web sites that operate with significant volumes of data. It offers CPU performance that can not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, so that it is easy to update/insert/create/alter/drop many times for one "operation" of your application. Additionally, it uses row–level locking as an alternative for MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

Via the detailed database stats tool built–into the Web Hosting Control Panel, it will be possible to make a record of the load created through your active sites round the clock. Any overload trouble with your sites could lower the loading speeds and have a damaging impact on the online experience of your visitors. Which means that, by having details for the database work right away, you will be able to resolve overload problems straight away.

The database statistics user interface displays data of the amount of daily, hourly and monthly lookups, so you’re able to evaluate just how the load is allocated over different time frames.