Databases Manager

Database management may sound like a difficult job to newbie cloud hosting customers, nevertheless with Sure Link’s Databases Manager, it’s actually simple! To make a brand new database, you simply ought to enter your username and password. Database backup copies are simply a mouse click away as well.People that want to explore their databases and edit them are able to use the phpMyAdmin and phpPgAdmin tools.

With the Databases Manager it is easy to generate an archived duplicate of your database when you need! This way, you will always have a backup of your active content material in the event your site gets compromised or you erroneously erase a database. To produce a back–up: click the ’clock’ symbol next to a certain database and then simply wait for a few seconds for the backup process to be completed.

There are no confines on the volume of databases you are able to back up or the quantity of backup copies you can make for a database.

PgSQL databases are less widespread compared to the standard MySQL databases. Nevertheless, they represent a favorite option for web developers who seek the utmost stability for their websites and web applications. Because of the incredibly user–friendly Databases Manager integrated into the Sure Link Control Panel, you can manage all your PostgreSQL databases with a simple mouse click.

You are going to find PgSQL databases included automatically within the advanced Linux shared website hosting packages. Assuming that you are using a regular hosting package, you can request PgSQL databases to be added to your web hosting account as upgrades.

We’ve set up InnoDB – the brand new standard MySQL database engine on each of our machines. InnoDB is ideal for large database sites that demand high levels of functionality and scalability. Trials have indicated that web sites making use of InnoDB based tables reach a 3–fold overall performance boost for massive joins, as compared with those utilizing MyISAM tables.

InnoDB makes use of row–level locking as a way to eliminate general performance issues seen at the high consumption times of the earlier version of the database engine – MyISAM, which employs table–level locking.

Keeping tabs on the load produced by the databases on your dynamic web site assists you to reduce any overload troubles that could slow it down and ward off website visitors. For that reason, we have built–in a in depth Database Stats tool directly into the Online Control Panel. There you can find all–inclusive information on the arriving requests to your databases for every hour, day and month.

Depending on the number of daily and hourly queries, you’re going to be able to find out which databases are employed the most as well as take steps to optimize their load.