Database Manager

Supervising your databases is much easier than in the past, because of the Website Control Panel interface for MySQL and PgSQL management! Even though you may not have thorough knowledge in dealing with databases, you will find it very easy to work with our Database Manager.

You could make a new database merely by typing the user name and security password or make a database backup with a click of the mouse. Also, with the Data Manager you will possess direct access to the administrative area for every single database, which enables you to effectively edit it.

We have evolved the manual database backup formation into a very easy job. To do so: within the Database Manager, click the ’clock’ image next to the database that you plan to back up and after that hang on for a couple of seconds for the process to take place. Depending upon the size of the database, the generation of a back–up file can take between a few seconds and a minute.

You may make as many backup copies per database as you would like. We have not determined any boundaries for the quantity of databases that you could back up either.

You will find PgSQL support in our Linux web hosting packages offers. PgSQL databases might not be as famous and commonly used as MySQL, nonetheless they supply you with the highest level of protection for your website content and articles. Because of this, a number of popular brands like Skype and Yahoo employ PgSQL databases. Controlling PgSQL databases is as simple as MySQL, on account of the intuitive user interface of the Database Manager.

PgSQL databases are integrated automatically inside the most sophisticated web hosting packages. For the normal packages, they’re included as upgrades.

With Town Geek Web Hosting, you’ll inevitably discover the most current build of MySQL plus the default MySQL storage engine – InnoDB, mounted.

InnoDB is more secure when compared to the former storage engine’s edition – MyISAM. It is ACID–compliant and, most importantly – it gives total transaction support. Furthermore, it uses row–level locking, in contrast to MyISAM’s table–level locking, that previously used to cause efficiency issues at high usage times.

Checking the load caused by the databases within your busy website makes it possible to avoid any sort of overload troubles that could slow it down and ward off visitors. For that reason, we’ve provided a in–depth Database Stats tool directly into the Website Control Panel. There you can find thorough information regarding the arriving requests to your databases for every single hour, day and month.

Using the amount of day–to–day and per hour queries, it will be easier to find out which databases are used the most and also take actions to enhance their load.