Databases Manager

The Databases Manager in the Hosting Control Panel incorporates a refined but still easy to navigate user interface. It is easy to set up a brand new MySQL or PostgreSQL database by just specifying a user name and password. What’s more, you can make a backup file or alter the password of your database with just a mouse click.

Within the Databases Manager you’ll possess immediate access to the admin area for each of your databases, meaning you can make quick changes if you happen to have to.

Via the Databases Manager it’s possible to make an archived duplicate of your database whenever you desire! That way, you are going to always have a data backup of your active content in case your web site gets hacked or you accidentally eliminate a database. To make a backup: click the ’clock’ image beside a certain database and after that just wait for a couple of seconds for the process to be finalized.

There won’t be any restrictions on the number of databases you are able to back up or the amount of backup copies you may make for a database.

PgSQL databases are significantly less common in comparison to the popular MySQL databases. Even so, they represent a preferred alternative for programmers seeking the maximum protection for their sites and web apps. Through the user–friendly Databases Manager built–into the Starfire Solutions Consulting Control Panel, you can manage all your PostgreSQL databases with simply a mouse click.

Yow will discover PgSQL databases included by default with the advanced shared hosting packages. If you are with a basic hosting package, it is easy to request PgSQL databases to be included in your account as upgrades.

We’ve added InnoDB – the brand new default MySQL database engine on every one of our machines. InnoDB is good for large database websites which need high levels of effectiveness and scalability. Trials have established that sites employing InnoDB based tables attain a 3–fold effectiveness increase for large joins, in comparison with those making use of MyISAM tables.

InnoDB uses row–level locking in an effort to clear away the effectiveness problems detected at the high usage times of the previous version of the database engine – MyISAM, which uses table–level locking.

From the complete database stats tool incorporated into the Hosting Control Panel, you will be able to keep a record of the load produced by your busy web sites 24 x 365. Virtually any overload difficulty with your websites could lower the loading rates and have a damaging influence over the overall experience of your respective visitors. Thus, having info about the database work immediately, you’ll be able to eliminate overload difficulties without delay.

The database statistics user interface reveals details of the volume of daily, hourly and monthly lookups, so its possible to evaluate the way the load is distributed over different time periods.