Database Manager

Database management might sound like a hard task to unskilled website hosting users, but with SPT Web Hosting’s Database Manager, it’s actually pretty simple! To set up a whole new database, you just ought to enter in the username and password. Database back–ups are simply a click away too.People that need to explore their databases and then revise them are able to use the phpMyAdmin and phpPgAdmin tools.

We’ve made the manual database back–up creation into a quite easy activity. To do so: within the Database Manager, click the ’clock’ icon near the database that you intend to back up and then wait around for a few seconds for the backup process to take place. With respect to the size of your database, the building of the back–up file will require between a few seconds and a minute.

You can make as many back–ups per database as you wish. We haven’t fixed any restrictions about the quantity of databases you could back up as well.

Practically all of SPT Web Hosting’s Linux cloud hosting packages bundles feature PgSQL support. While dropping behind MySQL with regards to global recognition and usage, PgSQL databases are renowned for presenting the greatest level of stability for your site content material. It is the basic reason why companies such as Skype and Yahoo rely upon PgSQL databases rather than MySQL.

When considering database administration, PgSQL is just as easy to use as MySQL.

The MySQL databases on SPT Web Hosting’s web servers employ the most recent build of the InnoDB storage engine. InnoDB has been designed to ensure the highest possible performance for sites that work with substantial volumes of data. It boasts CPU effectiveness that can not be matched up by any other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies full transaction support, meaning that it is possible to update/insert/create/alter/drop many times for a single "operation" of your application. Furthermore, it makes use of row–level locking in contrast to MyISAM’s table–level locking, that raises multi–user concurrency and efficiency.

SPT Web Hosting offers you a pretty simple way to keep track of the database use on your dynamic websites. Via the in–depth database statistics interface, that is incorporated into the Web Site Control Panel, you can easily monitor the load created through your active web sites in real time. The displayed details will help you to analyze the database load changes by the hour, every day or monthly.

You can monitor the database load for your web sites in the Database Stats section of the Web Site Control Panel. The table on–screen features the database queries accumulated within the present month. To assess information for a previous month, simply click on the back arrows positioned at the top.