Database Manager

Supervising your databases now is easier than ever before, due to the Control Panel user interface for MySQL and PgSQL management! Even though you may not have considerable experience of making use of databases, it will be an easy task to deal with 1982 Hosting’s Database Manager.

You may create a new database merely by specifying the user name and password or make a database back–up with a click of the mouse. Likewise, with the Data Manager you’ll get direct access to the management area for every database, so you’re able to quite simply update it.

We’ve transformed the manual database backup formation into a simple activity. To execute this: inside the Database Manager, click the ’clock’ image near the database that you plan to back up and then wait for a couple of seconds for the backup process to take place. With respect to the size of your database, the creation of the backup file is going to take between a few seconds and a minute.

You can create as many copies per database as you desire. We haven’t fixed any confines on the amount of databases that you can back up either.

You can find PgSQL support in all our Linux web hosting offers. PgSQL databases might not be as well–known and frequently used as MySQL, however they provide you with the highest level of stability for your site content and articles. Due to this, a number of famous businesses like Skype and Yahoo work with PgSQL databases. Managing PgSQL databases is as easy as MySQL, as a result of the easy–to–use interface of the Database Manager.

PgSQL databases are incorporated automatically in the most advanced web hosting bundles. For the normal packages, they are included as upgrades.

The MySQL databases on 1982 Hosting’s machines make use of the newest version of the InnoDB storage engine. InnoDB has been intended to ensure the maximum functionality for web sites that process large volumes of data. It provides CPU efficiency that could not be matched up by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and supplies full transaction support, meaning that it’s possible to update/insert/create/alter/drop many times for one "operation" of your app. Additionally, it works by using row–level locking instead of MyISAM’s table–level locking, that improves multi–user concurrency and effectiveness.

Through the complete database stats tool incorporated into the Control Panel, you will be able to keep track of the stress produced from your active sites at any hour. Any overload issue with your sites could lower the loading rates and have a negative impact on the overall impression of your visitors. Thus, having info about the database load in real time, it is also possible to eliminate overload difficulties straight away.

The database stats interface reveals details of the volume of daily, hourly and monthly queries, so you’re able to review the way the load is spread over various time frames.