Database Manager

The Database Manager inside the Control Panel boasts a refined but still straightforward interface. You’ll be able to configure a new MySQL or PostgreSQL database by just typing in a user name and security password. Also, you can create a back–up file or customize the password of an database with merely a click of the mouse.

Via the Database Manager you will have direct access to the admin area for each of your databases, in order to make easy alterations should you need to.

With the Database Manager you are able to create an archived backup of your database anytime you would like! Therefore, you will always have a back–up of your operating content material if your web site gets broken into or you erroneously erase a database. To produce a backup: click on the ’clock’ icon next to a given database and then wait for a couple of seconds for the process to be performed.

There aren’t any restrictions on the quantity of databases you would be able to back up or the volume of back–ups you can create for any database.

A majority of Global Web Hosting’s shared hosting packages grant PgSQL support. Whilst falling behind MySQL with regards to acceptance and application, PgSQL databases are famous for offering the best level of protection for your web site content and articles. That’s the basic reason why companies such as Skype and Yahoo use PgSQL databases as opposed to MySQL.

In terms of database administration, PgSQL is identically easy to understand as MySQL.

We’ve integrated InnoDB – the brand new default MySQL database engine on all our servers. InnoDB is great for sizeable database websites which need high levels of performance and scalability. Experiments indicate that web sites working with InnoDB based tables achieve a 3–fold efficiency increase for massive joins, as compared with those applying MyISAM tables.

InnoDB uses row–level locking so as to take away the overall performance problems witnessed at the peak usage times of the previous release of the database engine – MyISAM, which uses table–level locking.

We provide you an effortless solution to keep track of the database utilization for your active web sites. Via the descriptive database statistics interface, that is built–into the Control Panel, you can monitor the load made by your busy sites in real time. The displayed details will allow you to evaluate the database load fluctuations on an hourly basis, each day or monthly.

You can easily record the database load for your web sites from the Database Stats part of the Control Panel. The table onscreen features the database queries created within the present month. To check details for a past month, just click on the back arrows located at the top.