Databases Manager

Administering your databases is much simpler than ever before, as a result of Site Control Panel interface for MySQL and PgSQL management! Provided you do not have substantial experience in handling databases, it will be an easy task to handle our Databases Manager.

You could make a new database by simply specifying the user name and security password or make a database back–up with a simple click of the mouse. In addition, from the Data Manager you will get direct access to the administrative area for each and every database, which means you can quite simply manage it.

From the Databases Manager it’s easy to produce an archived copy of your database anytime you would like! For this reason, you will always have a data backup of your dynamic content if your web site gets broken into or you erroneously delete a database. To produce a backup: click on the ’clock’ icon on the side of any database and after that simply wait for a few seconds for the backup process to be finished.

There aren’t any confines about the volume of databases you are able to back up or the number of back–ups you can make for any database.

PgSQL databases are significantly less famous as opposed to the common MySQL databases. However, they are a favorite alternative for web developers who are looking for the greatest safety for their sites and web apps. Because of the user–friendly Databases Manager incorporated into the SQUAD Network Control Panel, you can control your PostgreSQL databases with merely a mouse click.

You’ll find PgSQL databases provided by default with the top Linux cloud packages packages. In case you are using a basic hosting package, you’re able to request PgSQL databases to be added in your cloud hosting account as upgrades.

The MySQL databases on our servers use the most up–to–date version of the InnoDB storage engine. InnoDB is created to guarantee the top functionality for sites that operate with substantial amounts of data. It boasts CPU effectiveness that could not be matched by other different disk–based relational database engines.

InnoDB is ACID–compliant and gives full transaction support, meaning it is possible to update/insert/create/alter/drop many times for a single "operation" of your web application. Additionally, it utilizes row–level locking in place of MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

With the all–inclusive database stats tool integrated into the Site Control Panel, you are able to keep tabs of the load generated by your dynamic sites 24 hour a day. Virtually any overload issue with your web sites could lower the loading speeds and have a damaging impact on the overall impression of your site visitors. Hence, having data about the database work immediately, you’ll be able to eliminate overload difficulties promptly.

The database data interface reveals information of the amount of daily, hourly and monthly lookups, to help you to assess how the load is distributed over several time periods.