Database Manager

The Database Manager in our Control Panel features a powerful but simple to use user interface. It’s possible to configure a brand new MySQL or PostgreSQL database by simply specifying a username and password. Furthermore, you could make a backup file or change the security password of your database with only a click of the mouse.

Via the Database Manager you’ll possess direct access to the management area for all of your databases, so its possible to make effortless alterations should you have to.

From the Database Manager it’s possible to generate an archived duplicate of your database whenever you desire! For this reason, you will always have a back–up of your active content in case your web site gets broken into or if you erroneously erase a database. To create a backup: click on the ’clock’ icon next to a certain database and afterwards just wait for a couple of seconds for the backup process to be performed.

There are not any boundaries on the volume of databases you can back up or the quantity of backups you may make for any database.

You can find PgSQL support in every one of our shared hosting offers. PgSQL databases are not as famous and widespread as MySQL, however they supply the highest level of safety for your web site content. Therefore, many widely known companies such as Skype and Yahoo take advantage of PgSQL databases. Dealing with PgSQL databases is as simple as MySQL, thanks to the intuitive user interface of the Database Manager.

PgSQL databases are included automatically inside of the most sophisticated web hosting plans. For the basic plans, they are included as upgrades.

The MySQL databases on infinity hosting’s web servers use the most recent build of the InnoDB storage engine. InnoDB is meant to guarantee the highest effectiveness for sites that deal with huge amounts of data. It supplies CPU performance that could not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers full transaction support, which means that you’ll be able to update/insert/create/alter/drop a couple of times for a single "operation" of your app. Furthermore, it makes use of row–level locking and not MyISAM’s table–level locking, that enhances multi–user concurrency and performance.

We offer you an uncomplicated option to keep track of the database usage for your powerful websites. From the detailed database stats user interface, that’s built into the Control Panel, it is possible to record the load accumulated by your active websites in real time. The supplied details will allow you to evaluate the database load variations each hour, daily or on a monthly basis.

You can track the database load for all of your sites from the Database Stats part of the Control Panel. The table on–screen features the database queries made in the present month. To look at details for a previous month, just click on the back arrows placed at the top.