Database Manager

Database management may seem like a difficult task to inexperienced hosting customers, nevertheless with S Web Host’s Database Manager, it’s in fact pretty simple! To create a whole new database, you just have to key in your username and password. Database backup copies are only a mouse click away on top of that.People who choose to examine their databases and also update them are able to use the phpMyAdmin and phpPgAdmin tools.

We have developed the manual database backup creation into a quite simple job. To do this: within the Database Manager, click the ’clock’ icon next to the database that you would like to back up and then wait around for a couple of seconds for the backup process to take place. Depending on the size of your database, the creation of any back–up file will take between a couple of seconds and a minute.

You can make as many backups per database as you wish. We haven’t fixed any limits about the volume of databases that you can back up too.

You’ll find PgSQL support in all our shared plans packages. PgSQL databases are not as sought after and commonly used as MySQL, nevertheless they deliver the highest possible level of security for your website content and articles. Due to this, a lot of popular brands like Skype and Yahoo apply PgSQL databases. Maintaining PgSQL databases is as easy as MySQL, due to the incredibly user–friendly user interface of the Database Manager.

PgSQL databases are provided automatically within the most advanced web hosting plans. For the basic packages, they are included as upgrades.

The MySQL databases on S Web Host’s web servers use the most recent release of the InnoDB storage engine. InnoDB has been built to guarantee the maximum functionality for websites that operate with sizeable volumes of data. It provides CPU effectiveness that can not be matched by any other disk–based relational database engines.

InnoDB is ACID–compliant and offers 100% transaction support, which means you can easily update/insert/create/alter/drop more than once for a single "operation" of your app. Also, it makes use of row–level locking in place of MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

With the all–encompassing database stats tool built into the Site Control Panel, you will be able to keep tabs of the stress produced from your active sites 24 x 365. Virtually any overload issue with your sites can slow the loading speeds and have a bad impact on the online experience of your website visitors. Therefore, having information about the database work immediately, you’ll be able to solve overload troubles as soon as possible.

The database data user interface displays information of the number of daily, hourly and monthly lookups, in order to evaluate how the load is distributed over different periods of time.