Databases Manager

Overseeing your databases is much simpler than ever, thanks to the Site Control Panel interface for MySQL and PgSQL administration! Even if you do not have in depth experience in utilizing databases, you will find it very easy to deal with the Databases Manager.

You could make a completely new database by just entering the user name and password or make a database back–up with just a mouse click. Furthermore, through the Data Manager you’ll possess direct access to the administrative area for each database, so you can quickly revise it.

Through the Databases Manager it’s easy to produce an archived copy of your database whenever you need! For this reason, you are going to always have a data backup of your dynamic information in the event your web site gets compromised or if you accidentally erase a database. To produce a back–up: click the ’clock’ image beside any database and then wait for a couple of seconds for the backup process to be performed.

There are not any restrictions for the quantity of databases you are able to back up or the quantity of backups you may make for any database.

PgSQL databases are less sought after as opposed to the popular MySQL databases. However, they represent a preferred choice for designers who are looking for the utmost safety for their sites and applications. Because of the easy–to–use Databases Manager built–into the CharlotteWebs Control Panel, you can control all your PostgreSQL databases with a mouse click.

You will find PgSQL databases included by default in the best cloud hosting packages. If you are using a standard hosting package, you can ask for PgSQL databases to be added to your hosting account as upgrades.

The MySQL databases on CharlotteWebs’s web servers work with the most current release of the InnoDB storage engine. InnoDB has been built to ensure the optimum functionality for websites that deal with significant amounts of data. It features CPU effectiveness that could not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and supplies full transaction support, so that you’re able to update/insert/create/alter/drop several times for one "operation" of your app. At the same time, it works by using row–level locking in lieu of MyISAM’s table–level locking, that boosts multi–user concurrency and effectiveness.

Keeping track of the load accumulated by the databases in your active web site will help you prevent any sort of overload issues that might slow it down and chase away visitors. For this reason, we have provided a descriptive Database Stats tool straight into the Site Control Panel. There you can see all–encompassing info on the inbound requests to your databases for each hour, day and month.

In line with the number of day–to–day and hourly queries, you’ll be able to find out what databases are employed the most and then take actions to optimize their load.