While in the Linux Dedicated Server Site Control Panel you’re going to find a feature–rich, uncomplicated Database Manager! Utilize it to have total control over all your databases. You can conveniently set up new MySQL and PgSQL databases and administer them through the phpMyAdmin and phpPgAdmin software tools, respectively.
A Convenient–to–use User interface
Command your databases with only a click of the mouse
Administering your databases is much simpler than before, due to the Site Control Panel interface for MySQL and PgSQL management! Provided you do not have detailed experience of making use of databases, you will find it very easy to use Linux Dedicated Server’s Database Manager.
You may create a new database just by keying in the username and security password or generate a database backup with merely a click of the mouse. Moreover, with the Data Manager you will possess direct access to the administrative area for each database, so you can effectively edit it.
Simple and easy Database Back–up
Protect your database content with simply a click of the mouse
In case you have worked with databases, you are aware that generating a manual database backup is not a simple job. In order to change this, we have created very simple tool that can back up your complete database with only one click of the mouse. The back–up file shall be available for you in less than a minute, based on the size of the selected database.
There are not any confines on the actual number of back–ups you can make for a selected database.
Essentially the most protected open source databases
Just about all of our Linux hosting service packages present PgSQL support. While dropping behind MySQL with respect to global recognition and employment, PgSQL databases are renowned for offering up the top level of security for your website content. That is the basic reason why brands like Skype and Yahoo rely upon PgSQL databases as an alternative to MySQL.
With regard to database administration, PgSQL is just as effortless to use as MySQL.
The fresh new face of MySQL
We have added InnoDB – the brand new default MySQL database engine on our web servers. InnoDB is made for substantial database websites that need high general performance and scalability. Experiments have shown that sites employing InnoDB based tables attain a 3–fold general performance boost for very big joins, as compared with those using MyISAM tables.
InnoDB works by using row–level locking so as to remove the efficiency difficulties spotted at the peak usage times of the previous version of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
In depth statistics for all of your databases
Through the thorough database stats tool built into the Site Control Panel, you will be able to keep a record of the load accumulated from your busy web sites 24 / 7. Every single overload issue with your web sites could lower the loading speeds and have a negative effect on the overall impression of your respective visitors. So, having data for the database work immediately, it is possible to eliminate overload problems quickly.
The database statistics user interface displays info of the volume of daily, hourly and monthly queries, so you’re able to assess the way the load is distributed over different periods of time.