Database Manager

The Database Manager in our Control Panel incorporates an effective yet convenient to use interface. You’re able to set up a new MySQL or PostgreSQL database by just typing a username and security password. Additionally, you can make a backup file or customize the password of any database with only a mouse click.

From the Database Manager you have immediate access to the administration area for every one of your databases, which enables you to make uncomplicated adjustments in the event you have to.

We’ve made the manual database backup creation into a quite simple job. To execute this: inside of the Database Manager, click the ’clock’ symbol next to the database that you plan to back up and then hang on for a couple of seconds for the process to take place. With respect to the size of the database, the generation of the back–up file will take somewhere between a few seconds and a minute.

You may make as many backups of a database as you would like. We have not determined any restrictions about the quantity of databases that you can back up too.

You will find PgSQL support in every one of our Linux shared hosting bundles. PgSQL databases might not be as famous and commonly used as MySQL, nevertheless they provide you with the top level of safety for your site content and articles. Therefore, a lot of well–known businesses like Skype and Yahoo apply PgSQL databases. Maintaining PgSQL databases is as simple and easy as MySQL, thanks to the easy–to–use interface of the Database Manager.

PgSQL databases are provided by default with the most advanced web hosting packages. For the regular bundles, they’re suggested as upgrades.

The MySQL databases on our servers utilize the most up–to–date release of the InnoDB storage engine. InnoDB was built to guarantee the max effectiveness for web sites that work with massive volumes of data. It offers CPU performance that could not be matched up by any other different disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, meaning it is possible to update/insert/create/alter/drop many times for one "operation" of your web application. Furthermore, it works by using row–level locking in lieu of MyISAM’s table–level locking, that raises multi–user concurrency and effectiveness.

We supply you a quick solution to track the database use for your dynamic websites. Via the in–depth database statistics user interface, that is built into the Control Panel, it’s possible to keep an eye on the load created by your dynamic websites in real time. The presented info will help you analyze the database load changes by the hour, daily or per month.

You’ll be able to keep track of the database load for all of your web sites in the Database Stats portion of the Control Panel. The table on–screen reveals the database lookups made during the present month. To examine details for an earlier month, simply click on the back arrows located at the top.