Databases Manager

Database management may seem like a hard task to unskilled web hosting clients, nevertheless with Juicy Webhost’s Databases Manager, it’s in fact quite simple! To configure a brand new database, you only ought to key in the username and password. Database backup copies are only a mouse click away at the same time.People who would like to examine their databases and also update them should use the phpMyAdmin and phpPgAdmin tools.

Via the Databases Manager it is simple to generate an archived duplicate of your database whenever you need! Therefore, you are going to always have a back–up of your active content if your web site gets compromised or you incorrectly eliminate a database. To generate a backup: click the ’clock’ icon alongside a given database and afterwards wait for a couple of seconds for the process to be finished.

There are no confines about the number of databases you can back up or the volume of back–ups you can create for any database.

PgSQL databases are significantly less widespread in comparison to the standard MySQL databases. Having said that, they are a favorite choice for designers seeking the maximum stability for their web sites and applications. Thanks to the intuitive Databases Manager built–into the Juicy Webhost Control Panel, you can control your PostgreSQL databases with a simple click of the mouse.

You’re going to find PgSQL databases provided by default in the advanced shared website hosting plans packages. Provided that you are using a standard hosting package, it is easy to ask for PgSQL databases to be included in your cloud hosting account as upgrades.

The MySQL databases on our servers make use of the most recent release of the InnoDB storage engine. InnoDB was meant to guarantee the optimum effectiveness for sites that deal with large volumes of data. It provides CPU performance that can not be matched up by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives complete transaction support, meaning that it’s possible to update/insert/create/alter/drop many times for a single "operation" of your web app. Moreover, it makes use of row–level locking as an alternative to MyISAM’s table–level locking, that enhances multi–user concurrency and performance.

From the complete database statistics tool incorporated into the Website Control Panel, it will be possible to make a record of the load created through your busy sites 24 hour a day. Every single overload issue with your sites can lower the loading rates and have a negative effect on the online experience of your visitors. Consequently, having info for the database load in real time, it will be straightforward to mend overload problems right away.

The database data interface shows details of the number of daily, hourly and monthly queries, which means you can evaluate the way the load is spread over several time periods.