Databases Manager

The Databases Manager inside our Control Panel features an effective but simple to operate user interface. It is possible to set up a new MySQL or PostgreSQL database by just typing a user name and security password. In addition, you can make a backup file or customize the security password of an database with just a mouse click.

Through the Databases Manager you will possess direct access to the administrator area for all your databases, so you’re able to make quick adjustments should you have to.

We’ve made the manual database backup formation into a quite simple activity. To execute that: inside the Databases Manager, click the ’clock’ symbol near the database that you plan to back up and wait for a couple of seconds for the backup process to take place. With respect to the size of your database, the creation of any backup file will need between a couple of seconds and a minute.

You may create as many copies of a database as you want. We haven’t determined any confines on the volume of databases you could back up as well.

You’re going to find PgSQL support in each of our Linux website hosting packages plans. PgSQL databases might not be as sought after and widely used as MySQL, nonetheless they supply you with the best level of protection for your website content and articles. For this reason, a number of widely known companies like Skype and Yahoo make use of PgSQL databases. Taking care of PgSQL databases is as simple as MySQL, because of the intuitive user interface of the Databases Manager.

PgSQL databases are provided automatically inside of the most sophisticated web hosting plans. For the standard plans, they are suggested as upgrades.

We’ve set up InnoDB – the new default MySQL database engine on every one of our web servers. InnoDB is made for significant database sites which require high general performance and scalability. Experiments demonstrate that websites employing InnoDB based tables attain a 3–fold overall performance increase for large joins, when compared with those making use of MyISAM tables.

InnoDB works by using row–level locking in an effort to eliminate the effectiveness issues seen at the peak usage times of the previous variant of the database engine – MyISAM, which uses table–level locking.

From the in depth database stats tool integrated into the Control Panel, it will be possible to keep a record of the stress generated from your busy web sites 24 hour a day. Any overload issue with your sites could slow the loading speeds and have a negative influence over the online experience of your site visitors. So, having info about the database load in real time, it will be possible to eliminate overload problems as quickly as possible.

The database statistics user interface displays data of the amount of daily, hourly and monthly lookups, so you’re able to analyze the way the load is spread over several time frames.