Databases Manager

Overseeing your databases is much simpler than ever, on account of the Web Site Control Panel interface for MySQL and PgSQL administration! In case you do not have detailed experience in dealing with databases, you will find it an easy task to use 1stDomainNameServices’s Databases Manager.

You can make a new database by just entering the user name and password or create a database backup with a simple click of the mouse. Likewise, through the Data Manager you’ll possess direct access to the admin area for every single database, allowing you to almost instantly manage it.

Via the Databases Manager it is simple to generate an archived duplicate of your database whenever you want! For this reason, you’ll always have a backup of your operating content material in case your website gets compromised or you mistakenly eliminate a database. To create a back–up: click the ’clock’ symbol beside any database and after that wait for a couple of seconds for the process to be performed.

There won’t be any restricts on the amount of databases you would be able to back up or the number of backup copies you can make for a database.

A lot of the Linux cloud website hosting packages packages provide PgSQL support. Although falling behind MySQL when considering acceptance and employment, PgSQL databases are renowned for offering the best level of safety for your website content. This is the reason why businesses like Skype and Yahoo go with PgSQL databases as an alternative to MySQL.

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

We have integrated InnoDB – the brand new standard MySQL database engine on our web servers. InnoDB is designed for huge database sites that require high levels of overall performance and scalability. Trials show that web sites employing InnoDB based tables reach a 3–fold functionality boost for substantial joins, compared with those making use of MyISAM tables.

InnoDB takes advantage of row–level locking in an effort to get rid of the functionality problems discovered at the peak usage times of the earlier variant of the database engine – MyISAM, which uses table–level locking.

Keeping tabs on the load generated by the databases within your busy website makes it possible to reduce any overload difficulties that might slow it down and ward off site visitors. For this reason, we’ve integrated a comprehensive Database Stats tool straight into the Web Site Control Panel. There you can get comprehensive information regarding the arriving requests to your databases for each hour, day and month.

Based on the volume of day–to–day and hourly queries, it will be easier to determine which databases are utilized the most as well as consider measures to enhance their work.