Databases Manager

The Databases Manager within our Control Panel has a robust but well designed interface. You’ll be able to configure a new MySQL or PostgreSQL database by just typing a username and security password. Additionally, you may create a back–up file or change the security password of a database with only a mouse click.

From the Databases Manager you’ll possess direct access to the administration area for all your databases, which enables you to make easy adjustments if you happen to have to.

Assuming you have worked with databases, you know that making a manual database back–up just isn’t an elementary task. So as to change this, we have created an effortless to use tool that will back up your entire database with simply a single click. The back–up file shall be set for you in under a minute, with respect to the size of the chosen database.

There won’t be any limitations on just how many back–ups you may make for any selected database.

You will find PgSQL support in our cloud services offers. PgSQL databases aren’t as well–known and widespread as MySQL, nonetheless they provide you with the highest level of safety for your web site content. Due to this, many widely known companies such as Skype and Yahoo make use of PgSQL databases. Taking care of PgSQL databases is as easy as MySQL, thanks to the intuitive user interface of the Databases Manager.

PgSQL databases are incorporated by default with the most sophisticated web hosting packages. For the basic plans, they are suggested as upgrades.

The MySQL databases on Integrated Solutions’s machines utilize the newest release of the InnoDB storage engine. InnoDB was built to guarantee the optimum efficiency for sites that deal with massive amounts of data. It delivers CPU effectiveness that could not be equalled by any other different disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, meaning that it is possible to update/insert/create/alter/drop repeatedly for one "operation" of your web app. Moreover, it employs row–level locking in contrast to MyISAM’s table–level locking, that raises multi–user concurrency and performance.

Integrated Solutions offers you an uncomplicated technique to observe the database use for your busy websites. Via the in–depth database statistics user interface, that is incorporated into the Control Panel, you’ll be able to keep an eye on the load made through your busy sites in real time. The displayed information will let you analyze the database load fluctuations by the hour, each day or monthly.

You can easily observe the database load for all of your websites from the Database Stats portion of the Control Panel. The table on–screen presents the database queries made during the present month. To look at data for a previous month, just click on the back arrows situated at the top.