Database Manager

Database management might sound like a difficult task to newbie web hosting users, but with the Database Manager, it’s in fact relatively easy! To set up a completely new database, you simply have to provide your username and password. Database backups are a click away at the same time.People that need to explore their databases and also update them should use the phpMyAdmin and phpPgAdmin tools.

We have transformed the manual database backup creation into a quite easy task. To do so: in the Database Manager, click on the ’clock’ image beside the database that you plan to back up and after that hang on for a few seconds for the process to take place. Depending upon the size of the database, the generation of any back–up file will require between a couple of seconds and a minute.

You can make as many backup copies per database as you desire. We’ve not specified any limitations about the amount of databases that you can back up too.

A majority of Web Hosting Indy’s Linux shared hosting plans offer PgSQL support. While falling behind MySQL with respect to level of popularity and application, PgSQL databases are renowned for presenting the maximum level of stability for your web site content. That is the primary reason why companies like Skype and Yahoo employ PgSQL databases in lieu of MySQL.

With regards to database administration, PgSQL is as uncomplicated as MySQL.

With Web Hosting Indy, you will always discover the most recent version of MySQL and the default MySQL storage engine – InnoDB, installed.

InnoDB is definitely more secure as compared to the past storage engine’s version – MyISAM. It’s ACID–compliant and, even more importantly – it includes 100% transaction support. Furthermore, it uses row–level locking, as opposed to MyISAM’s table–level locking, that seemed to trigger functionality issues at high usage occasions.

Checking the load generated by the databases in your dynamic web site will help you stop any sort of overload problems that can slow it down and ward off website visitors. For this purpose, we’ve bundled a descriptive Database Stats tool inside the Online Control Panel. There you shall find all–encompassing information regarding the incoming requests to your databases for every hour, day and month.

Using the volume of daily and per hour queries, you’re going to be able to find out which databases are being used the most as well as take procedures to enhance their load.