Inside of the HostNerd Web Hosting Control Panel you will find a fully–fledged, easy to use Database Manager! Utilize it to have total control of all your databases. You’ll be able to simply set up new MySQL and PgSQL databases and control them via the phpMyAdmin and phpPgAdmin software programs, respectively.
A Convenient User interface
The easiest to use database administration user interface
Database management might sound like a complicated job to newbie web hosting users, nevertheless with HostNerd’s Database Manager, it’s actually pretty simple! To create a whole new database, you only have to type in the username and password. Database backups are only a mouse click away at the same time.Those who wish to examine their databases and alter them should use the phpMyAdmin and phpPgAdmin tools.
Simple Database Data backup
Back up your databases in a minute
We’ve made the manual database backup creation into a very easy job. To execute that: inside the Database Manager, click on the ’clock’ icon beside the database that you want to back up and after that hang on for a few seconds for the backup process to take place. With regards to the size of the database, the creation of a back–up file is going to take between a couple of seconds and a minute.
You may create as many copies of a database as you desire. We have not set any boundaries about the volume of databases that you could back up either.
PgSQL Databases Support
By far the most secure open source databases
You’ll find PgSQL support in each of our Linux website hosting bundles. PgSQL databases aren’t as sought after and widely used as MySQL, nevertheless they provide the greatest level of safety for your web site content and articles. Due to this, several well–known companies like Skype and Yahoo work with PgSQL databases. Dealing with PgSQL databases is as easy as MySQL, due to the incredibly user–friendly interface of the Database Manager.
PgSQL databases are included automatically with the most innovative web hosting packages. For the basic bundles, they are included as upgrades.
The newest face of MySQL
The MySQL databases on HostNerd’s servers utilize the most current version of the InnoDB storage engine. InnoDB is meant to ensure the maximum performance for sites that deal with substantial volumes of data. It grants CPU efficiency that can not be matched by alternative disk–based relational database engines.
InnoDB is ACID–compliant and offers 100% transaction support, which means it is possible 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 in lieu of MyISAM’s table–level locking, that boosts multi–user concurrency and effectiveness.
Detailed Database Stats
Precise stats for all your databases
Tracking the load produced by the databases for your dynamic website makes it possible to reduce any kind of overload problems that could slow it down and ward off visitors. For this specific purpose, we’ve built in a in depth Database Stats tool directly into the Web Hosting Control Panel. There you can see all–encompassing information on the inbound requests to your databases for every single hour, day and month.
Using the quantity of day–to–day and by the hour queries, you will be able to determine which databases are employed the most and consider measures to optimize their load.