Database Manager

Supervising your databases is less complicated than ever, thanks to the Web Control Panel interface for MySQL and PgSQL control! Even if you do not have thorough expertise in working with databases, it will be an easy task to deal with Cheap Web Space’s Database Manager.

You may create a new database by just typing the username and password or produce a database backup with only a mouse click. Additionally, with the Data Manager you’ll get direct access to the management area for each and every database, so you can effectively update it.

With the Database Manager it’s easy to generate an archived duplicate of your database anytime you need! This way, you will always have a back–up of your dynamic content material in case your site gets hacked or if you mistakenly eliminate a database. To make a back–up: click on the ’clock’ icon on the side of a given database and then simply wait for a few seconds for the backup process to be executed.

There are not any restrictions about the amount of databases you are able to back up or the number of backups you can create for any database.

Practically all of Cheap Web Space’s cloud web hosting bundles offer PgSQL support. Although dropping behind MySQL when considering acceptance and usage, PgSQL databases are renowned for providing the top level of protection for your website content and articles. That’s the key reason why companies like Skype and Yahoo rely on PgSQL databases and not MySQL.

With regard to database administration, PgSQL is equally uncomplicated as MySQL.

With Cheap Web Space, you’ll regularly find the latest release of MySQL plus the default MySQL storage engine – InnoDB, mounted.

InnoDB is definitely more stable than the past storage engine’s edition – MyISAM. It is ACID–compliant and, most importantly – it gives you 100% transaction support. In addition, it utilizes row–level locking, in lieu of MyISAM’s table–level locking, that used to cause effectiveness troubles at peak usage times.

Keeping tabs on the load generated by the databases for your dynamic website will help you stop all kinds of overload difficulties that might slow it down and chase away site visitors. For this reason, we’ve incorporated a thorough Database Stats tool straight into the Web Control Panel. There you can see all–inclusive information regarding the incoming requests to your databases for every hour, day and month.

Depending on the amount of daily and per hour queries, it will be straightforward to find out what databases are utilized the most and also consider actions to enhance their load.