Inside the ape-it Control Panel you’ll find a full featured, convenient Databases Manager! Utilize it to get complete control over your databases. You’re able to conveniently configure new MySQL and PgSQL databases and oversee them with the phpMyAdmin and phpPgAdmin software programs, respectively.
Neat and User–friendly Interface
Handle all of your databases from a single place
The Databases Manager within our Control Panel contains a robust yet uncomplicated user interface. It’s possible to set up a whole new MySQL or PostgreSQL database by simply typing in a username and security password. Also, you can create a backup file or change the security password of an database with just a click of the mouse.
Via the Databases Manager you’ll get immediate access to the admin area for all your databases, which enables you to make convenient changes if you ever need to.
Easy and fast Database Back–up
Database backups are a click away
Via the Databases Manager you’ll be able to generate an archived duplicate of your database whenever you want! Therefore, you will always have a data backup of your operating content material in case your site gets compromised or if you erroneously eliminate a database. To produce a backup: click on the ’clock’ image beside a particular database and afterwards just wait for a few seconds for the process to be performed.
There are not any restricts about the amount of databases you can back up or the number of backup copies you can create for a database.
Support for PgSQL
Guaranteed security for one’s databases
PgSQL databases are significantly less famous as opposed to the prevalent MySQL databases. On the other hand, they are a favorite choice for web developers who seek the uttermost stability for their sites and web apps. Due to the incredibly user–friendly Databases Manager incorporated into the ape-it Control Panel, you can administer your PostgreSQL databases with merely a click of the mouse.
You’ll find PgSQL databases integrated automatically within the best Linux shared packages packages. Assuming that you are with a regular hosting package, you’re able to ask for PgSQL databases to be included in your web hosting account as upgrades.
The fresh new face of MySQL
We’ve incorporated InnoDB – the brand new default MySQL database engine on our servers. InnoDB is perfect for sizeable database sites that require high levels of efficiency and scalability. Tests have demonstrated that websites using InnoDB based tables attain a 3–fold efficiency increase for big joins, in comparison to those working with MyISAM tables.
InnoDB utilizes row–level locking in order to take away the performance issues noticed at the top consumption times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Complete statistics for all your databases
Keeping tabs on the load generated by the databases for your busy web site assists you to prevent all sorts of overload difficulties that could slow it down and chase away site visitors. For this reason, we have built in a in depth Database Stats tool into your Control Panel. There you will find broad information regarding the inbound requests to your databases for every single hour, day and month.
Using the amount of daily and per hour queries, you are going to be able to find out which databases are employed the most and take procedures to enhance their load.