Database Manager

Database management may appear like a hard task to inexperienced web hosting clients, but with Xedos Cloud’s Database Manager, it’s actually reasonably easy! To create a brand new database, you only ought to key in your username and password. Database back–ups are a click away at the same time.People that need to explore their databases as well as change them can make use of the phpMyAdmin and phpPgAdmin tools.

We have designed the manual database backup creation into a quite easy activity. To do this: inside of the Database Manager, click the ’clock’ icon next to the database that you would like to back up and then hang on for a couple of seconds for the backup process to take place. Depending on the size of the database, the building of the back–up file will need between a few seconds and a minute.

You can create as many backup copies per database as you would like. We’ve not determined any boundaries about the amount of databases that you could back up too.

Almost all of Xedos Cloud’s Linux cloud hosting packages deliver PgSQL support. Whilst dropping behind MySQL with respect to level of popularity and employment, PgSQL databases are renowned for providing the highest level of protection for your website content and articles. It is the main reason why companies such as Skype and Yahoo rely on PgSQL databases as an alternative to MySQL.

When considering database management, PgSQL is identically uncomplicated as MySQL.

The MySQL databases on Xedos Cloud’s machines utilize the latest version of the InnoDB storage engine. InnoDB has been meant to ensure the maximum functionality for websites that work with massive volumes of data. It boasts CPU performance that can not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives 100% transaction support, which means you can update/insert/create/alter/drop a couple of times for one "operation" of your web app. In addition, it uses row–level locking rather than MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

Tracking the load caused by the databases in your powerful web site will let you stop all sorts of overload difficulties that could slow it down and chase away visitors. For that reason, we’ve provided a in–depth Database Stats tool in the Hosting Control Panel. There you can see all–encompassing information about the inbound requests to your databases for each hour, day and month.

Based on the quantity of daily and hourly queries, it will be straightforward to find out which databases are employed the most as well as consider actions to enhance their load.