Databases Manager

Database management might sound like a difficult task to newbie web hosting customers, nevertheless with Hostaro.com’s Databases Manager, it’s in fact pretty simple! To make a completely new database, you only have to enter in the username and password. Database backups are a click away at the same time.People that wish to look into their databases as well as update them are able to use the phpMyAdmin and phpPgAdmin tools.

We have designed the manual database backup formation into a quite simple activity. To do so: inside the Databases Manager, click the ’clock’ icon next to the database that you would like to back up and afterwards wait for a few seconds for the backup process to take place. Depending upon the size of your database, the generation of a back–up file is going to take between a couple of seconds and a minute.

You can make as many backups of a database as you would like. We haven’t set any restrictions about the number of databases you can back up either.

PgSQL databases are much less widespread as compared to the well–known MySQL databases. Even so, they are a preferred alternative for web developers who seek the maximum safety for their websites and applications. Due to the easy–to–use Databases Manager included in the Hostaro.com Control Panel, you can administer all your PostgreSQL databases with just a mouse click.

You are going to find PgSQL databases bundled by default inside the advanced cloud hosting plans packages. Assuming that you are using a regular 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 our servers work with the most up–to–date version of the InnoDB storage engine. InnoDB was meant to ensure the maximum effectiveness for websites that deal with large volumes of data. It delivers CPU effectiveness that can not be matched by any other disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, which means you’ll be able to update/insert/create/alter/drop many times for a single "operation" of your app. Moreover, it makes use of row–level locking rather than MyISAM’s table–level locking, that enhances multi–user concurrency and performance.

Tracking the load accumulated by the databases in your powerful site will let you avoid any kind of overload difficulties that can slow it down and ward off site visitors. For this reason, we’ve incorporated a thorough Database Stats tool within the Web Site Control Panel. There you can see extensive information regarding the incoming requests to your databases for every single hour, day and month.

In line with the quantity of day–to–day and by the hour queries, it will be straightforward to find out what databases are being used the most and then consider steps to optimize their work.