Database Manager

The Database Manager inside our Hosting Control Panel incorporates a robust nevertheless easy to use user interface. You can configure a new MySQL or PostgreSQL database by simply entering a username and password. Furthermore, you can create a backup file or change the password of any database with a click of the mouse.

With the Database Manager you’ll get direct access to the administrative area for every one of your databases, so that you can make simple adjustments if you ever need to.

Through the Database Manager you are able to produce an archived duplicate of your database whenever you wish! This way, you’ll always have a back–up of your operating content if your website gets hacked or if you incorrectly remove a database. To produce a back–up: click the ’clock’ icon on the side of a given database and after that wait for a couple of seconds for the backup process to be carried out.

There are no limits for the amount of databases you can back up or the amount of back–ups you may make for any database.

The majority of Hostexer’s shared hosting packages present PgSQL support. Although dropping behind MySQL in terms of level of popularity and utilization, PgSQL databases are renowned for supplying the highest level of safety for your site content. This is the primary reason why companies such as Skype and Yahoo make use of PgSQL databases instead of MySQL.

With regard to database administration, PgSQL is just as easy to understand as MySQL.

The MySQL databases on Hostexer’s machines make use of the most recent build of the InnoDB storage engine. InnoDB has been meant to ensure the max effectiveness for sites that operate with substantial volumes of data. It features CPU effectiveness that could not be matched by any other different disk–based relational database engines.

InnoDB is ACID–compliant and grants full transaction support, which means you’ll be able to update/insert/create/alter/drop many times for a single "operation" of your web app. In addition, it works by using row–level locking in contrast to MyISAM’s table–level locking, that increases multi–user concurrency and functionality.

Via the all–inclusive database statistics tool incorporated into the Hosting Control Panel, it will be possible to keep a record of the stress generated by your busy web sites round the clock. Every single overload problem with your websites can lower the loading speeds and have a bad effect on the online experience of your site visitors. Which means that, by having information about the database load instantly, you are able to fix overload issues promptly.

The database data user interface shows details of the volume of daily, hourly and monthly lookups, which means you can evaluate how the load is spread over several time frames.