Databases Manager

Administering your databases is less complicated than ever before, thanks to the Web Site Control Panel interface for MySQL and PgSQL management! Assuming you do not have substantial experience of handling databases, you will find it simple to work with the Databases Manager.

You could make a completely new database just by typing the user name and password or make a database back–up with a click of the mouse. Also, within the Data Manager you will get direct access to the administrator area for every single database, to help you to conveniently update it.

With the Databases Manager you can make an archived backup of your database whenever you want! Thus, you’ll always have a data backup of your operating content if your website gets broken into or you incorrectly eliminate a database. To make a backup: click the ’clock’ symbol beside any database and afterwards wait for a couple of seconds for the process to be executed.

There won’t be any limitations on the quantity of databases you would be able to back up or the quantity of backups you can make for a database.

PgSQL databases are less widespread when compared to the prevalent MySQL databases. Then again, they are a favored alternative for web developers who seek the best stability for their sites and web applications. Due to the incredibly user–friendly Databases Manager incorporated into the Ozonga Control Panel, you can control all of your PostgreSQL databases with merely a click of the mouse.

You will find PgSQL databases incorporated by default inside of the best Linux cloud web hosting packages packages. If you are using a regular hosting package, you can request PgSQL databases to be added in your hosting account as upgrades.

We’ve incorporated InnoDB – the brand new default MySQL database engine on our machines. InnoDB is ideal for substantial database web sites which need high efficiency and scalability. Tests have demonstrated that web sites employing InnoDB based tables reach a 3–fold functionality increase for large joins, when compared with those employing MyISAM tables.

InnoDB takes advantage of row–level locking in an effort to eliminate general performance difficulties seen at the high consumption times of the prior variant of the database engine – MyISAM, which uses table–level locking.

Keeping track of the load produced by the databases in your dynamic site assists you to prevent any kind of overload difficulties that can slow it down and ward off website visitors. For that reason, we’ve provided a thorough Database Stats tool within the Web Site Control Panel. There you will find all–encompassing information regarding the inbound requests to your databases for every single hour, day and month.

Using the number of day–to–day and hourly queries, you will be able to find out which databases are used the most and then consider measures to optimize their load.