Databases Manager

The Databases Manager within our Web Control Panel contains an effective nevertheless user–friendly user interface. You are able to set up a whole new MySQL or PostgreSQL database simply by entering a username and password. Moreover, you can create a back–up file or modify the security password of any database with a click of the mouse.

With the Databases Manager you’ll get immediate access to the admin area for every one of your databases, meaning you can make effortless adjustments should you need to.

Provided you have worked with databases, you know that generating a manual database backup is just not an elementary job. So as to change this, we’ve developed very simple tool that will back up your complete database with simply a single click. The backup file will be completely ready for you in less than a minute, based on the size of the chosen database.

There won’t be any limitations on how many copies you could make for any particular database.

PgSQL databases are significantly less popular compared to the widespread MySQL databases. Then again, they’re a favored option for web developers seeking the best safety for their web sites and web applications. Because of the incredibly user–friendly Databases Manager included in the Consultores-TIC Control Panel, you can control all your PostgreSQL databases with a simple click of the mouse.

You’re going to find PgSQL databases provided by default inside the advanced cloud hosting packages. Assuming that you are using a standard hosting package, it is easy to request PgSQL databases to be added to your website hosting account as upgrades.

The MySQL databases on our servers use the most up–to–date build of the InnoDB storage engine. InnoDB was meant to guarantee the optimum functionality for web sites that process substantial volumes of data. It delivers CPU efficiency that could not be matched by any other disk–based relational database engines.

InnoDB is ACID–compliant and grants full transaction support, which means that you can easily update/insert/create/alter/drop repeatedly for one "operation" of your app. In addition, it makes use of row–level locking and not MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.

Tracking the load produced by the databases within your powerful website will help you avoid any sort of overload issues that might slow it down and ward off site visitors. For this purpose, we have incorporated a descriptive Database Stats tool inside the Web Control Panel. There you can see complete information regarding the incoming requests to your databases for every single hour, day and month.

In line with the number of daily and by the hour queries, it will be easy to determine which databases are used the most and then take steps to enhance their load.