Databases Manager

Supervising your databases now is easier than in the past, thanks to the Web Site Control Panel user interface for MySQL and PgSQL management! Assuming you do not have substantial experience of making use of databases, it will be very easy to work with the Databases Manager.

You may create a completely new database by merely entering the username and security password or produce a database back–up with just a click of the mouse. Also, within the Data Manager you will have direct access to the admin area for each individual database, so its possible to instantly update it.

Within the Databases Manager you are able to create an archived copy of your database anytime you wish! That way, you will always have a back–up of your operating information in case your website gets compromised or if you accidentally remove a database. To create a backup: click on the ’clock’ symbol beside a particular database and afterwards simply wait for a few seconds for the backup process to be concluded.

There aren’t any confines for the volume of databases you can back up or the quantity of backup copies you can make for a database.

PgSQL databases are much less common when compared to the common MySQL databases. On the other hand, they represent a preferred selection for developers seeking the utmost protection for their web sites and applications. Through the intuitive Databases Manager included in the Technofree Technology Control Panel, you can administer all your PostgreSQL databases with simply a mouse click.

Yow will discover PgSQL databases provided by default inside of the top cloud web hosting packages. If you are with a regular hosting package, you are able to ask for PgSQL databases to be added in your web hosting account as upgrades.

We’ve installed InnoDB – the brand new default MySQL database engine on every one of our servers. InnoDB is made for big database websites which require high effectiveness and scalability. Experiments have shown that web sites employing InnoDB based tables attain a 3–fold effectiveness boost for substantial joins, in comparison to those applying MyISAM tables.

InnoDB works by using row–level locking in an effort to clear away the general performance issues seen at the high consumption times of the prior variant of the database engine – MyISAM, which uses table–level locking.

We offer you a quick way for you to keep track of the database utilization of your dynamic web sites. From the in–depth database stats interface, that’s built into the Web Site Control Panel, it is possible to track the load created through your active web sites in real time. The offered details will enable you to assess the database load changes every hour, per day or on a monthly basis.

It’s possible to record the database load for all your web sites from the Database Stats area of the Web Site Control Panel. The table on–screen presents the database lookups accumulated in the present month. To take a look at information and facts for a past month, simply click on the back arrows situated at the top.