Database Manager

Database management may seem like a difficult job to beginner cloud hosting users, nevertheless with our Database Manager, it’s in fact pretty simple! To configure a new database, you just need to enter in your username and password. Database backups are just a mouse click away as well.Those who desire to explore their databases and also change them may use the phpMyAdmin and phpPgAdmin tools.

We’ve developed the manual database backup formation into a very simple task. To execute that: inside of the Database Manager, click the ’clock’ symbol beside the database that you intend to back up and after that wait for a couple of seconds for the process to take place. Depending upon the size of the database, the generation of the back–up file will take between a few seconds and a minute.

You may make as many backup copies per database as you would like. We haven’t set any limits for the number of databases you can back up too.

Nearly all of JDL-Erie’s Linux shared packages packages provide PgSQL support. While falling behind MySQL in terms of reputation and utilization, PgSQL databases are renowned for providing the highest level of safety for your site content and articles. That is the reason why brands like Skype and Yahoo use PgSQL databases as an alternative to MySQL.

In terms of database management, PgSQL is identically straightforward as MySQL.

We have set up InnoDB – the brand new standard MySQL database engine on every one of our servers. InnoDB is great for massive database sites which require high efficiency and scalability. Tests demonstrate that web sites working with InnoDB based tables reach a 3–fold general performance boost for big joins, as opposed to those using MyISAM tables.

InnoDB employs row–level locking in an effort to remove the effectiveness issues found at the peak usage times of the earlier release of the database engine – MyISAM, which utilizes table–level locking.

We provide you a fairly easy solution to keep an eye on the database consumption of your dynamic web sites. From your in depth database stats interface, that is included in the Web Control Panel, you’ll be able to record the load generated from your busy sites in real time. The delivered information will help you to evaluate the database load variations per hour, every day or monthly.

You are able to observe the database load for all of your websites in the Database Stats portion of the Web Control Panel. The table onscreen reveals the database lookups generated within the present month. To have a look at data for an earlier month, simply click on the back arrows situated at the top.