Database Manager

Managing your databases now is easier than before, on account of the Site Control Panel interface for MySQL and PgSQL management! Provided you do not have considerable expertise in dealing with databases, you will find it effortless to handle rodriguez Hosting’s Database Manager.

You could make a brand new database by just typing the username and security password or generate a database backup with only a click of the mouse. Additionally, from the Data Manager you will have direct access to the administration area for each database, so its possible to effectively alter it.

We’ve evolved the manual database back–up generation into a quite simple job. To execute this: inside the Database Manager, click on the ’clock’ image beside the database that you intend to back up and then wait around for a couple of seconds for the process to take place. Depending upon the size of your database, the building of a back–up file can take somewhere between a few seconds and a minute.

You may make as many copies per database as you want. We have not determined any confines on the quantity of databases that you can back up either.

You will find PgSQL support in every one of our shared hosting plans. PgSQL databases might not be as well–known and frequently used as MySQL, however they supply you with the greatest level of stability for your website content. Due to this, many famous businesses like Skype and Yahoo make use of PgSQL databases. Dealing with PgSQL databases is as simple as MySQL, on account of the easy–to–use user interface of the Database Manager.

PgSQL databases are incorporated automatically inside the most sophisticated web hosting packages. For the standard packages, they’re presented as upgrades.

We have integrated InnoDB – the new default MySQL database engine on our servers. InnoDB is great for large database sites that require high levels of efficiency and scalability. Experiments have revealed that websites applying InnoDB based tables reach a 3–fold general performance increase for very large joins, compared with those utilizing MyISAM tables.

InnoDB utilizes row–level locking so as to get rid of the functionality issues witnessed at the maximum consumption times of the previous release of the database engine – MyISAM, which uses table–level locking.

Our company offers you a simple option to keep track of the database consumption for your powerful websites. From the in depth database statistics user interface, which is built into the Site Control Panel, you’re able to keep track of the load generated by your busy websites in real time. The provided details will let you analyze the database load variations by the hour, every day or each month.

You are able to observe the database load for your websites in the Database Stats area of the Site Control Panel. The table onscreen shows the database queries created during the present month. To assess information and facts for an earlier month, click on the back arrows situated at the top.