Databases Manager

Database management may sound like a complicated job to beginner cloud hosting customers, however with the Databases Manager, it’s actually reasonably easy! To set up a whole new database, you only ought to enter your username and password. Database backups are a mouse click away too.People that wish to explore their databases as well as modify them can make use of the phpMyAdmin and phpPgAdmin tools.

In case you have worked with databases, you know generating a manual database backup just isn’t an elementary task. In order to change this, we have created an easy to understand tool that can back up the entire database with only a single click. The back–up file shall be set for you in under a minute, based on the size of the chosen database.

You won’t notice any restrictions on the amount of backups you could make for a specific database.

You will find PgSQL support in our Linux cloud hosting services bundles. PgSQL databases are not as famous and widely used as MySQL, nonetheless they provide the maximum level of protection for your site content and articles. Because of this, a lot of popular companies such as Skype and Yahoo take advantage of PgSQL databases. Dealing with PgSQL databases is as elementary as MySQL, as a result of the user–friendly user interface of the Databases Manager.

PgSQL databases are integrated by default with the most sophisticated web hosting packages. For the normal bundles, they’re included as upgrades.

The MySQL databases on Dotifi’s servers work with the most recent build of the InnoDB storage engine. InnoDB was meant to ensure the highest efficiency for web sites that work with large volumes of data. It supplies CPU performance that can not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives 100% transaction support, which means you’re able to update/insert/create/alter/drop a couple of times for a single "operation" of your web application. Additionally, it takes advantage of row–level locking in contrast to MyISAM’s table–level locking, that raises multi–user concurrency and performance.

With the all–encompassing database stats tool built–into the Website Control Panel, it’s possible to keep a record of the stress generated through your dynamic websites 24 / 7. Any overload difficulty with your web sites could slow the loading rates and have a bad influence over the overall experience of your website visitors. Thus, by having data for the database work in real time, it is also possible to fix overload troubles as quickly as possible.

The database data interface shows details of the amount of daily, hourly and monthly queries, allowing you to examine just how the load is distributed over different time periods.