Database Manager

The Database Manager in our Web Control Panel incorporates a refined nevertheless straightforward interface. You can easily set up a whole new MySQL or PostgreSQL database simply by entering a username and security password. Furthermore, you could make a back–up file or alter the security password of an database with simply a mouse click.

From the Database Manager you’ll get immediate access to the administrator area for each of your databases, so that you can make quick adjustments if you happen to have to.

We have transformed the manual database backup generation into a simple job. To execute this: inside the Database Manager, click on the ’clock’ symbol beside the database that you plan to back up and hang on for a couple of seconds for the process to take place. With respect to the size of your database, the creation of the backup file will require between a couple of seconds and a minute.

You may make as many back–ups of a database as you wish. We have not fixed any confines on the number of databases that you could back up either.

You’ll find PgSQL support in each of our Linux shared hosting packages. PgSQL databases might not be as popular and commonly used as MySQL, but they deliver the highest possible level of security for your web site content and articles. Because of this, a number of widely known companies like Skype and Yahoo implement PgSQL databases. Handling PgSQL databases is as elementary as MySQL, because of the intuitive user interface of the Database Manager.

PgSQL databases are bundled by default in the most advanced web hosting bundles. For the normal packages, they’re presented as upgrades.

With OPTIMUMWEB2020, you shall consistently find the most up–to–date release of MySQL plus the default MySQL storage engine – InnoDB, installed.

InnoDB is more reliable as compared to the earlier storage engine’s edition – MyISAM. It is ACID–compliant and, most importantly – it has full transaction support. What’s more, it utilizes row–level locking, as a substitute for MyISAM’s table–level locking, that previously used to trigger effectiveness problems at peak usage periods.

Via the all–inclusive database stats tool included in the Web Control Panel, you’ll be able to keep tabs of the load produced from your busy websites 24 x 365. Virtually any overload issue with your web sites can slow the loading rates and have a bad effect on the overall experience of your respective visitors. Consequently, having info for the database load immediately, it will be easy to resolve overload troubles at once.

The database data interface displays information of the quantity of daily, hourly and monthly queries, which enables you to review how the load is distributed over different time periods.