Database Manager

Database management may seem like a difficult job to unskilled web hosting clients, nevertheless with our Database Manager, it’s actually really simple! To make a new database, you only ought to provide the username and password. Database backups are a click away also.Those who need to examine their databases as well as modify them are able to use the phpMyAdmin and phpPgAdmin tools.

We’ve changed the manual database backup formation into a quite easy job. To execute that: in the Database Manager, click on the ’clock’ image near the database that you would like to back up and hang on for a few seconds for the backup process to take place. With regards to the size of the database, the generation of a back–up file can take somewhere between a few seconds and a minute.

You may create as many backup copies per database as you wish. We have not specified any limitations on the number of databases that you could back up as well.

PgSQL databases are significantly less common as opposed to the common MySQL databases. However, they are a preferred choice for web developers who seek the ultimate protection for their websites and apps. Via the easy–to–use Database Manager built–into the Ion Mod Control Panel, you can control your PostgreSQL databases with only a mouse click.

You’ll find PgSQL databases incorporated by default inside of the advanced cloud website hosting packages. Provided that you are using a basic hosting package, it’s possible to ask for PgSQL databases to be added in your account as upgrades.

The MySQL databases on our web servers utilize the latest build of the InnoDB storage engine. InnoDB is made to ensure the optimum efficiency for sites that work with massive amounts of data. It delivers CPU effectiveness that could not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and grants 100% transaction support, which means that you can update/insert/create/alter/drop many times for one "operation" of your app. Additionally, it makes use of row–level locking rather than MyISAM’s table–level locking, that improves multi–user concurrency and effectiveness.

With the detailed database stats tool built–into the Online Control Panel, you are going to be able to make a record of the load created through your active web sites 24 hour a day. Virtually any overload problem with your websites could lower the loading speeds and have a bad impact on the overall experience of your respective site visitors. Therefore, having details for the database work in real time, you will be able to fix overload problems as soon as possible.

The database statistics user interface shows info of the number of daily, hourly and monthly lookups, allowing you to evaluate the way the load is spread over several time frames.