With the Database Manager included in the Web Site Control Panel, you will be able to build brand new MySQL and PgSQL databases instantly! In addition, you’ve got immediate access to the administrator area software tools (phpMyAdmin and phpPgAdmin, respectively), which enables you to effectively manage the database you want.
Tidy and Simple User interface
Be in charge of all your databases from just one place
The Database Manager in our Web Site Control Panel comes with an effective yet uncomplicated interface. You can set up a completely new MySQL or PostgreSQL database simply by specifying a user name and password. Moreover, you may create a backup file or modify the password of an database with a click of the mouse.
With the Database Manager you will possess immediate access to the administrative area for all your databases, in order to make convenient changes in case you need to.
Swift Database Backup
Back up your databases in a minute
We have transformed the manual database backup formation into a very easy task. To execute this: inside the Database Manager, click the ’clock’ symbol on the side of the database that you intend to back up and then wait for a few seconds for the process to take place. Depending on the size of the database, the generation of any backup file can take between a couple of seconds and a minute.
You may make as many backups per database as you wish. We’ve not set any limits about the amount of databases that you can back up too.
Support for PgSQL
Warranted stability for your databases
PgSQL databases are much less widespread compared to the standard MySQL databases. Having said that, they are a favorite option for designers who are looking for the ultimate stability for their websites and apps. Due to the easy–to–use Database Manager built into the 2SmartHosts Control Panel, you can manage all your PostgreSQL databases with a click of the mouse.
You can find PgSQL databases integrated by default with the best website hosting packages. In case you are with a basic hosting package, you can easily ask for PgSQL databases to be added in your account as upgrades.
The new face of MySQL
The MySQL databases on our web servers work with the most recent version of the InnoDB storage engine. InnoDB is developed to guarantee the top effectiveness for websites that operate with big volumes of data. It boasts CPU performance that could not be equalled by any alternative disk–based relational database engines.
InnoDB is ACID–compliant and provides complete transaction support, which means it is possible to update/insert/create/alter/drop several times for one "operation" of your application. Furthermore, it utilizes row–level locking and not MyISAM’s table–level locking, that enhances multi–user concurrency and efficiency.
Detailed Database Stats
Comprehensive stats for your databases
Checking the load produced by the databases for your busy site assists you to avoid virtually any overload issues that might slow it down and chase away visitors. Therefore, we’ve integrated a comprehensive Database Stats tool within the Web Site Control Panel. There you can see all–inclusive info on the arriving requests to your databases for every hour, day and month.
Depending on the volume of day–to–day and per hour queries, it is possible to find out what databases are employed the most and take actions to optimize their work.