Databases Manager

Administering your databases is much simpler than ever, because of the Website Control Panel user interface for MySQL and PgSQL management! Even if you do not have considerable expertise in dealing with databases, it will be very easy to manage the Databases Manager.

You could make a whole new database by just keying in the username and password or make a database back–up with a mouse click. In addition, with the Data Manager you’ll get direct access to the administrator area for every database, allowing you to effortlessly revise it.

From the Databases Manager you are able to make an archived duplicate of your database anytime you need! This way, you are going to always have a backup of your dynamic content material in case your website gets compromised or if you erroneously delete a database. To create a backup: click on the ’clock’ symbol alongside any database and after that simply wait for a couple of seconds for the process to be carried out.

There won’t be any restricts for the volume of databases you would be able to back up or the amount of backups you can make for a database.

You can find PgSQL support in every one of our Linux web hosting bundles. PgSQL databases aren’t as well–known and widespread as MySQL, nonetheless they give the maximum level of stability for your website content. For this reason, a lot of popular brands like Skype and Yahoo utilize PgSQL databases. Managing PgSQL databases is as simple and easy as MySQL, thanks to the incredibly user–friendly user interface of the Databases Manager.

PgSQL databases are provided by default within the most advanced web hosting bundles. For the regular plans, they are included as upgrades.

The MySQL databases on Lidya Hosting’s servers make use of the latest release of the InnoDB storage engine. InnoDB has been created to guarantee the max performance for websites that operate with substantial amounts of data. It delivers CPU efficiency that could not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and supplies total transaction support, meaning you’re able to update/insert/create/alter/drop repeatedly for one "operation" of your web application. Moreover, it utilizes row–level locking in place of MyISAM’s table–level locking, that boosts multi–user concurrency and performance.

Monitoring the load generated by the databases for your busy web site will help you stop virtually any overload issues that might slow it down and ward off website visitors. For this specific purpose, we have built in a complete Database Stats tool inside the Website Control Panel. There you can find in depth info about the inbound requests to your databases for each and every hour, day and month.

Using the volume of day–to–day and per hour queries, it’s possible to determine which databases are being used the most and also take steps to optimize their work.