Database Manager

Database management may sound like a difficult task to beginner web hosting clients, but with our Database Manager, it’s actually reasonably easy! To set up a new database, you just need to type in your username and password. Database backups are simply a mouse click away too.People that wish to look into their databases as well as revise them are able to use the phpMyAdmin and phpPgAdmin tools.

We have changed the manual database back–up formation into a quite simple task. To execute this: inside the Database Manager, click on the ’clock’ image beside the database that you plan to back up and after that hang on for a couple of seconds for the process to take place. With respect to the size of your database, the generation of a backup file will take between a couple of seconds and a minute.

You may make as many backup copies of a database as you desire. We have not specified any boundaries on the quantity of databases you could back up too.

Practically all of our Linux shared hosting plans offer PgSQL support. While falling behind MySQL with regards to global recognition and utilization, PgSQL databases are renowned for offering up the greatest level of stability for your web site content and articles. That’s the primary reason why brands like Skype and Yahoo rely on PgSQL databases as an alternative to MySQL.

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

The MySQL databases on EZ123WebHost.com’s web servers work with the newest build of the InnoDB storage engine. InnoDB was designed to ensure the top functionality for sites that work with big amounts of data. It grants CPU efficiency that could not be matched up by any other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, so that you’ll be able to update/insert/create/alter/drop more than once for one "operation" of your app. At the same time, it makes use of row–level locking as a substitute for MyISAM’s table–level locking, that improves multi–user concurrency and performance.

Checking the load produced by the databases in your active site assists you to stop all kinds of overload issues that could slow it down and ward off site visitors. For this specific purpose, we’ve incorporated a thorough Database Stats tool directly into the Hosting Control Panel. There you will find all–inclusive information regarding the arriving requests to your databases for every hour, day and month.

Using the volume of day–to–day and by the hour queries, it is possible to find out which databases are being used the most and also take procedures to optimize their work.