While in the Sites2Web - Website Hosting Web Site Control Panel you’ll find a feature–rich, easy to navigate Databases Manager! Utilize it in order to get total control of your databases. It is easy to efficiently configure new MySQL and PgSQL databases and supervise them with the phpMyAdmin and phpPgAdmin software programs, respectively.
Clean and Simple User interface
Maintain all of your databases from one location
The Databases Manager in our Web Site Control Panel includes a refined but still simplified user interface. You are able to set up a new MySQL or PostgreSQL database by just entering a username and security password. Also, you can create a back–up file or modify the security password of any database with just a mouse click.
From the Databases Manager you’ve got direct access to the administrator area for every one of your databases, allowing you to make convenient changes if you happen to have to.
Easy Database Back up
Back up your databases in a moment
We have changed the manual database backup creation into a quite easy job. To execute this: in the Databases Manager, click on the ’clock’ icon near the database that you would like to back up and after that wait for a couple of seconds for the backup process to take place. Depending upon the size of the database, the building of any back–up file is going to take somewhere between a couple of seconds and a minute.
You can create as many backup copies per database as you wish. We’ve not set any limitations for the volume of databases that you can back up either.
By far the most secure open source databases
A lot of Sites2Web - Website Hosting’s Linux cloud web hosting packages offer PgSQL support. Whilst falling behind MySQL with respect to popularity and application, PgSQL databases are renowned for providing the greatest level of security for your site content. It is the key reason why companies such as Skype and Yahoo rely upon PgSQL databases instead of MySQL.
In terms of database management, PgSQL is as easy to use as MySQL.
The fresh face of MySQL
With Sites2Web - Website Hosting, you shall always find the most current release of MySQL along with the default MySQL storage engine – InnoDB, mounted.
InnoDB is much more secure in comparison to the past storage engine’s version – MyISAM. It is ACID–compliant and, most importantly – it offers complete transaction support. In addition, it works by using row–level locking, in contrast to MyISAM’s table–level locking, that would always cause functionality troubles at high usage times.
Detailed Database Stats
Comprehensive stats for all your databases
From your comprehensive database statistics tool built–into the Web Site Control Panel, it is possible to make a record of the stress generated through your busy sites 24 hour a day. Every overload trouble with your sites could lower the loading speeds and have a negative effect on the overall impression of your respective site visitors. So, by having details about the database work immediately, it will be possible to mend overload difficulties quickly.
The database data interface displays data of the amount of daily, hourly and monthly queries, so you can evaluate the way the load is spread over different time periods.