Via the Database Manager incorporated into the Online Control Panel, it’s possible to make brand–new MySQL and PgSQL databases immediately! Furthermore, you will have immediate access to the administrative area software tools (phpMyAdmin and phpPgAdmin, respectively), which enables you to quickly modify the database you want.
A Well designed Interface
The most convenient database control interface
Database management may appear like a complicated job to novice website hosting users, nevertheless with the Database Manager, it’s actually pretty simple! To set up a whole new database, you just have to key in your username and password. Database back–ups are simply a mouse click away as well.Those who need to explore their databases as well as edit them should use the phpMyAdmin and phpPgAdmin tools.
Speedy Database Data backup
Back up your databases in a minute
We’ve changed the manual database back–up creation into a quite easy job. To do so: within the Database Manager, click the ’clock’ symbol beside the database that you plan to back up and wait for a couple of seconds for the process to take place. With regards to the size of your database, the building of a backup file will need between a couple of seconds and a minute.
You can make as many backups per database as you would like. We’ve not specified any confines about the amount of databases you can back up either.
PgSQL Databases Support
Essentially the most safe open source databases
You are going to find PgSQL support in each of our shared web hosting offers. PgSQL databases aren’t as popular and widespread as MySQL, however they deliver the top level of stability for your site content. Due to this, a number of famous businesses like Skype and Yahoo implement PgSQL databases. Handling PgSQL databases is as elementary as MySQL, as a result of the easy–to–use interface of the Database Manager.
PgSQL databases are incorporated automatically in the most innovative web hosting packages. For the regular bundles, they are featured as upgrades.
The fresh face of MySQL
The MySQL databases on Infinityhosting’s machines utilize the newest build of the InnoDB storage engine. InnoDB is made to ensure the maximum efficiency for websites that deal with massive amounts of data. It grants CPU effectiveness that could not be matched by alternative disk–based relational database engines.
InnoDB is ACID–compliant and offers full transaction support, so that it is possible to update/insert/create/alter/drop more than once for one "operation" of your web application. Also, it utilizes row–level locking in place of MyISAM’s table–level locking, that enhances multi–user concurrency and efficiency.
Detailed Database Stats
In depth stats for all of your databases
Keeping track of the load accumulated by the databases in your active website assists you to stop all sorts of overload difficulties that might slow it down and ward off site visitors. For that reason, we have designed a complete Database Stats tool into the Online Control Panel. There you can get extensive information on the incoming requests to your databases for each and every hour, day and month.
Depending on the amount of day–to–day and hourly queries, it will be straightforward to find out which databases are utilized the most and then consider procedures to enhance their work.