Within the khmer Linux Website Control Panel you’ll find a feature–rich, user–friendly Database Manager! Use it in order to get complete command over all your databases. It’s possible to effortlessly set up new MySQL and PgSQL databases and supervise them via the phpMyAdmin and phpPgAdmin software programs, respectively.
A Convenient–to–use User interface
The simplest database management user interface
Database management may seem like a difficult job to newbie website hosting customers, nevertheless with the Database Manager, it’s actually relatively easy! To make a new database, you simply have to key in the username and password. Database backup copies are just a mouse click away too.People that would like to explore their databases as well as alter them can use the phpMyAdmin and phpPgAdmin tools.
Instant Database Backup
Back up your databases in just a minute
We have made the manual database backup formation into a very easy task. To do this: within the Database Manager, click on the ’clock’ icon next to the database that you intend to back up and after that hang on for a few seconds for the process to take place. With regards to the size of your database, the generation of a backup file is going to take between a couple of seconds and a minute.
You may make as many backup copies per database as you want. We haven’t set any restrictions about the amount of databases that you could back up too.
PgSQL Support
Just about the most protected open source databases
Almost all of the web hosting plans plans present PgSQL support. Whilst falling behind MySQL when it comes to level of popularity and employment, PgSQL databases are famous for delivering the best level of protection for your website content and articles. That’s the primary reason why companies like Skype and Yahoo make use of PgSQL databases as opposed to MySQL.
When considering database administration, PgSQL is identically easy to understand as MySQL.
InnoDB Databases
The new face of MySQL
The MySQL databases on our web servers use the most recent release of the InnoDB storage engine. InnoDB has been created to ensure the optimum functionality for websites that process significant amounts 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 grants complete transaction support, meaning it is easy to update/insert/create/alter/drop many times for one "operation" of your web application. Additionally, it uses row–level locking as an alternative to MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.
Detailed Database Stats
In depth stats for all of your databases
Monitoring the load generated by the databases within your busy site will let you prevent any kind of overload issues that could slow it down and chase away visitors. For this specific purpose, we have designed a detailed Database Stats tool into the Website Control Panel. There you shall find broad info about the arriving requests to your databases for every hour, day and month.
Depending on the amount of day–to–day and by the hour queries, you are going to be able to determine which databases are employed the most and take procedures to optimize their load.
