Database Manager

Taking control of your databases is much easier than in the past, as a result of Website Control Panel interface for MySQL and PgSQL administration! Even if you do not have detailed experience of making use of databases, you will find it simple to manage our Database Manager.

You may create a brand new database simply by specifying the user name and security password or make a database back–up with simply a mouse click. Additionally, through the Data Manager you will possess direct access to the management area for each database, so you’re able to quickly alter it.

We’ve designed the manual database backup formation into a very simple activity. To execute this: within the Database Manager, click the ’clock’ image on the side of the database that you would like to back up and after that wait for a couple of seconds for the process to take place. Depending upon the size of the database, the creation of a back–up file can take somewhere between a couple of seconds and a minute.

You may make as many copies per database as you desire. We have not determined any limits for the volume of databases that you can back up as well.

You are going to find PgSQL support in each of our Linux cloud website hosting packages bundles. PgSQL databases may not be as sought after and commonly used as MySQL, however they give the maximum level of protection for your site content. For this reason, a lot of widely known companies such as Skype and Yahoo utilize PgSQL databases. Maintaining PgSQL databases is as elementary as MySQL, as a result of the intuitive user interface of the Database Manager.

PgSQL databases are integrated automatically with the most innovative web hosting packages. For the normal plans, they are included as upgrades.

The MySQL databases on Ozzieblue’s web servers make use of the most current build of the InnoDB storage engine. InnoDB is built to ensure the top efficiency for sites that process massive 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 complete transaction support, which means it is possible to update/insert/create/alter/drop a couple of times for a single "operation" of your application. 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.

From your all–inclusive database stats tool integrated into the Website Control Panel, it’s possible to keep tabs of the stress accumulated through your dynamic websites 24 x 365. Every overload issue with your web sites could reduce the loading rates and have a negative effect on the overall experience of your respective site visitors. Hence, by having info about the database load immediately, it is also possible to fix overload issues in a timely manner.

The database statistics user interface shows information of the number of daily, hourly and monthly lookups, so its possible to evaluate just how the load is distributed over different periods of time.