Databases Manager

Supervising your databases is much simpler than ever, as a result of Web Hosting Control Panel interface for MySQL and PgSQL management! Even though you may not have considerable knowledge in utilizing databases, it will be effortless to work with WindsorWebHosting.net’s Databases Manager.

You may create a whole new database just by entering the username and security password or create a database back–up with a simple mouse click. At the same time, through the Data Manager you will get direct access to the admin area for each and every database, allowing you to quickly edit it.

We have transformed the manual database backup formation into a very easy activity. To execute this: inside the Databases Manager, click on the ’clock’ symbol on the side of the database that you want to back up and after that wait around for a few seconds for the backup process to take place. With respect to the size of your database, the generation of the backup file will need somewhere between a couple of seconds and a minute.

You may make as many backup copies per database as you would like. We haven’t determined any boundaries for the quantity of databases that you could back up too.

Just about all of WindsorWebHosting.net’s Linux cloud hosting packages deliver PgSQL support. Whilst falling behind MySQL when it comes to level of popularity and utilization, PgSQL databases are renowned for offering the greatest level of stability for your website content material. This is the main reason why brands like Skype and Yahoo rely on PgSQL databases as a substitute for MySQL.

In relation to database administration, PgSQL is just as effortless to use as MySQL.

The MySQL databases on WindsorWebHosting.net’s servers make use of the latest version of the InnoDB storage engine. InnoDB was meant to ensure the max efficiency for web sites that deal with substantial amounts of data. It offers CPU performance that could not be matched up by alternative disk–based relational database engines.

InnoDB is ACID–compliant and gives full transaction support, which means you’ll be able to update/insert/create/alter/drop repeatedly for a single "operation" of your web app. Moreover, it utilizes row–level locking as an alternative for MyISAM’s table–level locking, that enhances multi–user concurrency and functionality.

With the in–depth database statistics tool built–into the Web Hosting Control Panel, you are able to keep track of the stress generated through your dynamic websites 24 x 365. Virtually any overload trouble with your websites could slow the loading rates and have a negative impact on the overall experience of your visitors. Thus, by having details for the database load instantly, it will be easy to fix overload difficulties as fast as possible.

The database stats user interface shows data of the amount of daily, hourly and monthly lookups, meaning you can examine the way the load is allocated over different periods of time.