Database Manager

Database management may sound like a difficult task to new cloud hosting clients, but with the Database Manager, it’s actually simple! To create a new database, you simply need to type in your username and password. Database back–ups are only a click away also.People who wish to examine their databases and also revise them should use the phpMyAdmin and phpPgAdmin tools.

We have evolved the manual database back–up formation into a quite simple job. To do this: in the Database Manager, click the ’clock’ symbol on the side of the database that you would like to back up and after that hang on for a few seconds for the process to take place. With regards to the size of your database, the generation of the backup file will need between a few seconds and a minute.

You may create as many backups per database as you would like. We have not fixed any limitations on the number of databases that you could back up as well.

PgSQL databases are less common as compared to the common MySQL databases. Then again, they are a favored option for web developers who are looking for the utmost protection for their websites and apps. Through the incredibly user–friendly Database Manager built–into the Mariachi Server Control Panel, you can administer all your PostgreSQL databases with just a mouse click.

You will find PgSQL databases included by default in the advanced Linux shared website hosting packages packages. Assuming that you are using a standard hosting package, you’ll be able to ask for PgSQL databases to be added in your website hosting account as upgrades.

The MySQL databases on Mariachi Server’s machines utilize the most recent version of the InnoDB storage engine. InnoDB is made to ensure the highest possible efficiency for websites that operate with huge volumes of data. It features CPU performance that could not be equalled by any other different disk–based relational database engines.

InnoDB is ACID–compliant and offers full transaction support, meaning you are able to update/insert/create/alter/drop repeatedly for one "operation" of your app. Additionally, it utilizes row–level locking as an alternative for MyISAM’s table–level locking, that enhances multi–user concurrency and performance.

Checking the load generated by the databases in your active site makes it possible to reduce any kind of overload difficulties that could slow it down and chase away visitors. As a result, we have bundled a descriptive Database Stats tool inside the Web Control Panel. There you can get all–encompassing information regarding the incoming requests to your databases for every hour, day and month.

In line with the amount of day–to–day and by the hour queries, it is possible to find out what databases are used the most as well as consider procedures to optimize their work.