Databases Manager

Taking control of your databases is simpler than before, as a result of Site Control Panel user interface for MySQL and PgSQL administration! Assuming you do not have in depth knowledge of utilizing databases, it will be an easy task to handle the Databases Manager.

You can make a new database merely by keying in the user name and security password or generate a database back–up with just a click of the mouse. Likewise, via the Data Manager you’ll possess direct access to the management area for each and every database, meaning you can almost instantly revise it.

Within the Databases Manager you are able to create an archived duplicate of your database whenever you desire! Therefore, you will always have a backup of your dynamic content material in the event your web site gets hacked or if you mistakenly eliminate a database. To make a backup: click on the ’clock’ symbol next to a certain database and afterwards wait for a couple of seconds for the backup process to be concluded.

There are no restrictions for the volume of databases you can back up or the number of backup copies you can create for a database.

You are going to find PgSQL support in each of our hosting plans. PgSQL databases may not be as popular and frequently used as MySQL, but they supply the best level of safety for your web site content and articles. Due to this, many famous companies like Skype and Yahoo use PgSQL databases. Taking care of PgSQL databases is as elementary as MySQL, thanks to the incredibly user–friendly interface of the Databases Manager.

PgSQL databases are integrated automatically in the most advanced web hosting bundles. For the regular bundles, they are offered as upgrades.

With Octopus Hosting, you shall consistently discover the most current release of MySQL along with the default MySQL storage engine – InnoDB, installed.

InnoDB is more reliable as compared to the old storage engine’s version – MyISAM. It is ACID–compliant and, most importantly – it has total transaction support. What’s more, it makes use of row–level locking, in contrast to MyISAM’s table–level locking, that would always result in performance problems at peak usage times.

Octopus Hosting offers you a pretty simple solution to keep track of the database utilization on your dynamic web sites. From your thorough database statistics user interface, which is integrated into the Site Control Panel, you’re able to keep track of the load created through your dynamic websites in real time. The offered info will assist you to assess the database load changes each hour, on a daily basis or on a monthly basis.

You are able to observe the database load for all your websites through the Database Stats part of the Site Control Panel. The table onscreen shows the database lookups made within the present month. To assess information for a previous month, all you have to do is click on the back arrows located at the top.