We give you an easy to navigate Databases Manager, included in our Web Control Panel, from where you could create new MySQL and PgSQL databases straight away. Moreover, you are allowed to oversee all their settings through the easy access offered to the phpMyAdmin and phpPgAdmin software instruments.
A User–friendly Interface
The simplest database management user interface
Database management may seem like a complicated job to novice cloud hosting customers, nevertheless with gate-hosting’s Databases Manager, it’s in fact relatively easy! To set up a brand new database, you just need to provide your username and password. Database backup copies are only a mouse click away also.Those who need to explore their databases and then modify them are able to use the phpMyAdmin and phpPgAdmin tools.
Easy Database Data backup
Back up your databases in just a minute
We’ve transformed the manual database backup formation into a simple activity. To do this: inside the Databases Manager, click on the ’clock’ image near 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 any back–up file will need somewhere between a few seconds and a minute.
You may make as many back–ups of a database as you would like. We haven’t specified any boundaries about the amount of databases that you could back up too.
PgSQL Support
The most secure open source databases
Just about all of gate-hosting’s hosting packages feature PgSQL support. Although falling behind MySQL with respect to global recognition and application, PgSQL databases are renowned for providing the best level of safety for your site content material. This is the reason why businesses like Skype and Yahoo use PgSQL databases instead of MySQL.
With regard to database management, PgSQL is just as hassle–free as MySQL.
InnoDB Databases
The fresh face of MySQL
The MySQL databases on gate-hosting’s servers utilize the most recent release of the InnoDB storage engine. InnoDB was intended to ensure the max functionality for websites that operate with sizeable volumes of data. It features CPU efficiency that could not be matched by any other different disk–based relational database engines.
InnoDB is ACID–compliant and grants total transaction support, which means you can easily update/insert/create/alter/drop several times for one "operation" of your app. At the same time, it makes use of row–level locking as an alternative to MyISAM’s table–level locking, that raises multi–user concurrency and efficiency.
Detailed Database Stats
In depth statistics for all of your databases
Monitoring the load caused by the databases on your active website will help you stop any sort of overload issues that can slow it down and chase away visitors. For this specific purpose, we have included a complete Database Stats tool inside the Web Control Panel. There you can get complete info about the incoming requests to your databases for each hour, day and month.
In line with the number of daily and per hour queries, you’re going to be able to find out what databases are employed the most and also consider steps to optimize their work.
