Databases Manager

Database management may sound like a hard task to novice web hosting users, but with our Databases Manager, it’s in fact pretty simple! To configure a brand new database, you simply ought to key in your username and password. Database back–ups are only a mouse click away also.People that desire to explore their databases and edit them may use the phpMyAdmin and phpPgAdmin tools.

Via the Databases Manager it’s possible to make an archived backup of your database whenever you want! This way, you’ll always have a backup of your operating content material in the event your web site gets broken into or you erroneously delete a database. To generate a back–up: click on the ’clock’ image on the side of a given database and after that just wait for a few seconds for the backup process to be concluded.

There are no restricts on the quantity of databases you can back up or the number of backup copies you can make for any database.

PgSQL databases are much less widespread than the widespread MySQL databases. On the other hand, they are a preferred selection for developers who are looking for the maximum safety for their web sites and applications. Due to the user–friendly Databases Manager integrated into the Duo Servers Control Panel, you can administer your PostgreSQL databases with only a click of the mouse.

You can discover PgSQL databases provided by default within the top Linux cloud web hosting plans packages. If you are using a regular hosting package, you’re able to ask for PgSQL databases to be added to your cloud hosting account as upgrades.

The MySQL databases on Duo Servers’s machines work with the most current release of the InnoDB storage engine. InnoDB is intended to ensure the highest functionality for sites that deal with substantial amounts of data. It offers CPU effectiveness that could not be equalled by any other disk–based relational database engines.

InnoDB is ACID–compliant and grants 100% transaction support, which means it’s possible to update/insert/create/alter/drop more than once for one "operation" of your web application. In addition, it takes advantage of row–level locking in lieu of MyISAM’s table–level locking, that boosts multi–user concurrency and efficiency.

From the all–encompassing database statistics tool built into the Control Panel, it’s possible to keep a record of the load created through your active sites twenty–four hours a day. Virtually any overload problem with your web sites could slow the loading speeds and have a damaging effect on the overall impression of your respective site visitors. Therefore, by having data for the database load live, it is possible to eliminate overload problems right away.

The database statistics interface shows information of the quantity of daily, hourly and monthly lookups, so you’re able to analyze the way the load is spread over various periods of time.