From within the Database Manager built into the Web Site Control Panel, it is also possible to set–up new MySQL and PgSQL databases in an instant! Furthermore, you’ll possess immediate access to the administration area software tools (phpMyAdmin and phpPgAdmin, respectively), so that you can conveniently edit the database you want.
An Easy to navigate Interface
The simplest database control user interface
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.
Easy Database Backup
Back up your databases in a moment
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.
By far the most secure open source databases
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 new face of 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.
Detailed Database Stats
Detailed statistics for your databases
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.