Database Manager

Overseeing your databases is much easier than before, on account of the Website Control Panel interface for MySQL and PgSQL control! Even if you do not have detailed experience of making use of databases, it will be effortless to handle ServerAct’s Database Manager.

You may create a completely new database by simply specifying the username and security password or produce a database backup with merely a mouse click. In addition, from the Data Manager you will have direct access to the administrative area for each database, so its possible to instantly revise it.

We have evolved the manual database back–up generation into a simple job. To execute this: in the Database Manager, click on the ’clock’ symbol next to the database that you would like to back up and then wait around for a few seconds for the process to take place. Depending on the size of your database, the generation of the back–up file will take between a couple of seconds and a minute.

You may make as many backups per database as you would like. We’ve not specified any limitations about the volume of databases that you can back up too.

PgSQL databases are much less common as opposed to the prevalent MySQL databases. Then again, they are a favorite alternative for developers who seek the maximum stability for their websites and web applications. Via the easy–to–use Database Manager built–into the ServerAct Control Panel, you can control your PostgreSQL databases with a simple mouse click.

You can find PgSQL databases included automatically inside the advanced website hosting packages. If you are using a standard hosting package, you can easily ask for PgSQL databases to be added to your cloud hosting account as upgrades.

The MySQL databases on our web servers employ the latest release of the InnoDB storage engine. InnoDB has been meant to guarantee the highest possible effectiveness for web sites that operate with massive amounts of data. It grants CPU performance that could not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, which means that you’re able to update/insert/create/alter/drop a couple of times for one "operation" of your app. Also, it makes use of row–level locking in contrast to MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.

From the comprehensive database stats tool built–into the Website Control Panel, you’ll be able to keep a record of the load generated through your busy sites twenty–four hours a day. Every single overload trouble with your sites can reduce the loading rates and have a negative effect on the overall impression of your respective visitors. Hence, having information about the database load immediately, it will be easier to mend overload difficulties quickly.

The database stats user interface shows information of the volume of daily, hourly and monthly lookups, meaning you can review how the load is allocated over various periods of time.