Within the Holt Hosting Online Control Panel you’re going to find a feature–rich, convenient to use Database Manager! Utilize it to enjoy full command over all of your databases. You’ll be able to quickly set up new MySQL and PgSQL databases and administer them with the phpMyAdmin and phpPgAdmin software tools, respectively.
A Convenient User interface
Take care of your databases with just a click of the mouse
Managing your databases is less complicated than ever, because of the Online Control Panel user interface for MySQL and PgSQL administration! Even if you do not have thorough expertise in handling databases, you will find it effortless to deal with the Database Manager.
You could make a brand new database by only specifying the username and password or generate a database backup with merely a mouse click. Furthermore, from the Data Manager you will possess direct access to the administrator area for each and every database, to help you to instantly update it.
Simple and quick Database Back–up
Database backups can be a mouse click away
Through the Database Manager you can easily generate an archived backup of your database whenever you desire! Thus, you are going to always have a data backup of your dynamic information in case your site gets broken into or you mistakenly remove a database. To produce a back–up: click the ’clock’ symbol alongside a given database and then simply wait for a couple of seconds for the process to be carried out.
There are no limits for the amount of databases you are able to back up or the number of back–ups you can create for any database.
Just about the most stable open source databases
A lot of Holt Hosting’s Linux website hosting packages packages offer PgSQL support. While dropping behind MySQL with regards to popularity and usage, PgSQL databases are renowned for delivering the best level of stability for your website content. That is the basic reason why companies such as Skype and Yahoo rely on PgSQL databases and not MySQL.
In terms of database management, PgSQL is just as hassle–free as MySQL.
The newest face of MySQL
With Holt Hosting, you’ll regularly discover the newest release of MySQL and also the default MySQL storage engine – InnoDB, set up.
InnoDB is much more stable in comparison to the old storage engine’s version – MyISAM. It’s ACID–compliant and, most importantly – it has 100% transaction support. In addition, it works by using row–level locking, as a substitute for MyISAM’s table–level locking, that used to result in efficiency problems at peak usage occasions.
Detailed Database Stats
Comprehensive statistics for all your databases
From your in depth database stats tool included in the Online Control Panel, you will be able to keep a record of the stress created by your busy websites round the clock. Virtually any overload difficulty with your websites can reduce the loading speeds and have a negative impact on the overall impression of your respective visitors. So, by having information for the database work live, it will be easier to solve overload difficulties at once.
The database stats interface shows data of the amount of daily, hourly and monthly queries, which enables you to evaluate just how the load is spread over several periods of time.