Databases Manager

The Databases Manager in our Control Panel includes an effective yet convenient to use interface. You are able to configure a whole new MySQL or PostgreSQL database by just specifying a username and password. Also, you can make a back–up file or alter the password of any database with merely a mouse click.

With the Databases Manager you’ll have direct access to the administrator area for every one of your databases, allowing you to make effortless corrections in case you have to.

We’ve transformed the manual database back–up creation into a quite simple activity. To do this: inside of the Databases Manager, click the ’clock’ image 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. With regards to the size of the database, the building of a back–up file can take between a few seconds and a minute.

You can make as many backup copies per database as you would like. We’ve not fixed any limitations on the volume of databases you can back up too.

You’ll find PgSQL support in each of our Linux cloud web hosting bundles. PgSQL databases aren’t as sought after and widespread as MySQL, nonetheless they provide you with the top level of stability for your website content and articles. Because of this, a number of well–known brands like Skype and Yahoo make use of PgSQL databases. Dealing with PgSQL databases is as simple as MySQL, as a result of the intuitive interface of the Databases Manager.

PgSQL databases are included by default within the most sophisticated web hosting plans. For the standard bundles, they’re suggested as upgrades.

The MySQL databases on Cajun Web Host’s machines employ the most recent build of the InnoDB storage engine. InnoDB was built to ensure the highest possible functionality for web sites that deal with substantial amounts of data. It offers CPU performance that could not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and grants complete transaction support, meaning it’s possible to update/insert/create/alter/drop many times for one "operation" of your web application. At the same time, it uses row–level locking as an alternative to MyISAM’s table–level locking, that raises multi–user concurrency and performance.

Through the thorough database statistics tool built–into the Control Panel, you’ll be able to keep track of the load created from your active websites 24 x 365. Any overload issue with your sites can lower the loading speeds and have a bad impact on the overall impression of your visitors. Hence, by having information for the database load immediately, you will be able to eliminate overload difficulties immediately.

The database data interface shows information of the quantity of daily, hourly and monthly queries, so its possible to assess how the load is allocated over different periods of time.