Databases Manager

The Databases Manager inside our Website Control Panel has an effective but still straightforward user interface. It’s possible to set up a new MySQL or PostgreSQL database by just entering a user name and password. Additionally, you can create a backup file or alter the security password of any database with just a click of the mouse.

With the Databases Manager you will have direct access to the admin area for each of your databases, which means you can make simple adjustments if you ever need to.

We’ve designed the manual database back–up formation into a quite easy activity. To execute this: in the Databases Manager, click on the ’clock’ image near the database that you would like to back up and afterwards wait for a few seconds for the process to take place. With regards to the size of the database, the building of a backup file can take somewhere between a few seconds and a minute.

You can make as many backups per database as you would like. We have not determined any boundaries for the volume of databases that you can back up either.

PgSQL databases are less widespread when compared to the widespread MySQL databases. Nonetheless, they are a preferred option for programmers who are looking for the finest stability for their websites and web applications. Thanks to the user–friendly Databases Manager built into the Hostnuke Control Panel, you can administer your PostgreSQL databases with a click of the mouse.

You’ll find PgSQL databases integrated automatically in the top cloud web hosting packages. Provided that you are with a standard hosting package, you’re able to ask for PgSQL databases to be added to your website hosting account as upgrades.

We’ve integrated InnoDB – the brand new default MySQL database engine on all our web servers. InnoDB is perfect for substantial database web sites that demand high overall performance and scalability. Trials have established that websites using InnoDB based tables reach a 3–fold effectiveness boost for significant joins, as compared to those using MyISAM tables.

InnoDB employs row–level locking so as to get rid of the overall performance problems seen at the peak usage times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.

With the in depth database stats tool built into the Website Control Panel, it’s possible to make a record of the load created by your active websites round the clock. Any overload issue with your sites can lower the loading rates and have a damaging impact on the overall experience of your respective site visitors. Thus, by having details about the database work in real time, it is also possible to eliminate overload problems at once.

The database stats interface reveals info of the amount of daily, hourly and monthly lookups, in order to examine just how the load is distributed over different time periods.