Databases Manager

Database management might sound like a difficult job to inexperienced hosting customers, but with XFO Wholesale’s Databases Manager, it’s in fact quite simple! To create a brand new database, you just ought to type in the username and password. Database backups are just a mouse click away as well.People who wish to explore their databases and revise them should use the phpMyAdmin and phpPgAdmin tools.

We’ve made the manual database back–up creation into a simple activity. To do so: within the Databases Manager, click on the ’clock’ icon next to the database that you want to back up and hang on for a few seconds for the process to take place. With respect to the size of the database, the generation of the backup file is going to take between a few seconds and a minute.

You can create as many copies of a database as you desire. We haven’t specified any boundaries for the amount of databases you can back up too.

PgSQL databases are significantly less popular than the widespread MySQL databases. Then again, they represent a preferred alternative for developers who seek the uttermost security for their sites and applications. Through the incredibly user–friendly Databases Manager incorporated into the XFO Wholesale Control Panel, you can manage all your PostgreSQL databases with simply a click of the mouse.

You’ll find PgSQL databases bundled automatically inside the best Linux web hosting plans packages. Provided that you are with a regular hosting package, it is possible to ask for PgSQL databases to be added to your website hosting account as upgrades.

With XFO Wholesale, you’ll regularly find the most current variant of MySQL plus the default MySQL storage engine – InnoDB, set up.

InnoDB is a lot more dependable than the past storage engine’s edition – MyISAM. It is ACID–compliant and, above all – it provides full transaction support. Furthermore, it works by using row–level locking, as opposed to MyISAM’s table–level locking, that would always cause efficiency troubles at peak usage occasions.

Checking the load caused by the databases within your busy web site assists you to avoid all sorts of overload troubles that might slow it down and chase away website visitors. Therefore, we have built–in a in–depth Database Stats tool into your Site Control Panel. There you can get detailed information regarding the arriving requests to your databases for each hour, day and month.

In line with the volume of daily and hourly queries, it will be easy to find out what databases are being used the most and also consider procedures to enhance their load.