Databases Manager

Database management may sound like a hard task to beginner website hosting users, nevertheless with Hostinq1’s Databases Manager, it’s in fact reasonably easy! To set up a brand new database, you simply need to provide the username and password. Database backups are just a mouse click away on top of that.People who would like to look into their databases and also revise them may use the phpMyAdmin and phpPgAdmin tools.

Via the Databases Manager it is simple to make an archived duplicate of your database when you need! That way, you are going to always have a backup of your dynamic information if your site gets hacked or if you incorrectly remove a database. To make a back–up: click the ’clock’ symbol next to a particular database and afterwards simply wait for a few seconds for the backup process to be concluded.

There won’t be any limitations on the volume of databases you would be able to back up or the number of back–ups you may make for any database.

PgSQL databases are less widespread as opposed to the prevalent MySQL databases. Nonetheless, they’re a favorite alternative for web developers who are looking for the greatest security for their web sites and applications. Due to the incredibly user–friendly Databases Manager built–into the Hostinq1 Control Panel, you can manage all your PostgreSQL databases with a click of the mouse.

You can find PgSQL databases integrated by default within the best shared services packages. If you are using a standard hosting package, you are able to request PgSQL databases to be included in your web hosting account as upgrades.

We have added InnoDB – the new default MySQL database engine on all of our servers. InnoDB is good for huge database web sites which require high general performance and scalability. Trials have shown that websites using InnoDB based tables achieve a 3–fold performance grow for huge joins, in comparison with those applying MyISAM tables.

InnoDB works by using row–level locking so as to remove the efficiency difficulties detected at the top consumption times of the prior variant of the database engine – MyISAM, which uses table–level locking.

Checking the load made by the databases for your powerful website will let you avoid all kinds of overload problems that might slow it down and chase away site visitors. For this specific purpose, we have bundled a descriptive Database Stats tool in the Online Control Panel. There you can get all–encompassing info about the arriving requests to your databases for each hour, day and month.

Based on the volume of day–to–day and hourly queries, it will be easy to find out which databases are used the most and also take procedures to optimize their work.