Databases Manager

The Databases Manager inside our Web Control Panel boasts an effective nevertheless user friendly user interface. You’re able to set up a new MySQL or PostgreSQL database by just typing in a user name and security password. Additionally, you may create a back–up file or modify the password of any database with a click of the mouse.

Through the Databases Manager you will get immediate access to the administrator area for all your databases, which means you can make hassle–free modifications in the event you need to.

Assuming you have dealt with databases, you are aware that generating a manual database backup is not really an elementary job. As a way to change this, we have developed an effortless to use tool that will back up your complete database with merely a single mouse click. The back–up file will be completely ready for you in less than a minute, depending upon the size of the selected database.

There won’t be any restrictions on the number of copies you can create for a chosen database.

PgSQL databases are less widespread compared to the popular MySQL databases. Even so, they represent a preferred choice for web developers seeking the greatest safety for their websites and web apps. Through the easy–to–use Databases Manager included in the HostPlum Hosting Control Panel, you can administer all of your PostgreSQL databases with merely a click of the mouse.

You’ll find PgSQL databases incorporated by default inside the top Linux cloud website hosting packages. Assuming that you are with a basic hosting package, you’re able to ask for PgSQL databases to be added to your account as upgrades.

The MySQL databases on our servers work with the most up–to–date build of the InnoDB storage engine. InnoDB has been created to ensure the optimum performance for web sites that operate with substantial amounts of data. It boasts CPU performance that can not be matched by other disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, so that it is possible to update/insert/create/alter/drop a couple of times for one "operation" of your app. Also, it takes advantage of row–level locking in contrast to MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.

Through the in depth database stats tool built–into the Web Control Panel, you will be able to make a record of the load produced from your dynamic websites at any hour. Every single overload issue with your web sites can reduce the loading speeds and have a bad influence over the online experience of your respective visitors. Thus, having information for the database load in real time, you are able to eliminate overload problems at once.

The database data user interface reveals details of the volume of daily, hourly and monthly queries, so you’re able to analyze how the load is distributed over different periods of time.