Inside the CharlotteWebHosting.net Web Site Control Panel you will find a full featured, user–friendly and uncomplicated Databases Manager! Employ it in order to enjoy complete control of all of your databases. You’ll be able to quickly create new MySQL and PgSQL databases and control them via the phpMyAdmin and phpPgAdmin software tools, respectively.
An Easy to use Interface
The simplest database administration user interface
Database management may sound like a difficult job to new cloud hosting clients, however with the Databases Manager, it’s in fact pretty simple! To create a completely new database, you only need to enter in the username and password. Database backup copies are just a mouse click away as well.People who would like to explore their databases and edit them can use the phpMyAdmin and phpPgAdmin tools.
Quick Database Backup
Back up your databases in just a moment
We’ve changed the manual database back–up generation into a very easy job. To do this: within the Databases Manager, click the ’clock’ symbol near the database that you intend to back up and after that wait around for a couple of seconds for the process to take place. With respect to the size of your database, the creation of a backup file can take between a couple of seconds and a minute.
You can create as many back–ups of a database as you desire. We have not set any limits on the volume of databases that you can back up either.
PgSQL Databases Support
The most safe open source databases
You are going to find PgSQL support in all of our Linux shared hosting packages. PgSQL databases might not be as popular and widely used as MySQL, nonetheless they provide the maximum level of stability for your website content. For this reason, many well–known businesses like Skype and Yahoo apply PgSQL databases. Controlling PgSQL databases is as easy and simple as MySQL, as a result of the intuitive user interface of the Databases Manager.
PgSQL databases are bundled by default inside of the most advanced web hosting packages. For the basic bundles, they are suggested as upgrades.
InnoDB Databases
The fresh new face of MySQL
The MySQL databases on our web servers utilize the most recent build of the InnoDB storage engine. InnoDB has been designed to guarantee the max efficiency for web sites that work with sizeable volumes of data. It delivers CPU effectiveness that could not be matched up by other different disk–based relational database engines.
InnoDB is ACID–compliant and provides complete transaction support, meaning that it is possible to update/insert/create/alter/drop more than once for one "operation" of your web app. At the same time, it makes use of row–level locking in contrast to MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.
Detailed Database Stats
In depth statistics for your databases
Tracking the load generated by the databases within your busy website will help you prevent any overload problems that can slow it down and ward off site visitors. For this purpose, we have built in a thorough Database Stats tool inside the Web Site Control Panel. There you can get comprehensive info about the incoming requests to your databases for each hour, day and month.
In line with the amount of daily and hourly queries, you are able to find out what databases are employed the most and then take actions to optimize their load.
