While in the Kilbirnie Web Services Online Control Panel you’ll find a feature–rich, simple point and click Database Manager! Utilize it to get complete control over all your databases. You’ll be able to efficiently set up new MySQL and PgSQL databases and administer them through the phpMyAdmin and phpPgAdmin software programs, respectively.
Clean and Very easy Interface
Take care of all your databases from one location
The Database Manager within our Online Control Panel comes with an effective yet simple to use interface. You’re able to configure a whole new MySQL or PostgreSQL database by just specifying a user name and security password. Furthermore, you can make a backup file or alter the security password of any database with simply a mouse click.
From the Database Manager you’ve got immediate access to the administration area for all of your databases, so that you can make convenient changes if you ever need to.
Uncomplicated Database Back–up
Protect your database content with a click
In case you have worked with databases, you know that making a manual database back–up is simply not a basic task. As a way to change this, we’ve created a simple tool that will back up your entire database with just one click of the mouse. The back–up file will be ready for you in less than a minute, with respect to the size of the chosen database.
You won’t notice any limits on just how many copies you can create for any specific database.
PgSQL Databases Support
By far the most secure open source databases
You are going to find PgSQL support in all our Linux shared hosting packages. PgSQL databases might not be as famous and widespread as MySQL, however they deliver the best level of safety for your web site content and articles. Because of this, a number of famous businesses like Skype and Yahoo utilize PgSQL databases. Managing PgSQL databases is as simple as MySQL, thanks to the intuitive user interface of the Database Manager.
PgSQL databases are integrated automatically with the most advanced web hosting plans. For the standard packages, they’re presented as upgrades.
The new face of MySQL
We’ve integrated InnoDB – the new standard MySQL database engine on every one of our web servers. InnoDB is ideal for large database sites which require high efficiency and scalability. Trials have shown that sites using InnoDB based tables attain a 3–fold operation boost for big joins, in comparison with those applying MyISAM tables.
InnoDB uses row–level locking so as to clear away the functionality problems observed at the peak usage times of the earlier variant of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
In depth statistics for all of your databases
Monitoring the load generated by the databases in your dynamic web site will help you avoid any sort of overload difficulties that can slow it down and chase away site visitors. For this specific purpose, we’ve integrated a detailed Database Stats tool in the Online Control Panel. There you can get complete information on the incoming requests to your databases for each hour, day and month.
In line with the quantity of daily and by the hour queries, it will be easier to find out what databases are being used the most and then take actions to enhance their work.