With the Database Manager included in the Online Control Panel, it will be easier to set–up brand new MySQL and PgSQL databases instantly! At the same time, you’ll possess immediate access to the administration area software tools (phpMyAdmin and phpPgAdmin, respectively), so that you can immediately edit the database you want.
Tidy and Hassle–free Interface
Manage all your databases from one location
The Database Manager in the Online Control Panel includes a robust but convenient–to–use user interface. You can configure a completely new MySQL or PostgreSQL database by just specifying a user name and security password. In addition, you could make a back–up file or change the security password of an database with a mouse click.
With the Database Manager you will get direct access to the administrative area for each of your databases, so that you can make simple and easy modifications if you ever have to.
Simple Database Back up
Back up your databases in a moment
We’ve transformed the manual database back–up generation into a quite simple job. To execute that: inside of the Database Manager, click on the ’clock’ symbol on the side of the database that you would like to back up and afterwards wait for a few seconds for the process to take place. With respect to the size of your database, the generation of a back–up file is going to take between a couple of seconds and a minute.
You may make as many back–ups of a database as you desire. We haven’t set any restrictions for the amount of databases that you could back up too.
Just about the most secure open source databases
Practically all of PeekLevel’s shared hosting service packages offer PgSQL support. While falling behind MySQL with regards to popularity and utilization, PgSQL databases are renowned for providing the best level of security for your web site content and articles. That’s the reason why companies such as Skype and Yahoo rely on PgSQL databases instead of MySQL.
With respect to database administration, PgSQL is as simple and easy as MySQL.
The fresh new face of MySQL
We have set up InnoDB – the new default MySQL database engine on all our web servers. InnoDB is made for huge database web sites that need high levels of efficiency and scalability. Trials have established that web sites working with InnoDB based tables reach a 3–fold effectiveness increase for huge joins, in comparison with those utilizing MyISAM tables.
InnoDB takes advantage of row–level locking in an effort to remove the overall performance problems detected at the top usage times of the prior variant of the database engine – MyISAM, which uses table–level locking.
Detailed Database Stats
Detailed stats for all of your databases
Keeping tabs on the load accumulated by the databases within your active website assists you to avoid all overload difficulties that could slow it down and ward off website visitors. For this reason, we have integrated a complete Database Stats tool straight into the Online Control Panel. There you can get all–inclusive information regarding the incoming requests to your databases for each hour, day and month.
Depending on the volume of daily and hourly queries, it’s possible to determine which databases are utilized the most and take procedures to optimize their work.