Within the 1clickhosting Online Control Panel you’ll find a fully–featured, convenient to use Databases Manager! Utilize it to get total control of all your databases. It is easy to efficiently set up new MySQL and PgSQL databases and administer them through the phpMyAdmin and phpPgAdmin software tools, respectively.
A Simple to use User interface
Maintain your databases with simply a click
Managing your databases is much simpler than ever, as a result of Online Control Panel interface for MySQL and PgSQL control! Provided you do not have considerable expertise in utilizing databases, you will find it an easy task to manage 1clickhosting’s Databases Manager.
You may create a completely new database just by specifying the user name and security password or create a database back–up with a mouse click. Likewise, within the Data Manager you’ll possess direct access to the administrator area for every database, allowing you to effortlessly edit it.
Simple and easy Database Back–up
Database backup copies can be a click away
With the Databases Manager you’re able to generate an archived duplicate of your database whenever you wish! For this reason, you will always have a back–up of your active content material in case your site gets compromised or if you incorrectly eliminate a database. To produce a back–up: click the ’clock’ icon beside a given database and afterwards just wait for a few seconds for the backup process to be executed.
There are no restrictions for the amount of databases you would be able to back up or the number of backups you may make for any database.
Support for PgSQL
Guaranteed stability for your databases
PgSQL databases are significantly less widespread as opposed to the common MySQL databases. Nevertheless, they represent a preferred selection for web developers who seek the greatest protection for their sites and web applications. Through the incredibly user–friendly Databases Manager built into the 1clickhosting Control Panel, you can manage your PostgreSQL databases with a click of the mouse.
You’ll find PgSQL databases included automatically in the top Linux hosting packages. In case you are with a standard hosting package, you can easily request PgSQL databases to be added in your web hosting account as upgrades.
The fresh face of MySQL
The MySQL databases on 1clickhosting’s web servers work with the most current release of the InnoDB storage engine. InnoDB has been made to ensure the highest effectiveness for web sites that process big amounts of data. It features CPU efficiency that could not be matched up by any alternative disk–based relational database engines.
InnoDB is ACID–compliant and gives total transaction support, meaning you’ll be able to update/insert/create/alter/drop repeatedly for one "operation" of your web application. Furthermore, it makes use of row–level locking as an alternative to MyISAM’s table–level locking, that improves multi–user concurrency and effectiveness.
Detailed Database Stats
Complete stats for all of your databases
Keeping track of the load generated by the databases on your active site will help you stop any kind of overload troubles that could slow it down and ward off website visitors. For this specific purpose, we have built in a descriptive Database Stats tool into the Online Control Panel. There you will find in depth info on the inbound requests to your databases for every single hour, day and month.
Using the quantity of daily and per hour queries, it’s possible to find out what databases are utilized the most and consider steps to optimize their work.