Databases Manager

Database management might sound like a difficult job to beginner website hosting customers, nevertheless with our Databases Manager, it’s in fact simple! To configure a brand new database, you simply ought to type in the username and password. Database backup copies are a click away as well.Those who want to look into their databases and edit them should use the phpMyAdmin and phpPgAdmin tools.

We’ve designed the manual database back–up formation into a very simple task. To do so: within the Databases Manager, click the ’clock’ image near the database that you want to back up and then hang on for a few seconds for the process to take place. Depending on the size of your database, the creation of a back–up file is going to take somewhere between a couple of seconds and a minute.

You may create as many backups per database as you desire. We have not set any limitations on the amount of databases that you could back up too.

You can find PgSQL support in every one of our Linux cloud hosting service bundles. PgSQL databases aren’t as sought after and frequently used as MySQL, nevertheless they offer the maximum level of stability for your web site content and articles. For this reason, a number of popular companies such as Skype and Yahoo make use of PgSQL databases. Dealing with PgSQL databases is as simple as MySQL, due to the easy–to–use interface of the Databases Manager.

PgSQL databases are bundled automatically inside of the most advanced web hosting plans. For the regular plans, they’re offered as upgrades.

The MySQL databases on DIXIE SERVERS’s web servers utilize the most up–to–date release of the InnoDB storage engine. InnoDB is built to guarantee the top effectiveness for web sites that process large amounts of data. It features CPU efficiency that could not be equalled by any other different disk–based relational database engines.

InnoDB is ACID–compliant and offers 100% transaction support, meaning it is easy to update/insert/create/alter/drop several times for one "operation" of your web app. At the same time, it makes use of row–level locking in lieu of MyISAM’s table–level locking, that boosts multi–user concurrency and performance.

Keeping tabs on the load caused by the databases within your dynamic site will help you avoid all sorts of overload issues that can slow it down and chase away website visitors. For this specific purpose, we have designed a detailed Database Stats tool into the Site Control Panel. There you shall find comprehensive info on the incoming requests to your databases for every hour, day and month.

Depending on the volume of day–to–day and per hour queries, you are going to be able to find out what databases are utilized the most as well as take steps to enhance their load.