Databases Manager

Taking control of your databases is less complicated than before, because of the Control Panel user interface for MySQL and PgSQL management! Even if you do not have substantial knowledge of dealing with databases, you will find it simple to deal with the Databases Manager.

You may create a brand new database just by entering the username and password or make a database back–up with merely a click of the mouse. Furthermore, from the Data Manager you have direct access to the management area for each database, which means you can instantly manage it.

Within the Databases Manager it’s easy to produce an archived copy of your database whenever you desire! Thus, you will always have a back–up of your dynamic content in the event your site gets hacked or you mistakenly get rid of a database. To generate a back–up: click on the ’clock’ image alongside any database and after that just wait for a few seconds for the backup process to be finished.

There are no boundaries on the number of databases you can back up or the amount of backup copies you can make for a database.

PgSQL databases are much less famous as compared to the popular MySQL databases. Nonetheless, they’re a preferred selection for designers seeking the finest protection for their sites and applications. Thanks to the user–friendly Databases Manager built–into the Traffic.bz Web Hosting Domain Names Control Panel, you can manage all of your PostgreSQL databases with a mouse click.

You’ll find PgSQL databases bundled by default in the advanced Linux shared hosting plans packages. In case you are with a standard hosting package, you can request PgSQL databases to be included in your cloud hosting account as upgrades.

We’ve incorporated InnoDB – the new default MySQL database engine on all our machines. InnoDB is good for substantial database websites that demand high levels of effectiveness and scalability. Trials have indicated that sites using InnoDB based tables achieve a 3–fold overall performance increase for massive joins, in contrast to those applying MyISAM tables.

InnoDB takes advantage of row–level locking as a way to eliminate the performance problems seen at the maximum consumption times of the prior variant of the database engine – MyISAM, which utilizes table–level locking.

We offer you a hassle–free approach to keep an eye on the database use on your active web sites. From your in–depth database statistics interface, which is built into the Control Panel, you’re able to keep track of the load created through your dynamic sites in real time. The provided info will enable you to assess the database load fluctuations every hour, per day or monthly.

You can record the database load for all of your web sites in the Database Stats portion of the Control Panel. The table on–screen reveals the database lookups accumulated in the present month. To inspect data for a past month, click on the back arrows located at the top.