Databases Manager

Administering your databases is easier than ever, due to the Web Control Panel user interface for MySQL and PgSQL control! In case you do not have thorough experience in handling databases, it will be effortless to use our Databases Manager.

You can create a whole new database by simply specifying the username and password or produce a database back–up with a simple click of the mouse. At the same time, within the Data Manager you have direct access to the management area for every single database, which means you can almost instantly modify it.

We’ve evolved the manual database back–up creation into a quite easy activity. To execute this: within the Databases Manager, click on the ’clock’ icon beside the database that you plan to back up and after that wait for a few seconds for the backup process to take place. Depending upon the size of the database, the creation of a back–up file will need somewhere between a couple of seconds and a minute.

You can make as many backup copies of a database as you wish. We have not specified any limits for the volume of databases that you could back up either.

Almost all of Unilakes Cloud’s Linux web hosting bundles grant PgSQL support. While dropping behind MySQL regarding level of popularity and employment, PgSQL databases are famous for giving the highest level of protection for your site content. This is the key reason why companies such as Skype and Yahoo rely on PgSQL databases as a substitute for MySQL.

With regard to database management, PgSQL is as uncomplicated as MySQL.

The MySQL databases on Unilakes Cloud’s web servers utilize the most recent release of the InnoDB storage engine. InnoDB was built to ensure the top efficiency for web sites that process massive amounts of data. It presents CPU efficiency that can not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies total transaction support, meaning that you’re able to update/insert/create/alter/drop more than once for a single "operation" of your application. Furthermore, it uses row–level locking instead of MyISAM’s table–level locking, that increases multi–user concurrency and effectiveness.

From the in depth database stats tool integrated into the Web Control Panel, you are able to keep a record of the stress produced by your dynamic sites 24 hour a day. Every overload difficulty with your sites can lower the loading rates and have a bad influence over the overall impression of your website visitors. Hence, having info about the database work right away, you’ll be able to mend overload issues right away.

The database data interface shows information of the quantity of daily, hourly and monthly lookups, to help you to assess the way the load is allocated over several periods of time.