Databases Manager

Database management may sound like a hard task to beginner hosting customers, but with the Databases Manager, it’s in fact relatively easy! To set up a brand new database, you only ought to enter in your username and password. Database backup copies are just a mouse click away too.People that desire to look into their databases and also modify them can use the phpMyAdmin and phpPgAdmin tools.

Via the Databases Manager you can easily make an archived duplicate of your database when you would like! This way, you will always have a back–up of your operating content if your web site gets hacked or if you accidentally remove a database. To generate a backup: click on the ’clock’ image alongside a given database and afterwards just wait for a few seconds for the backup process to be concluded.

There won’t be any restrictions on the amount of databases you would be able to back up or the amount of backups you can create for a database.

Almost all of the Linux shared website hosting service packages provide PgSQL support. Whilst falling behind MySQL in terms of popularity and usage, PgSQL databases are renowned for offering the greatest level of security for your website content and articles. That’s the primary reason why companies such as Skype and Yahoo go with PgSQL databases as opposed to MySQL.

With regards to database administration, PgSQL is identically effortless to use as MySQL.

We’ve integrated InnoDB – the brand new default MySQL database engine on all our web servers. InnoDB is great for sizeable database web sites that require high general performance and scalability. Trials have established that web sites using InnoDB based tables attain a 3–fold operation grow for big joins, compared with those applying MyISAM tables.

InnoDB employs row–level locking in an effort to eliminate the overall performance problems spotted at the maximum consumption times of the previous version of the database engine – MyISAM, which employs table–level locking.

hostmm offers you a fairly easy solution to monitor the database use for your powerful sites. Via the in–depth database stats user interface, which is included in the Online Control Panel, you’ll be able to monitor the load made by your active sites in real time. The provided info will help you analyze the database load variations each hour, every day or per month.

You’re able to record the database load for all your websites within the Database Stats area of the Online Control Panel. The table on–screen reveals the database lookups made in the present month. To take a look at details for a past month, just click on the back arrows placed at the top.