Databases Manager

Supervising your databases is less complicated than in the past, because of the Site Control Panel user interface for MySQL and PgSQL administration! In case you do not have detailed knowledge of utilizing databases, it will be easy to manage RE2 Technology Consultants’s Databases Manager.

You can create a whole new database by simply specifying the username and password or make a database backup with just a click of the mouse. At the same time, within the Data Manager you have direct access to the admin area for every single database, which means you can effectively update it.

We’ve transformed the manual database back–up formation into a very easy job. To do so: within the Databases Manager, click the ’clock’ symbol on the side of the database that you intend to back up and then hang on for a few seconds for the backup process to take place. Depending upon the size of your database, the creation of a back–up file will need somewhere between a couple of seconds and a minute.

You can create as many copies per database as you would like. We’ve not determined any boundaries for the number of databases you can back up too.

PgSQL databases are much less common in comparison to the popular MySQL databases. Having said that, they represent a preferred choice for designers who seek the finest security for their websites and apps. Thanks to the incredibly user–friendly Databases Manager built–into the RE2 Technology Consultants Control Panel, you can administer your PostgreSQL databases with simply a click of the mouse.

You can discover PgSQL databases included automatically in the advanced Linux shared website hosting packages. In case you are with a standard hosting package, it is possible to ask for PgSQL databases to be added to your cloud hosting account as upgrades.

The MySQL databases on RE2 Technology Consultants’s web servers make use of the most up–to–date build of the InnoDB storage engine. InnoDB is created to guarantee the highest effectiveness for web sites that process large amounts of data. It offers CPU effectiveness that can not be matched up by any other different disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, meaning it’s possible to update/insert/create/alter/drop repeatedly for a single "operation" of your app. At the same time, it makes use of row–level locking in contrast to MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

We provide you a simple and easy method to keep tabs on the database usage for your dynamic web sites. Via the in depth database stats user interface, that’s included in the Site Control Panel, you can record the load made through your dynamic websites in real time. The delivered data will allow you to evaluate the database load changes every hour, every day or per month.

You are able to record the database load for your sites through the Database Stats portion of the Site Control Panel. The table onscreen presents the database lookups accumulated in the present month. To check information for an earlier month, all you have to do is click on the back arrows located at the top.