Database Manager

Administering your databases is less complicated than ever, as a result of Online Control Panel interface for MySQL and PgSQL administration! Assuming you do not have considerable knowledge of handling databases, it will be simple to manage the Database Manager.

You could make a completely new database simply by keying in the username and password or generate a database backup with a mouse click. Likewise, from the Data Manager you will get direct access to the administration area for each individual database, so that you can quickly update it.

We’ve made the manual database back–up generation into a quite simple activity. To execute that: in the Database Manager, click on the ’clock’ icon on the side of the database that you would like to back up and then wait around for a few seconds for the process to take place. Depending upon the size of your database, the building of a backup file can take between a couple of seconds and a minute.

You can create as many backups per database as you want. We haven’t fixed any limitations about the volume of databases that you could back up as well.

PgSQL databases are significantly less popular than the widespread MySQL databases. Then again, they represent a favored option for programmers who are looking for the greatest stability for their websites and web apps. Due to the intuitive Database Manager built into the 3X Hosting Control Panel, you can control all your PostgreSQL databases with merely a click of the mouse.

You can discover PgSQL databases bundled automatically inside of the advanced web hosting packages. Assuming that you are using a basic hosting package, it is easy to ask for PgSQL databases to be included in your web hosting account as upgrades.

We’ve installed InnoDB – the brand new standard MySQL database engine on each of our servers. InnoDB is good for huge database web sites which require high functionality and scalability. Trials have demonstrated that web sites making use of InnoDB based tables achieve a 3–fold efficiency boost for very big joins, when compared with those utilizing MyISAM tables.

InnoDB takes advantage of row–level locking as a way to clear away the functionality difficulties noticed at the top consumption times of the earlier variant of the database engine – MyISAM, which uses table–level locking.

We supply you a simple solution to keep tabs on the database usage of your busy websites. Through the detailed database statistics user interface, that is included in the Online Control Panel, you are able to observe the load generated from your active sites in real time. The supplied info will enable you to assess the database load variations each hour, each day or each month.

You are able to keep an eye on the database load for all of your websites from the Database Stats section of the Online Control Panel. The table onscreen features the database lookups made in the present month. To inspect details for an earlier month, simply click on the back arrows positioned at the top.