Database Manager

The Database Manager inside our Web Control Panel has a robust but still straightforward user interface. It’s possible to set up a whole new MySQL or PostgreSQL database by just specifying a user name and password. Furthermore, you can create a backup file or change the security password of your database with merely a mouse click.

Within the Database Manager you will get immediate access to the admin area for all your databases, allowing you to make hassle–free modifications if you happen to have to.

Within the Database Manager it’s easy to create an archived copy of your database when you would like! Therefore, you are going to always have a backup of your active content material in the event your website gets compromised or if you erroneously remove a database. To create a backup: click on the ’clock’ symbol beside a particular database and then just wait for a few seconds for the process to be finalized.

There won’t be any restricts for the number of databases you can back up or the volume of backups you may make for a database.

PgSQL databases are significantly less sought after compared to the prevalent MySQL databases. Then again, they’re a favorite option for web developers who are looking for the finest safety for their websites and web apps. Thanks to the user–friendly Database Manager incorporated into the Juicy Hosting Control Panel, you can control all your PostgreSQL databases with simply a mouse click.

You’ll find PgSQL databases provided by default with the best Linux cloud hosting packages. Provided that you are with a regular hosting package, it’s possible to ask for PgSQL databases to be included in your web hosting account as upgrades.

We have incorporated InnoDB – the brand new default MySQL database engine on every one of our machines. InnoDB is good for massive database web sites which need high levels of efficiency and scalability. Experiments have demonstrated that web sites employing InnoDB based tables attain a 3–fold functionality grow for significant joins, in comparison with those making use of MyISAM tables.

InnoDB takes advantage of row–level locking in order to be able to clear away the performance problems noticed at the top usage times of the previous variant of the database engine – MyISAM, which utilizes table–level locking.

Tracking the load made by the databases for your powerful website will let you avoid any overload difficulties that could slow it down and ward off website visitors. For this purpose, we’ve included a comprehensive Database Stats tool straight into the Web Control Panel. There you can get comprehensive info on the incoming requests to your databases for each hour, day and month.

In line with the quantity of daily and hourly queries, you will be able to find out what databases are utilized the most and also consider measures to optimize their work.