We present you with a user–friendly Databases Manager, included in our Web Site Control Panel, from where you could set up brand new MySQL and PgSQL databases in an instant. Furthermore, you are able to manage their configuration settings via the convenient access presented to the phpMyAdmin and phpPgAdmin software instruments.
A Convenient–to–use Interface
Control your databases with a mouse click
Supervising your databases is much easier than ever, on account of the Web Site Control Panel user interface for MySQL and PgSQL control! Even if you do not have considerable experience in handling databases, you will find it effortless to deal with Crenet Hosting’s Databases Manager.
You can make a whole new database by simply entering the username and security password or create a database backup with just a mouse click. At the same time, from the Data Manager you will get direct access to the administration area for each and every database, so its possible to easily modify it.
Instant Database Backup
Back up your databases in a minute
We have transformed the manual database backup creation into a very simple task. To execute that: within the Databases Manager, click on the ’clock’ symbol near the database that you would like to back up and then wait around for a few seconds for the backup process to take place. Depending on the size of your database, the building of any back–up file will take between a few seconds and a minute.
You can make as many back–ups per database as you would like. We’ve not specified any limits about the quantity of databases that you can back up either.
PgSQL Databases Support
The most safe open source databases
You will find PgSQL support in each of our Linux hosting packages packages. PgSQL databases may not be as well–known and widely used as MySQL, nevertheless they provide the best level of security for your site content. Because of this, a number of popular businesses like Skype and Yahoo take advantage of PgSQL databases. Taking care of PgSQL databases is as easy and simple as MySQL, due to the intuitive interface of the Databases Manager.
PgSQL databases are incorporated by default with the most sophisticated web hosting plans. For the regular bundles, they are presented as upgrades.
The newest face of MySQL
We have integrated InnoDB – the new default MySQL database engine on our servers. InnoDB is made for large database websites that require high levels of efficiency and scalability. Tests have indicated that websites making use of InnoDB based tables achieve a 3–fold operation increase for big joins, when compared with those utilizing MyISAM tables.
InnoDB makes use of row–level locking so as to get rid of the operation issues noticed at the top consumption times of the earlier version of the database engine – MyISAM, which utilizes table–level locking.
Detailed Database Stats
Thorough statistics for all of your databases
From the comprehensive database statistics tool built into the Web Site Control Panel, you’re going to be able to keep track of the load created from your busy web sites twenty–four hours a day. Every overload problem with your sites can lower the loading speeds and have a damaging influence over the overall impression of your respective site visitors. Therefore, having data for the database work in real time, it is possible to mend overload problems straight away.
The database stats interface displays data of the number of daily, hourly and monthly queries, so you can assess the way the load is distributed over different time periods.