Database Manager

Administering your databases is simpler than in the past, due to the Site Control Panel user interface for MySQL and PgSQL administration! Assuming you do not have substantial expertise in making use of databases, it will be simple to manage the Database Manager.

You can create a completely new database just by keying in the username and security password or make a database backup with just a click of the mouse. Also, from the Data Manager you will get direct access to the administrative area for every database, so that you can quite simply modify it.

We’ve changed the manual database back–up generation into a simple job. To do so: inside of the Database Manager, click on the ’clock’ icon near the database that you would like to back up and afterwards wait for a couple of seconds for the backup process to take place. With respect to the size of the database, the creation of any backup file will need somewhere between a couple of seconds and a minute.

You can create as many backup copies of a database as you desire. We’ve not specified any confines about the volume of databases that you can back up too.

Practically all of the Linux website hosting bundles offer PgSQL support. While falling behind MySQL when it comes to global recognition and usage, PgSQL databases are famous for delivering the top level of security for your site content material. It is the reason why businesses like Skype and Yahoo employ PgSQL databases as a substitute for MySQL.

With regards to database management, PgSQL is as easy to understand as MySQL.

We have set up InnoDB – the brand new default MySQL database engine on each of our machines. InnoDB is perfect for significant database websites that require high levels of functionality and scalability. Tests have revealed that sites using InnoDB based tables reach a 3–fold general performance increase for massive joins, in contrast to those making use of MyISAM tables.

InnoDB uses row–level locking as a way to remove the general performance issues discovered at the peak consumption times of the earlier release of the database engine – MyISAM, which utilizes table–level locking.

We offer you a simple and easy way to observe the database usage for your dynamic websites. From your thorough database statistics user interface, that is included in the Site Control Panel, it’s possible to track the load generated from your busy websites in real time. The offered details will enable you to evaluate the database load fluctuations on an hourly basis, each day or each month.

You’re able to observe the database load for your websites within the Database Stats part of the Site Control Panel. The table on–screen presents the database lookups generated in the present month. To examine data for a past month, all you have to do is click on the back arrows placed at the top.