Database Manager

The Database Manager inside the Web Hosting Control Panel features an effective yet straightforward interface. You can easily configure a brand new MySQL or PostgreSQL database by just typing a user name and security password. Furthermore, you can make a back–up file or modify the security password of an database with just a mouse click.

Via the Database Manager you will possess direct access to the administrative area for each of your databases, which enables you to make hassle–free modifications when you have to.

Provided you have dealt with databases, you already know that making a manual database back–up just isn’t a basic job. In an effort to change this, we’ve developed an easy to understand tool that can back up your whole database with one click of the mouse. The back–up file shall be prepared for you in less than a minute, depending upon the size of the chosen database.

There are no restrictions on exactly how many copies you can make for a specific database.

PgSQL databases are much less widespread as compared to the prevalent MySQL databases. Nonetheless, they represent a favored option for developers seeking the maximum security for their web sites and apps. Through the incredibly user–friendly Database Manager incorporated into the Inspireweb Control Panel, you can control your PostgreSQL databases with just a click of the mouse.

Yow will discover PgSQL databases incorporated by default inside the advanced shared website hosting packages. In case you are with a regular hosting package, it is easy to request PgSQL databases to be added in your account as upgrades.

The MySQL databases on Inspireweb’s machines utilize the most up–to–date version of the InnoDB storage engine. InnoDB was intended to ensure the optimum effectiveness for web sites that operate with huge volumes of data. It features CPU performance that can not be matched up by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives complete transaction support, meaning you’ll be able to update/insert/create/alter/drop more than once for a single "operation" of your app. Additionally, it employs row–level locking as an alternative for MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

From the comprehensive database stats tool built–into the Web Hosting Control Panel, you’re going to be able to keep a record of the stress created from your busy websites 24 x 365. Virtually any overload issue with your websites could reduce the loading speeds and have a negative impact on the online experience of your respective visitors. Which means that, having info for the database work in real time, you will be able to mend overload troubles without delay.

The database statistics interface displays information of the number of daily, hourly and monthly queries, meaning you can evaluate the way the load is allocated over various time frames.