With the Database Manager built into the Web Hosting Control Panel, it will be easier to build brand new MySQL and PgSQL databases immediately! Furthermore, you’ll possess direct access to the administrator area software programs (phpMyAdmin and phpPgAdmin, respectively), which means you can quite easily edit the database you want.
An Intuitive User interface
The best database control interface
Database management may appear like a hard task to novice cloud hosting customers, nevertheless with our Database Manager, it’s actually really simple! To set up a new database, you just need to enter in the username and password. Database back–ups are a click away at the same time.People who desire to look into their databases and edit them should use the phpMyAdmin and phpPgAdmin tools.
Simple and quick Database Backup
Database backups are just a click away
Via the Database Manager you’ll be able to generate an archived backup of your database anytime you desire! This way, you are going to always have a data backup of your operating content if your web site gets compromised or you incorrectly get rid of a database. To create a back–up: click on the ’clock’ image beside a given database and then just wait for a few seconds for the process to be concluded.
There are no limits on the number of databases you are able to back up or the quantity of backups you can make for any database.
PgSQL Support
By far the most protected open source databases
Just about all of O2 REAL Hosting’s Linux shared website hosting bundles deliver PgSQL support. Although dropping behind MySQL when it comes to reputation and application, PgSQL databases are famous for supplying the top level of safety for your web site content. This is the basic reason why companies like Skype and Yahoo make use of PgSQL databases as an alternative to MySQL.
With respect to database management, PgSQL is as straightforward as MySQL.
InnoDB Databases
The brand new face of MySQL
With O2 REAL Hosting, you shall always find the latest variant of MySQL as well as the default MySQL storage engine – InnoDB, mounted.
InnoDB is definitely more dependable in comparison to the earlier storage engine’s edition – MyISAM. It’s ACID–compliant and, most importantly – it gives you full transaction support. It also uses row–level locking, as an alternative for MyISAM’s table–level locking, that previously used to result in functionality troubles at peak usage occasions.
Detailed Database Stats
Complete stats for all your databases
Monitoring the load produced by the databases for your active site will help you stop virtually any overload difficulties that could slow it down and ward off visitors. Therefore, we’ve bundled a detailed Database Stats tool straight into the Web Hosting Control Panel. There you can find broad info on the inbound requests to your databases for each and every hour, day and month.
Using the number of day–to–day and by the hour queries, it’s possible to find out which databases are utilized the most and also consider steps to enhance their work.
