Database Manager

The Database Manager inside the Web Hosting Control Panel incorporates a refined but convenient–to–use user interface. It’s possible to set up a new MySQL or PostgreSQL database by just entering a user name and password. Additionally, you can make a back–up file or alter the security password of your database with merely a click of the mouse.

From the Database Manager you will get immediate access to the administrator area for each of your databases, which means you can make hassle–free corrections in case you need to.

We’ve transformed the manual database backup formation into a quite simple activity. To do this: in the Database Manager, click on the ’clock’ image near the database that you plan to back up and hang on for a couple of seconds for the backup process to take place. With respect to the size of the database, the creation of any backup file will need somewhere between a couple of seconds and a minute.

You may make as many back–ups per database as you would like. We haven’t determined any confines on the quantity of databases you could back up as well.

Practically all of katarisoft’s cloud hosting plans packages provide PgSQL support. While falling behind MySQL with regards to popularity and usage, PgSQL databases are renowned for delivering the best level of protection for your website content material. That is the primary reason why companies like Skype and Yahoo rely on PgSQL databases instead of MySQL.

In relation to database management, PgSQL is as quick as MySQL.

We have installed InnoDB – the new default MySQL database engine on all of our machines. InnoDB is good for huge database web sites that demand high functionality and scalability. Trials have demonstrated that websites utilizing InnoDB based tables achieve a 3–fold overall performance grow for large joins, in contrast to those utilizing MyISAM tables.

InnoDB works by using row–level locking in order to be able to take away the overall performance issues observed at the top consumption times of the prior variant of the database engine – MyISAM, which uses table–level locking.

Keeping track of the load made by the databases in your busy website assists you to stop any overload troubles that might slow it down and ward off visitors. For this specific purpose, we’ve incorporated a detailed Database Stats tool directly into the Web Hosting Control Panel. There you can see in depth info about the inbound requests to your databases for each and every hour, day and month.

Using the amount of daily and by the hour queries, it will be straightforward to find out which databases are employed the most and consider procedures to optimize their load.