Databases Manager

Supervising your databases is less complicated than before, thanks to the Web Hosting Control Panel user interface for MySQL and PgSQL administration! Provided you do not have thorough experience of utilizing databases, it will be simple to manage the Databases Manager.

You can make a brand new database just by keying in the user name and password or create a database back–up with a simple mouse click. Likewise, from the Data Manager you’ll possess direct access to the admin area for each individual database, so you’re able to almost instantly manage it.

We have made the manual database back–up formation into a very simple job. To do this: inside the Databases Manager, click on the ’clock’ icon beside the database that you intend to back up and then wait around for a couple of seconds for the backup process to take place. Depending upon the size of your database, the building of a backup file is going to take between a couple of seconds and a minute.

You may make as many back–ups per database as you would like. We have not specified any confines on the number of databases that you could back up as well.

PgSQL databases are significantly less popular than the standard MySQL databases. On the other hand, they’re a favored alternative for web developers who seek the best security for their websites and apps. Thanks to the user–friendly Databases Manager incorporated into the TulipHost Control Panel, you can manage all your PostgreSQL databases with just a click of the mouse.

Yow will discover PgSQL databases included automatically in the top shared web hosting packages. Provided that you are with a basic hosting package, it is possible to ask for PgSQL databases to be included in your account as upgrades.

The MySQL databases on our machines use the most current release of the InnoDB storage engine. InnoDB is created to ensure the highest efficiency for sites that work with large amounts of data. It provides CPU effectiveness that can not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies full transaction support, meaning you can update/insert/create/alter/drop a couple of times for a single "operation" of your app. Also, it takes advantage of row–level locking as an alternative for MyISAM’s table–level locking, that boosts multi–user concurrency and efficiency.

Monitoring the load caused by the databases within your powerful website assists you to prevent any kind of overload problems that could slow it down and ward off site visitors. For this purpose, we’ve integrated a detailed Database Stats tool directly into the Web Hosting Control Panel. There you can see all–encompassing info on the inbound requests to your databases for each and every hour, day and month.

In line with the amount of daily and per hour queries, it will be easy to determine which databases are employed the most and then take steps to enhance their work.