Databases Manager

Database management may sound like a difficult job to newbie web hosting clients, however with NTCommerce Hosting’s Databases Manager, it’s actually really simple! To configure a completely new database, you only need to enter in your username and password. Database backup copies are only a mouse click away also.Those who desire to examine their databases as well as modify them may use the phpMyAdmin and phpPgAdmin tools.

We have developed the manual database back–up formation into a simple activity. To execute this: inside of the Databases Manager, click on the ’clock’ image on the side of the database that you want to back up and afterwards hang on for a couple of seconds for the process to take place. With regards to the size of the database, the building of any back–up file will take between a couple of seconds and a minute.

You may create as many backup copies per database as you desire. We’ve not set any limits for the amount of databases that you could back up either.

Almost all of NTCommerce Hosting’s shared plans packages grant PgSQL support. Whilst dropping behind MySQL regarding popularity and employment, PgSQL databases are renowned for providing the top level of security for your website content. It is the primary reason why brands like Skype and Yahoo rely upon PgSQL databases in lieu of MySQL.

With respect to database management, PgSQL is just as hassle–free as MySQL.

The MySQL databases on NTCommerce Hosting’s machines work with the newest build of the InnoDB storage engine. InnoDB has been made to guarantee the maximum performance for sites that operate with large amounts of data. It delivers CPU efficiency that can not be equalled by alternative disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, which means you’re able to update/insert/create/alter/drop several times for one "operation" of your web app. Additionally, it works by using row–level locking in lieu of MyISAM’s table–level locking, that increases multi–user concurrency and performance.

We provide you a painless method to keep track of the database consumption of your powerful websites. Through the thorough database statistics interface, that’s included in the Web Control Panel, it is easy to monitor the load made from your busy sites in real time. The supplied data will allow you to analyze the database load fluctuations each hour, per day or per month.

You’ll be able to observe the database load for all of your sites in the Database Stats area of the Web Control Panel. The table onscreen shows the database queries made within the present month. To assess details for a previous month, simply click on the back arrows situated at the top.