Inside of the DomainHosting Online Control Panel you will find a fully–fledged, convenient to use Database Manager! Utilize it to enjoy total control over your databases. It is possible to conveniently create new MySQL and PgSQL databases and administer them through the phpMyAdmin and phpPgAdmin software tools, respectively.
An Easy to use Interface
The easiest to use database administration interface
Database management might sound like a difficult job to beginner website hosting clients, however with the Database Manager, it’s actually really simple! To configure a brand new database, you only need to enter your username and password. Database backups are a mouse click away as well.Those who need to look into their databases and edit them are able to use the phpMyAdmin and phpPgAdmin tools.
Simple and quick Database Back–up
Database backups are a click away
With the Database Manager it is easy to create an archived duplicate of your database whenever you wish! Thus, you are going to always have a data backup of your active content in case your site gets broken into or you mistakenly remove a database. To create a back–up: click on the ’clock’ icon alongside a given database and afterwards just wait for a few seconds for the backup process to be concluded.
There won’t be any limitations for the quantity of databases you would be able to back up or the volume of backup copies you can make for any database.
PgSQL Support
Essentially the most secure open source databases
Almost all of our cloud plans bundles present PgSQL support. Although dropping behind MySQL with regards to acceptance and usage, PgSQL databases are famous for providing the highest level of stability for your site content material. It is the reason why businesses like Skype and Yahoo use PgSQL databases as an alternative to MySQL.
When it comes to database administration, PgSQL is just as easy to use as MySQL.
InnoDB Databases
The fresh new face of MySQL
We’ve incorporated InnoDB – the new standard MySQL database engine on all our machines. InnoDB is great for substantial database web sites that demand high levels of effectiveness and scalability. Experiments show that sites utilizing InnoDB based tables achieve a 3–fold overall performance increase for significant joins, compared with those working with MyISAM tables.
InnoDB employs row–level locking in order to eliminate the functionality problems witnessed at the maximum consumption times of the previous release of the database engine – MyISAM, which employs table–level locking.
Detailed Database Stats
Comprehensive stats for your databases
Keeping track of the load generated by the databases on your active site will help you avoid any sort of overload troubles that might slow it down and ward off website visitors. As a result, we’ve included a thorough Database Stats tool in the Online Control Panel. There you shall find in depth information regarding the inbound requests to your databases for every hour, day and month.
Depending on the number of day–to–day and hourly queries, you are going to be able to find out which databases are being used the most and also take steps to optimize their work.
