Databases Manager

The Databases Manager within our Website Control Panel features a robust yet easy to navigate user interface. It’s possible to configure a whole new MySQL or PostgreSQL database by just typing in a user name and password. Also, you can create a backup file or change the password of the database with only a click of the mouse.

Via the Databases Manager you will have immediate access to the admin area for every one of your databases, so you’re able to make simple alterations should you need to.

Assuming you have worked with databases, you are aware that generating a manual database backup is not a basic task. In order to change this, we have made an easy to understand tool that will back up your entire database with only one click. The back–up file shall be prepared for you in less than a minute, depending upon the size of the selected database.

There aren’t any limitations on just how many backups you may make for a chosen database.

PgSQL databases are much less widespread compared to the well–known MySQL databases. Nonetheless, they represent a favored selection for web developers who seek the greatest protection for their sites and web applications. Via the incredibly user–friendly Databases Manager integrated into the Hostbot Control Panel, you can control your PostgreSQL databases with only a mouse click.

You are going to find PgSQL databases included automatically inside of the advanced Linux website hosting packages. In case you are using a standard hosting package, it is possible to ask for PgSQL databases to be added in your web hosting account as upgrades.

The MySQL databases on our servers use the most current version of the InnoDB storage engine. InnoDB has been meant to guarantee the top functionality for sites that operate with huge volumes of data. It provides CPU effectiveness that could not be matched up by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and provides total transaction support, meaning that you’re able to update/insert/create/alter/drop several times for a single "operation" of your app. Also, it utilizes row–level locking in place of MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

Hostbot offers you a very easy technique to keep track of the database usage for your dynamic websites. Through the thorough database stats user interface, that’s integrated into the Website Control Panel, you’re able to observe the load created by your busy sites in real time. The delivered data will assist you to analyze the database load fluctuations by the hour, every day or monthly.

You’re able to keep an eye on the database load for your sites within the Database Stats part of the Website Control Panel. The table on–screen features the database queries generated in the present month. To take a look at information and facts for an earlier month, all you have to do is click on the back arrows positioned at the top.