Database Manager

Database management may seem like a hard task to newbie web hosting clients, nevertheless with our Database Manager, it’s actually relatively easy! To set up a completely new database, you just ought to provide the username and password. Database back–ups are a click away as well.People that need to examine their databases and then modify them may use the phpMyAdmin and phpPgAdmin tools.

With the Database Manager you can easily produce an archived duplicate of your database anytime you need! For this reason, you are going to always have a data backup of your active content material if your website gets broken into or you accidentally eliminate a database. To make a backup: click the ’clock’ icon beside any database and after that simply wait for a few seconds for the process to be done.

There are not any limits on the volume of databases you would be able to back up or the volume of back–ups you can make for a database.

PgSQL databases are less common compared to the well–known MySQL databases. Even so, they are a favorite selection for programmers who are looking for the best safety for their sites and web apps. Thanks to the incredibly user–friendly Database Manager integrated into the LIGHTMGROUP Cloud Control Panel, you can control all your PostgreSQL databases with only a mouse click.

You will find PgSQL databases integrated automatically inside the best Linux shared hosting packages. In case you are with a basic hosting package, you are able to request PgSQL databases to be added to your account as upgrades.

The MySQL databases on LIGHTMGROUP Cloud’s machines use the most current release of the InnoDB storage engine. InnoDB was intended to ensure the maximum efficiency for web sites that operate with sizeable amounts of data. It provides CPU effectiveness that could not be matched up by other different disk–based relational database engines.

InnoDB is ACID–compliant and provides 100% transaction support, meaning it is possible to update/insert/create/alter/drop many times for a single "operation" of your application. Also, it works by using row–level locking instead of MyISAM’s table–level locking, that raises multi–user concurrency and effectiveness.

Via the in depth database stats tool incorporated into the Hosting Control Panel, you’re going to be able to keep a record of the stress accumulated through your dynamic web sites around the clock. Every overload difficulty with your websites can slow the loading rates and have a damaging influence over the online experience of your respective website visitors. So, having details for the database load live, it will be straightforward to fix overload issues at once.

The database statistics interface displays info of the quantity of daily, hourly and monthly queries, so that you can evaluate the way the load is distributed over several periods of time.