Databases Manager

The Databases Manager in our Web Control Panel comes with a robust nevertheless user friendly interface. You are able to set up a brand new MySQL or PostgreSQL database by simply typing in a username and security password. What’s more, you can make a backup file or alter the security password of any database with only a mouse click.

Through the Databases Manager you will get immediate access to the administrative area for each of your databases, so its possible to make simple modifications when you have to.

Assuming you have worked with databases, you are aware that making a manual database backup just isn’t a simple job. As a way to change this, we’ve created an effortless to use tool that can back up your whole database with a single click. The back–up file will be completely ready for you in under a minute, with respect to the size of the chosen database.

There aren’t any confines on the actual number of backups you could make for a particular database.

Practically all of Jmarts Hosting’s Linux cloud website hosting service bundles provide PgSQL support. Although falling behind MySQL in terms of level of popularity and usage, PgSQL databases are famous for supplying the maximum level of security for your web site content and articles. That’s the key reason why companies like Skype and Yahoo go with PgSQL databases in lieu of MySQL.

With regard to database management, PgSQL is identically simple and easy as MySQL.

The MySQL databases on Jmarts Hosting’s servers work with the newest release of the InnoDB storage engine. InnoDB has been developed to guarantee the highest possible functionality for web sites that deal with sizeable amounts of data. It offers CPU efficiency that could not be equalled by any other different disk–based relational database engines.

InnoDB is ACID–compliant and gives total transaction support, meaning you’re able to update/insert/create/alter/drop repeatedly for a single "operation" of your web application. In addition, it uses row–level locking as a substitute for MyISAM’s table–level locking, that enhances multi–user concurrency and efficiency.

From your broad database statistics tool built into the Web Control Panel, it’s possible to keep a record of the load produced by your active websites 24 x 365. Any overload issue with your web sites could reduce the loading speeds and have a damaging impact on the overall impression of your respective visitors. Thus, having information for the database load immediately, it will be straightforward to eliminate overload troubles straight away.

The database stats interface displays info of the quantity of daily, hourly and monthly lookups, in order to evaluate the way the load is distributed over various periods of time.