From the Databases Manager integrated into the Site Control Panel, it’s possible to build new MySQL and PgSQL databases in an instant! At the same time, you’ve got direct access to the management area software programs (phpMyAdmin and phpPgAdmin, respectively), meaning you can instantly revise the database you want.
Tidy and Simple Interface
Handle all of your databases from a single place
The Databases Manager within our Site Control Panel incorporates an effective yet user friendly interface. It is easy to configure a completely new MySQL or PostgreSQL database by simply specifying a user name and password. Moreover, you could make a backup file or alter the password of any database with only a mouse click.
Through the Databases Manager you’ll have immediate access to the admin area for all your databases, so you’re able to make uncomplicated alterations when you have to.
Simple and quick Database Backup
Database backup copies are a click away
With the Databases Manager you are able to produce an archived duplicate of your database when you want! Thus, you will always have a back–up of your active content in case your site gets broken into or if you accidentally delete a database. To produce a back–up: click the ’clock’ image beside a particular database and then simply wait for a couple of seconds for the backup process to be carried out.
There are no restricts about the number of databases you can back up or the volume of back–ups you may make for a database.
PgSQL Support
The most risk–free open source databases
The majority of 121 Webhost’s Linux shared hosting plans offer PgSQL support. While falling behind MySQL with regard to reputation and usage, PgSQL databases are famous for delivering the highest level of security for your site content. It is the main reason why companies such as Skype and Yahoo rely on PgSQL databases rather than MySQL.
In relation to database management, PgSQL is as simple and easy as MySQL.
InnoDB Databases
The new face of MySQL
The MySQL databases on 121 Webhost’s web servers utilize the newest version of the InnoDB storage engine. InnoDB has been made to ensure the highest possible effectiveness for sites that work with large amounts of data. It presents CPU efficiency that can not be equalled by other different disk–based relational database engines.
InnoDB is ACID–compliant and grants 100% transaction support, meaning you can easily update/insert/create/alter/drop more than once for a single "operation" of your web application. Furthermore, it utilizes row–level locking in lieu of MyISAM’s table–level locking, that increases multi–user concurrency and functionality.
Detailed Database Stats
In depth stats for your databases
Monitoring the load made by the databases on your dynamic web site makes it possible to reduce all overload difficulties that could slow it down and chase away website visitors. For that reason, we’ve built in a in–depth Database Stats tool in the Site Control Panel. There you can find detailed information on the inbound requests to your databases for each hour, day and month.
Based on the amount of day–to–day and by the hour queries, it will be straightforward to determine which databases are employed the most as well as consider measures to enhance their load.
