Database Manager

Managing your databases is simpler than ever before, as a result of Web Control Panel interface for MySQL and PgSQL administration! In case you do not have thorough knowledge in making use of databases, it will be simple to deal with NewHost Global’s Database Manager.

You can create a brand new database merely by entering the user name and password or create a database back–up with only a mouse click. In addition, through the Data Manager you’ll possess direct access to the administrator area for each individual database, so you’re able to quickly alter it.

From the Database Manager it’s easy to create an archived duplicate of your database when you desire! Therefore, you will always have a data backup of your operating information if your site gets broken into or if you mistakenly get rid of a database. To make a back–up: click the ’clock’ icon beside a particular database and then wait for a few seconds for the process to be executed.

There are not any limitations about the number of databases you would be able to back up or the amount of backups you may make for any database.

Practically all of our shared hosting packages plans offer PgSQL support. Although dropping behind MySQL with regard to global recognition and usage, PgSQL databases are renowned for offering up the greatest level of protection for your web site content material. That’s the primary reason why brands like Skype and Yahoo use PgSQL databases as opposed to MySQL.

In relation to database administration, PgSQL is identically quick as MySQL.

We have installed InnoDB – the brand new standard MySQL database engine on all our machines. InnoDB is designed for large database web sites that require high levels of effectiveness and scalability. Trials have revealed that websites using InnoDB based tables reach a 3–fold general performance increase for large joins, as compared to those utilizing MyISAM tables.

InnoDB utilizes row–level locking so as to take away the general performance difficulties noticed at the high usage times of the previous release of the database engine – MyISAM, which utilizes table–level locking.

We offer you a simple route to monitor the database use of your dynamic websites. From your in depth database stats user interface, that’s integrated into the Web Control Panel, you’re able to record the load created by your active sites in real time. The presented data will let you assess the database load changes on an hourly basis, each day or each month.

You are able to observe the database load for all your sites in the Database Stats area of the Web Control Panel. The table onscreen shows the database queries created within the present month. To review info for a previous month, click on the back arrows positioned at the top.