From within the Database Manager integrated into the Site Control Panel, you are able to set–up brand new MySQL and PgSQL databases immediately! Furthermore, you will have direct access to the management area software tools (phpMyAdmin and phpPgAdmin, respectively), so you can almost instantly update the database you want.
A Simple point and click Interface
Deal with your databases with merely a mouse click
Overseeing your databases is simpler than ever before, due to the Site Control Panel interface for MySQL and PgSQL administration! Even if you do not have thorough knowledge in working with databases, it will be simple to work with the Database Manager.
You can make a new database by simply entering the username and password or make a database back–up with simply a click of the mouse. Likewise, within the Data Manager you’ll possess direct access to the administration area for every database, to help you to effortlessly alter it.
Quick Database Data backup
Defend your database content with just a mouse click
In case you have dealt with databases, you already know that making a manual database back–up just isn’t a simple job. In an effort to change this, we have developed very simple tool that can back up your complete database with merely one click. The back–up file shall be prepared for you in under a minute, based on the size of the chosen database.
There won’t be any restrictions on how many backups you can make for a specific database.
By far the most risk–free open source databases
A lot of the Linux cloud web hosting packages plans provide PgSQL support. While dropping behind MySQL when considering acceptance and application, PgSQL databases are famous for delivering the top level of protection for your website content and articles. This is the main reason why companies such as Skype and Yahoo make use of PgSQL databases and not MySQL.
When it comes to database administration, PgSQL is just as quick as MySQL.
The new face of MySQL
We have installed InnoDB – the brand new default MySQL database engine on each of our machines. InnoDB is great for huge database sites which need high levels of effectiveness and scalability. Trials have demonstrated that web sites applying InnoDB based tables reach a 3–fold effectiveness grow for massive joins, in comparison with those making use of MyISAM tables.
InnoDB works by using row–level locking so as to remove the operation issues found at the maximum usage times of the prior release of the database engine – MyISAM, which uses table–level locking.
Detailed Database Stats
Complete stats for your databases
i Host and Web offers you a very easy method to track the database usage on your busy sites. From the in depth database stats user interface, that’s built–into the Site Control Panel, you are able to keep an eye on the load generated by your active websites in real time. The provided details will assist you to assess the database load changes each hour, per day or per month.
You can record the database load for all your web sites from the Database Stats area of the Site Control Panel. The table onscreen features the database lookups made during the present month. To check information and facts for a previous month, just click on the back arrows positioned at the top.