Databases Manager

Supervising your databases now is easier than in the past, due to the Website Control Panel interface for MySQL and PgSQL administration! Provided you do not have thorough expertise in dealing with databases, it will be easy to manage Crtvg Hosting’s Databases Manager.

You could make a completely new database simply by typing the user name and password or produce a database back–up with only a mouse click. Furthermore, within the Data Manager you have direct access to the management area for each individual database, so you’re able to quite easily modify it.

In case you have worked with databases, you know that creating a manual database backup is simply not a simple job. In an effort to change this, we’ve developed an effortless to use tool that will back up your entire database with simply one mouse click. The backup file will be available for you in less than a minute, with regards to the size of the chosen database.

You won’t notice any confines on how many backup copies you can create for a specific database.

You’ll find PgSQL support in our Linux website hosting packages offers. PgSQL databases are not as popular and commonly used as MySQL, nevertheless they offer the maximum level of protection for your site content and articles. Therefore, a lot of popular companies like Skype and Yahoo utilize PgSQL databases. Controlling PgSQL databases is as easy as MySQL, on account of the incredibly user–friendly user interface of the Databases Manager.

PgSQL databases are integrated by default inside of the most advanced web hosting plans. For the normal bundles, they are presented as upgrades.

We have set up InnoDB – the new default MySQL database engine on every one of our servers. InnoDB is designed for significant database web sites that require high performance and scalability. Experiments show that websites employing InnoDB based tables achieve a 3–fold functionality increase for very large joins, in contrast to those utilizing MyISAM tables.

InnoDB works by using row–level locking as a way to remove the effectiveness difficulties seen at the maximum usage times of the earlier variant of the database engine – MyISAM, which employs table–level locking.

Keeping track of the load produced by the databases for your powerful web site will let you avoid any overload issues that can slow it down and chase away website visitors. As a result, we’ve incorporated a complete Database Stats tool in the Website Control Panel. There you will find comprehensive information on the inbound requests to your databases for each and every hour, day and month.

Using the quantity of day–to–day and by the hour queries, it is possible to determine which databases are being used the most as well as consider measures to enhance their work.