Database Manager

Managing your databases is much simpler than in the past, thanks to the Online Control Panel interface for MySQL and PgSQL administration! Even if you do not have in depth knowledge of utilizing databases, you will find it very easy to handle Hosting Para Emprendedores’s Database Manager.

You may create a new database by merely keying in the user name and security password or make a database back–up with only a click of the mouse. At the same time, through the Data Manager you will possess direct access to the administrative area for every single database, allowing you to conveniently update it.

We have transformed the manual database backup generation into a very easy activity. To execute this: inside of the Database Manager, click on the ’clock’ image next to the database that you want to back up and then hang on for a couple of seconds for the backup process to take place. With regards to the size of your database, the building of a backup file will require between a couple of seconds and a minute.

You can create as many backup copies per database as you would like. We have not determined any confines on the volume of databases you can back up as well.

You will find PgSQL support in our cloud web hosting services plans. PgSQL databases might not be as sought after and widespread as MySQL, nevertheless they supply the maximum level of stability for your website content and articles. Because of this, a number of well–known companies like Skype and Yahoo utilize PgSQL databases. Controlling PgSQL databases is as simple and easy as MySQL, on account of the user–friendly user interface of the Database Manager.

PgSQL databases are integrated by default with the most advanced web hosting bundles. For the normal packages, they are included as upgrades.

The MySQL databases on Hosting Para Emprendedores’s servers employ the newest release of the InnoDB storage engine. InnoDB has been designed to guarantee the highest efficiency for web sites that operate with sizeable volumes of data. It features CPU effectiveness that could not be matched by other different disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, which means you’re able to update/insert/create/alter/drop more than once for a single "operation" of your app. Moreover, it uses row–level locking as a substitute for MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.

Keeping track of the load accumulated by the databases for your busy website assists you to prevent all overload issues that could slow it down and ward off website visitors. For this specific purpose, we have integrated a comprehensive Database Stats tool within the Online Control Panel. There you can get extensive information on the arriving requests to your databases for each and every hour, day and month.

Based on the number of day–to–day and by the hour queries, it’s possible to find out what databases are employed the most as well as consider actions to enhance their load.