Databases Manager

Database management may seem like a difficult job to beginner web hosting customers, nevertheless with the Databases Manager, it’s in fact relatively easy! To set up a whole new database, you just ought to enter the username and password. Database backup copies are only a click away also.Those who need to look into their databases as well as change them should use the phpMyAdmin and phpPgAdmin tools.

We’ve transformed the manual database back–up formation into a very simple task. To execute this: within the Databases Manager, click the ’clock’ icon near the database that you would like to back up and then hang on for a few seconds for the backup process to take place. With respect to the size of the database, the generation of any back–up file will need somewhere between a couple of seconds and a minute.

You may create as many backups of a database as you wish. We haven’t fixed any restrictions about the number of databases you can back up too.

Nearly all of our cloud plans bundles grant PgSQL support. Although falling behind MySQL with respect to global recognition and utilization, PgSQL databases are renowned for giving the top level of security for your web site content and articles. This is the basic reason why businesses like Skype and Yahoo make use of PgSQL databases as an alternative to MySQL.

With regards to database administration, PgSQL is identically easy to use as MySQL.

The MySQL databases on our machines employ the latest build of the InnoDB storage engine. InnoDB was built to guarantee the optimum efficiency for sites that process substantial volumes of data. It features CPU efficiency that can not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants 100% transaction support, so that it is possible to update/insert/create/alter/drop more than once for one "operation" of your web app. Furthermore, it works by using row–level locking in contrast to MyISAM’s table–level locking, that improves multi–user concurrency and effectiveness.

With the thorough database stats tool incorporated into the Web Hosting Control Panel, it’s possible to keep tabs of the load produced through your dynamic sites 24 / 7. Every single overload difficulty with your web sites can slow the loading speeds and have a damaging effect on the overall impression of your respective visitors. Thus, by having info about the database load right away, it is also possible to mend overload difficulties straight away.

The database stats user interface reveals information of the amount of daily, hourly and monthly queries, which means you can assess how the load is distributed over several periods of time.