Database Manager

Database management may sound like a difficult task to novice web hosting customers, however with Swishbiz Web Hosting’s Database Manager, it’s actually really simple! To configure a whole new database, you just have to type in the username and password. Database back–ups are just a click away at the same time.People that need to explore their databases and then edit them may use the phpMyAdmin and phpPgAdmin tools.

We’ve made the manual database backup formation into a simple task. To execute that: in the Database Manager, click on the ’clock’ image next to the database that you plan to back up and wait around for a few seconds for the process to take place. With respect to the size of your database, the building of any backup file will require between a couple of seconds and a minute.

You can make as many back–ups of a database as you want. We have not determined any boundaries about the volume of databases that you can back up either.

You will find PgSQL support in all our Linux cloud web hosting offers. PgSQL databases are not as famous and commonly used as MySQL, nonetheless they provide the maximum level of security for your website content and articles. For this reason, a lot of famous companies like Skype and Yahoo apply PgSQL databases. Dealing with PgSQL databases is as simple as MySQL, as a result of the incredibly user–friendly interface of the Database Manager.

PgSQL databases are incorporated automatically within the most innovative web hosting packages. For the normal bundles, they are suggested as upgrades.

We’ve installed InnoDB – the brand new standard MySQL database engine on our servers. InnoDB is perfect for significant database websites that need high performance and scalability. Experiments have demonstrated that sites utilizing InnoDB based tables attain a 3–fold performance boost for significant joins, in comparison to those using MyISAM tables.

InnoDB utilizes row–level locking as a way to eliminate the functionality issues observed at the maximum consumption times of the earlier variant of the database engine – MyISAM, which uses table–level locking.

Checking the load produced by the databases on your powerful web site will let you prevent any kind of overload difficulties that might slow it down and chase away site visitors. As a result, we have built in a in–depth Database Stats tool directly into the Web Site Control Panel. There you can find all–inclusive info about the inbound requests to your databases for every hour, day and month.

In line with the volume of day–to–day and per hour queries, you will be able to determine which databases are utilized the most as well as consider steps to optimize their load.