Databases Manager

Overseeing your databases is much easier than ever, as a result of Hosting Control Panel user interface for MySQL and PgSQL administration! Assuming you do not have detailed experience in making use of databases, it will be very easy to work with the Databases Manager.

You may create a brand new database by just typing the user name and security password or produce a database backup with just a mouse click. Furthermore, through the Data Manager you’ll possess direct access to the administrator area for each and every database, so you’re able to effortlessly alter it.

From the Databases Manager it’s easy to create an archived duplicate of your database when you would like! For this reason, you are going to always have a data backup of your operating content in the event your website gets broken into or you mistakenly remove a database. To generate a back–up: click the ’clock’ symbol on the side of a given database and then wait for a couple of seconds for the backup process to be concluded.

There won’t be any boundaries for the amount of databases you can back up or the volume of backups you can create for a database.

You’ll find PgSQL support in every one of our web hosting plans packages. PgSQL databases aren’t as well–known and widely used as MySQL, nevertheless they deliver the maximum level of stability for your site content and articles. Therefore, a number of popular companies such as Skype and Yahoo work with PgSQL databases. Controlling PgSQL databases is as elementary as MySQL, as a result of the user–friendly user interface of the Databases Manager.

PgSQL databases are incorporated by default inside the most innovative web hosting bundles. For the regular packages, they are suggested as upgrades.

We’ve incorporated InnoDB – the brand new default MySQL database engine on every one of our machines. InnoDB is good for significant database websites that need high levels of effectiveness and scalability. Experiments have shown that websites employing InnoDB based tables achieve a 3–fold effectiveness increase for large joins, as compared with those applying MyISAM tables.

InnoDB employs row–level locking so as to take away the functionality issues observed at the high usage times of the prior variant of the database engine – MyISAM, which employs table–level locking.

SUNPROGRAMMER offers you a pretty simple option to track the database consumption on your busy sites. From your detailed database stats user interface, that’s built into the Hosting Control Panel, you’re able to observe the load generated through your busy web sites in real time. The offered info will let you analyze the database load fluctuations by the hour, daily or monthly.

You are able to monitor the database load for all your web sites through the Database Stats portion of the Hosting Control Panel. The table onscreen presents the database lookups created within the present month. To examine information for a past month, simply click on the back arrows located at the top.