Inside of the Hosterati Hosting Control Panel you’ll find a fully–featured, user–friendly Databases Manager! Use it in order to get full command over all your databases. You’ll be able to quickly create new MySQL and PgSQL databases and oversee them with the phpMyAdmin and phpPgAdmin software programs, respectively.
A User friendly Interface
The simplest database management interface
Database management may appear like a difficult job to novice hosting customers, however with the Databases Manager, it’s in fact relatively easy! To set up a brand new database, you just have to type in your username and password. Database backup copies are just a mouse click away at the same time.People that want to examine their databases as well as revise them should use the phpMyAdmin and phpPgAdmin tools.
Quick and Simple Database Back–up
Database backup copies are just a mouse click away
Via the Databases Manager it’s easy to create an archived copy of your database when you want! Therefore, you’ll always have a backup of your dynamic information in the event your website gets hacked or you mistakenly eliminate a database. To create a back–up: click on the ’clock’ image alongside a particular database and after that just wait for a couple of seconds for the process to be executed.
There aren’t any restrictions on the number of databases you can back up or the amount of back–ups you can create for any database.
The most risk–free open source databases
Practically all of the web hosting plans grant PgSQL support. Although falling behind MySQL with respect to level of popularity and usage, PgSQL databases are renowned for providing the maximum level of security for your web site content and articles. It is the key reason why companies such as Skype and Yahoo go with PgSQL databases as opposed to MySQL.
With respect to database management, PgSQL is just as easy to understand as MySQL.
The fresh face of MySQL
The MySQL databases on Hosterati’s servers utilize the most current version of the InnoDB storage engine. InnoDB has been created to guarantee the highest possible functionality for web sites that operate with huge volumes of data. It offers CPU efficiency that could not be matched up by other different disk–based relational database engines.
InnoDB is ACID–compliant and supplies complete transaction support, which means that you can update/insert/create/alter/drop repeatedly for one "operation" of your app. In addition, it takes advantage of row–level locking as an alternative for MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.
Detailed Database Stats
Complete statistics for all your databases
Monitoring the load generated by the databases for your dynamic web site assists you to reduce any overload problems that could slow it down and ward off site visitors. For this specific purpose, we’ve bundled a in depth Database Stats tool straight into the Hosting Control Panel. There you can find comprehensive information about the incoming requests to your databases for every hour, day and month.
Based on the number of day–to–day and per hour queries, it will be easier to determine which databases are utilized the most and also take steps to enhance their work.