We grant you a user friendly Database Manager, incorporated within our Online Control Panel, from where you can produce new MySQL and PgSQL databases right away. Also, you are able to control their settings with the immediate access provided to the phpMyAdmin and phpPgAdmin software instruments.
Clean and Simple User interface
Take care of all your databases from within one place
The Database Manager inside the Online Control Panel provides a robust nevertheless simple to use user interface. It is possible to set up a brand new MySQL or PostgreSQL database simply by typing a username and password. What’s more, you could make a backup file or modify the password of any database with merely a click of the mouse.
Within the Database Manager you’ll possess direct access to the management area for each of your databases, so that you can make hassle–free corrections if you happen to need to.
Relatively easy Database Data backup
Guard your database content with just a click
If you have dealt with databases, you already know that generating a manual database backup is not really a simple job. In order to change this, we have developed an effortless to use tool that can back up your complete database with merely a single mouse click. The backup file will be prepared for you in less than a minute, depending upon the size of the selected database.
There are not any limitations on just how many backup copies you can make for any chosen database.
PgSQL Databases Support
Simply the most secure open source databases
You can find PgSQL support in each of our shared website hosting plans plans. PgSQL databases aren’t as well–known and commonly used as MySQL, however they provide the maximum level of security for your website content and articles. Because of this, a number of famous businesses like Skype and Yahoo make use of PgSQL databases. Controlling PgSQL databases is as simple and easy as MySQL, because of the incredibly user–friendly interface of the Database Manager.
PgSQL databases are included by default inside the most innovative web hosting packages. For the regular plans, they’re included as upgrades.
InnoDB Databases
The fresh new face of MySQL
The MySQL databases on SW WebHosting’s web servers use the newest version of the InnoDB storage engine. InnoDB has been created to guarantee the highest effectiveness for websites that work with massive volumes of data. It supplies CPU efficiency that could not be equalled by other different disk–based relational database engines.
InnoDB is ACID–compliant and supplies 100% transaction support, so that it is possible to update/insert/create/alter/drop a couple of times for one "operation" of your web app. Also, it makes use of row–level locking rather than MyISAM’s table–level locking, that enhances multi–user concurrency and effectiveness.
Detailed Database Stats
Precise stats for all of your databases
Tracking the load produced by the databases on your busy web site will help you prevent any sort of overload difficulties that might slow it down and ward off site visitors. For this purpose, we have built–in a complete Database Stats tool inside the Online Control Panel. There you shall find detailed info about the arriving requests to your databases for every single hour, day and month.
Using the amount of daily and by the hour queries, you are able to determine which databases are utilized the most and also consider measures to optimize their load.
