Database Manager

Database management may sound like a difficult task to new cloud hosting users, however with the Database Manager, it’s actually really simple! To make a whole new database, you only ought to type in your username and password. Database backups are simply a click away as well.People that need to look into their databases and then change them can use the phpMyAdmin and phpPgAdmin tools.

Within the Database Manager it is simple to generate an archived duplicate of your database whenever you wish! This way, you’ll always have a backup of your active content in the event your web site gets hacked or you accidentally eliminate a database. To make a back–up: click the ’clock’ image next to a given database and then wait for a couple of seconds for the backup process to be finalized.

There aren’t any restricts for the number of databases you would be able to back up or the number of backups you can make for a database.

A lot of our Linux shared hosting services bundles offer PgSQL support. Whilst dropping behind MySQL with respect to level of popularity and utilization, PgSQL databases are famous for offering the greatest level of protection for your website content. That’s the main reason why companies such as Skype and Yahoo employ PgSQL databases as an alternative to MySQL.

With respect to database management, PgSQL is equally effortless to use as MySQL.

With klikDCI (Bisnis-IT.com), you’ll always discover the newest version of MySQL along with the default MySQL storage engine – InnoDB, set up.

InnoDB is more stable in comparison to the previous storage engine’s version – MyISAM. It’s ACID–compliant and, most of all – it grants 100% transaction support. It also utilizes row–level locking, in lieu of MyISAM’s table–level locking, that would always result in functionality issues at peak usage periods.

Keeping tabs on the load made by the databases on your busy site will let you reduce all overload troubles that can slow it down and chase away site visitors. As a result, we have bundled a comprehensive Database Stats tool within the Site Control Panel. There you can see complete info about the arriving requests to your databases for every single hour, day and month.

In line with the amount of daily and by the hour queries, you are able to find out which databases are used the most and then consider measures to optimize their work.