Within the Lime Server Web Site Control Panel you’ll find a full featured, user–friendly Database Manager! Put it to use in order to enjoy full control of all your databases. You’ll be able to quickly configure new MySQL and PgSQL databases and administer them through the phpMyAdmin and phpPgAdmin software programs, respectively.
A Simple point and click Interface
Control your databases with only a mouse click
Managing your databases is much easier than ever, because of the Web Site Control Panel interface for MySQL and PgSQL control! Provided you do not have extensive expertise in making use of databases, it will be an easy task to handle our Database Manager.
You may create a completely new database by simply keying in the user name and password or generate a database backup with a click of the mouse. Also, via the Data Manager you will get direct access to the administrator area for every database, which enables you to almost instantly update it.
Hassle–free Database Data backup
Secure your database content with only a click
In case you have worked with databases, you are aware that making a manual database backup is just not a simple job. As a way to change this, we have created a simple tool that can back up your whole database with merely a single click. The data backup file shall be all set for you in under a minute, with regards to the size of the selected database.
There won’t be any limits on exactly how many backups you could make for any specific database.
PgSQL Databases Support
Essentially the most safe open source databases
You are going to find PgSQL support in all our Linux shared packages offers. PgSQL databases aren’t as popular and widely used as MySQL, nevertheless they offer the highest possible level of stability for your web site content and articles. Therefore, a number of popular companies such as Skype and Yahoo take advantage of PgSQL databases. Controlling PgSQL databases is as easy and simple as MySQL, as a result of the incredibly user–friendly user interface of the Database Manager.
PgSQL databases are bundled automatically within the most advanced web hosting bundles. For the basic plans, they are offered as upgrades.
The fresh new face of MySQL
With Lime Server, you will invariably find the most up–to–date variant of MySQL and also the default MySQL storage engine – InnoDB, installed.
InnoDB is far more reliable in comparison to the previous storage engine’s edition – MyISAM. It’s ACID–compliant and, most importantly – it gives 100% transaction support. In addition, it uses row–level locking, as an alternative for MyISAM’s table–level locking, that used to result in performance troubles at high usage times.
Detailed Database Stats
Detailed statistics for your databases
Checking the load caused by the databases within your dynamic site will help you reduce any sort of overload difficulties that could slow it down and chase away website visitors. Therefore, we have built–in a detailed Database Stats tool straight into the Web Site Control Panel. There you can see broad information about the arriving requests to your databases for every hour, day and month.
Based on the number of day–to–day and hourly queries, it will be easier to find out what databases are being used the most and then consider steps to optimize their work.