Databases Manager

Database management might sound like a hard task to inexperienced website hosting customers, nevertheless with the Databases Manager, it’s actually relatively easy! To configure a brand new database, you only ought to type in the username and password. Database back–ups are only a mouse click away as well.People that desire to examine their databases as well as revise them can make use of the phpMyAdmin and phpPgAdmin tools.

In case you have dealt with databases, you know making a manual database backup isn’t a basic job. In an effort to change this, we’ve made an easy to understand tool that can back up the entire database with just a single click of the mouse. The backup file shall be prepared for you in under a minute, with respect to the size of the selected database.

There are no restrictions on the number of copies you can make for any particular database.

PgSQL databases are much less common in comparison to the common MySQL databases. On the other hand, they represent a favorite selection for developers who are looking for the best protection for their sites and applications. Thanks to the easy–to–use Databases Manager included in the 1-Shot Web Hosting Control Panel, you can administer all your PostgreSQL databases with merely a mouse click.

You’ll find PgSQL databases included automatically in the advanced Linux web hosting packages. Provided that you are using a standard hosting package, you can request PgSQL databases to be included in your web hosting account as upgrades.

With 1-Shot Web Hosting, you shall inevitably find the most up–to–date release of MySQL plus the default MySQL storage engine – InnoDB, set up.

InnoDB is definitely more reliable as compared to the previous storage engine’s version – MyISAM. It’s ACID–compliant and, even more importantly – it includes complete transaction support. You’ll find, it utilizes row–level locking, as a substitute for MyISAM’s table–level locking, that would always result in efficiency problems at high usage times.

Keeping tabs on the load accumulated by the databases in your powerful web site will help you prevent all kinds of overload difficulties that could slow it down and ward off website visitors. For that reason, we’ve incorporated a detailed Database Stats tool inside the Site Control Panel. There you shall find complete information regarding the arriving requests to your databases for each and every hour, day and month.

Based on the quantity of daily and hourly queries, you’re going to be able to determine which databases are used the most and also take measures to optimize their work.