Databases Manager

The Databases Manager within our Website Control Panel includes an effective but user–friendly interface. You can easily set up a completely new MySQL or PostgreSQL database by simply typing a user name and security password. Additionally, you can make a back–up file or modify the password of your database with just a click of the mouse.

With the Databases Manager you will have immediate access to the administrator area for all your databases, which means you can make uncomplicated alterations in case you need to.

Within the Databases Manager you’re able to make an archived duplicate of your database anytime you need! Thus, you are going to always have a data backup of your dynamic content in case your website gets hacked or you erroneously erase a database. To create a backup: click the ’clock’ icon on the side of a particular database and after that just wait for a few seconds for the process to be completed.

There won’t be any restricts on the volume of databases you can back up or the number of backups you can make for any database.

You are going to find PgSQL support in all our shared web hosting service packages. PgSQL databases are not as famous and widespread as MySQL, nonetheless they provide the highest possible level of stability for your web site content and articles. Therefore, a lot of famous businesses like Skype and Yahoo apply PgSQL databases. Maintaining PgSQL databases is as simple as MySQL, on account of the easy–to–use interface of the Databases Manager.

PgSQL databases are provided by default with the most innovative web hosting plans. For the normal plans, they’re featured as upgrades.

The MySQL databases on our servers make use of the most current release of the InnoDB storage engine. InnoDB was designed to guarantee the highest possible effectiveness for sites that process large amounts of data. It provides CPU performance that can not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies total transaction support, so that it is easy to update/insert/create/alter/drop repeatedly for a single "operation" of your web app. Moreover, it utilizes row–level locking in lieu of MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

Roomy Online offers you an uncomplicated way for you to keep tabs on the database use on your powerful web sites. Via the descriptive database stats user interface, that is included in the Website Control Panel, you’re able to record the load made from your dynamic web sites in real time. The delivered info will let you evaluate the database load fluctuations each hour, on a daily basis or each month.

It is possible to monitor the database load for your web sites in the Database Stats part of the Website Control Panel. The table on–screen features the database lookups made within the present month. To take a look at information for a past month, just click on the back arrows situated at the top.