Database Manager

Managing your databases is much simpler than ever before, as a result of Hosting Control Panel interface for MySQL and PgSQL control! Even if you do not have detailed experience of making use of databases, it will be simple to use our Database Manager.

You can make a brand new database by simply typing the user name and password or create a database backup with a simple mouse click. At the same time, within the Data Manager you will have direct access to the administration area for each individual database, so you’re able to effectively manage it.

If you have worked with databases, you are aware that making a manual database back–up just isn’t an elementary task. In order to change this, we have made a simple and easy to use tool that can back up the entire database with just one mouse click. The back–up file will be available for you in less than a minute, based on the size of the chosen database.

You won’t notice any limits on exactly how many copies you can make for any specific database.

PgSQL databases are significantly less common than the well–known MySQL databases. On the other hand, they represent a favored choice for programmers seeking the utmost safety for their websites and web apps. Because of the intuitive Database Manager included in the EXPRESShostings Control Panel, you can control your PostgreSQL databases with simply a click of the mouse.

You can discover PgSQL databases integrated by default in the top Linux shared packages packages. Provided that you are using a regular hosting package, you can easily ask for PgSQL databases to be included in your account as upgrades.

The MySQL databases on EXPRESShostings’s web servers employ the most recent release of the InnoDB storage engine. InnoDB was made to ensure the max effectiveness for sites that process significant amounts of data. It provides CPU performance that can not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and grants full transaction support, meaning you’re able to update/insert/create/alter/drop more than once for one "operation" of your web application. Additionally, it works by using row–level locking in lieu of MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.

We supply you a straightforward method to observe the database usage for your active web sites. From your thorough database stats user interface, that is integrated into the Hosting Control Panel, you’re able to track the load produced by your dynamic sites in real time. The delivered information will enable you to assess the database load fluctuations each hour, per day or per month.

You’re able to observe the database load for your sites from the Database Stats section of the Hosting Control Panel. The table on–screen shows the database lookups created within the present month. To examine data for an earlier month, just click on the back arrows positioned at the top.