Database Manager

Administering your databases now is easier than in the past, due to the Website Control Panel interface for MySQL and PgSQL control! Provided you do not have detailed knowledge of dealing with databases, you will find it effortless to handle our Database Manager.

You may create a completely new database merely by typing the username and password or make a database back–up with simply a click of the mouse. Likewise, from the Data Manager you’ll possess direct access to the admin area for each individual database, meaning you can effectively revise it.

We’ve transformed the manual database back–up formation into a quite simple task. To execute this: inside the Database Manager, click on the ’clock’ icon beside the database that you intend to back up and then hang on for a couple of seconds for the backup process to take place. With respect to the size of your database, the creation of any back–up file can take somewhere between a few seconds and a minute.

You may create as many backups per database as you wish. We have not set any restrictions about the quantity of databases you could back up as well.

PgSQL databases are less famous as compared to the popular MySQL databases. Even so, they represent a favored selection for programmers who are looking for the utmost security for their sites and apps. Because of the incredibly user–friendly Database Manager incorporated into the Net Hosting - Lowest Cost High Quality Hosting Solutions Control Panel, you can administer your PostgreSQL databases with a simple mouse click.

You will find PgSQL databases included by default within the advanced Linux website hosting packages. In case you are with a regular hosting package, you can easily request PgSQL databases to be added to your account as upgrades.

We’ve added InnoDB – the new default MySQL database engine on all of our servers. InnoDB is great for sizeable database web sites which require high levels of efficiency and scalability. Experiments have demonstrated that websites applying InnoDB based tables attain a 3–fold general performance boost for significant joins, when compared with those utilizing MyISAM tables.

InnoDB utilizes row–level locking in order to remove the effectiveness issues discovered at the high usage times of the previous version of the database engine – MyISAM, which employs table–level locking.

Through the complete database stats tool included in the Website Control Panel, you’re going to be able to keep tabs of the stress produced through your busy sites twenty–four hours a day. Any overload problem with your web sites could slow the loading rates and have a damaging effect on the overall experience of your respective website visitors. Thus, having details for the database work instantly, it will be possible to mend overload difficulties right away.

The database stats user interface displays info of the quantity of daily, hourly and monthly lookups, so you’re able to evaluate the way the load is spread over different time periods.