Databases Manager

The Databases Manager inside the Online Control Panel features a refined but user friendly interface. You’re able to configure a whole new MySQL or PostgreSQL database by just specifying a user name and security password. What’s more, you can make a backup file or alter the password of any database with simply a click of the mouse.

Through the Databases Manager you will have direct access to the management area for each of your databases, in order to make quick changes in case you have to.

From the Databases Manager it’s easy to generate an archived copy of your database whenever you want! Therefore, you are going to always have a backup of your operating content material in the event your website gets hacked or you erroneously eliminate a database. To generate a back–up: click on the ’clock’ icon next to a certain database and then just wait for a couple of seconds for the process to be concluded.

There won’t be any restrictions for the quantity of databases you are able to back up or the volume of backups you can make for a database.

PgSQL databases are less common as compared to the common MySQL databases. Then again, they represent a preferred selection for developers who are looking for the finest safety for their web sites and applications. Due to the incredibly user–friendly Databases Manager built–into the NixaWeb.com Control Panel, you can control all of your PostgreSQL databases with a simple click of the mouse.

You will find PgSQL databases provided automatically within the best shared website hosting plans packages. In case you are using a standard hosting package, it is possible to ask for PgSQL databases to be added in your web hosting account as upgrades.

The MySQL databases on NixaWeb.com’s web servers utilize the most up–to–date release of the InnoDB storage engine. InnoDB has been created to ensure the optimum performance for websites that process massive volumes of data. It offers CPU efficiency that could not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, which means that you’ll be able to update/insert/create/alter/drop several times for a single "operation" of your application. Furthermore, it takes advantage of row–level locking and not MyISAM’s table–level locking, that boosts multi–user concurrency and performance.

We provide you a surprisingly simple method to keep an eye on the database utilization on your active web sites. Via the detailed database stats user interface, that’s built–into the Online Control Panel, you’ll be able to track the load accumulated by your active web sites in real time. The supplied information will assist you to assess the database load variations each hour, daily or on a monthly basis.

It’s possible to track the database load for your websites within the Database Stats part of the Online Control Panel. The table on–screen shows the database lookups made in the present month. To review information for an earlier month, simply click on the back arrows placed at the top.