Databases Manager

Managing your databases now is easier than before, because of the Web Control Panel interface for MySQL and PgSQL administration! Even if you do not have in depth experience of utilizing databases, it will be effortless to manage the Databases Manager.

You can create a new database by merely typing the user name and security password or produce a database back–up with a click of the mouse. Additionally, from the Data Manager you’ll have direct access to the management area for each database, so you can quickly edit it.

We’ve transformed the manual database backup creation into a very easy task. To execute this: inside the Databases Manager, click the ’clock’ icon next to the database that you plan to back up and afterwards hang on for a couple of seconds for the process to take place. With regards to the size of your database, the building of the back–up file will require somewhere between a couple of seconds and a minute.

You can make as many back–ups per database as you want. We have not specified any limitations about the quantity of databases you can back up too.

A majority of jj web hosts’s cloud hosting bundles deliver PgSQL support. While falling behind MySQL when it comes to acceptance and employment, PgSQL databases are renowned for providing the top level of stability for your site content and articles. That is the basic reason why companies such as Skype and Yahoo make use of PgSQL databases instead of MySQL.

With respect to database management, PgSQL is just as easy to use as MySQL.

With jj web hosts, you’ll invariably find the most current version of MySQL plus the default MySQL storage engine – InnoDB, set up.

InnoDB is definitely more secure in comparison to the former storage engine’s version – MyISAM. It’s ACID–compliant and, most importantly – it grants 100% transaction support. Furthermore, it utilizes row–level locking, as an alternative to MyISAM’s table–level locking, that used to lead to efficiency troubles at peak usage times.

From your broad database stats tool included in the Web Control Panel, it will be possible to make a record of the load created through your active sites round the clock. Virtually any overload difficulty with your websites can reduce the loading speeds and have a damaging influence over the online experience of your respective visitors. Therefore, having data about the database load right away, you will be able to eliminate overload problems as quickly as possible.

The database statistics interface displays information of the amount of daily, hourly and monthly lookups, which enables you to evaluate the way the load is allocated over different time periods.