Databases Manager

Database management may sound like a difficult job to newbie cloud hosting users, but with the Databases Manager, it’s in fact relatively easy! To set up a whole new database, you only ought to enter the username and password. Database backup copies are just a mouse click away as well.People that desire to look into their databases as well as edit them should use the phpMyAdmin and phpPgAdmin tools.

We have evolved the manual database backup formation into a very simple task. To do this: within the Databases Manager, click on the ’clock’ symbol beside the database that you want to back up and wait for a few seconds for the backup process to take place. With respect to the size of the database, the creation of any back–up file can take between a few seconds and a minute.

You can make as many backups per database as you desire. We’ve not fixed any restrictions on the volume of databases that you can back up too.

Nearly all of the shared website hosting packages present PgSQL support. Although dropping behind MySQL regarding acceptance and usage, PgSQL databases are renowned for providing the top level of safety for your site content and articles. That’s the basic reason why companies like Skype and Yahoo use PgSQL databases as a substitute for MySQL.

With regard to database management, PgSQL is identically easy to use as MySQL.

The MySQL databases on Xanthari Web Systems’s servers work with the latest build of the InnoDB storage engine. InnoDB has been built to guarantee the max efficiency for web sites that operate with big amounts of data. It provides CPU performance that could not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and offers full transaction support, meaning that it is possible to update/insert/create/alter/drop more than once for one "operation" of your application. Furthermore, it works by using row–level locking as an alternative for MyISAM’s table–level locking, that raises multi–user concurrency and effectiveness.

Monitoring the load accumulated by the databases in your powerful web site will help you prevent all kinds of overload difficulties that can slow it down and ward off visitors. Therefore, we have bundled a in depth Database Stats tool inside the Hosting Control Panel. There you shall find complete information regarding the arriving requests to your databases for each hour, day and month.

Depending on the number of daily and per hour queries, you will be able to find out which databases are employed the most and take procedures to optimize their load.