Databases Manager

Taking control of your databases is less complicated than before, on account of the Website Control Panel user interface for MySQL and PgSQL control! Even if you do not have detailed expertise in handling databases, you will find it easy to deal with www.A1HOSTERS.com’s Databases Manager.

You can make a new database merely by specifying the user name and password or create a database back–up with simply a mouse click. Additionally, within the Data Manager you’ll possess direct access to the administrative area for every database, allowing you to easily edit it.

We have made the manual database backup formation into a very simple task. To execute that: inside the Databases Manager, click the ’clock’ symbol beside the database that you want to back up and afterwards wait for a couple of seconds for the process to take place. With respect to the size of your database, the creation of a backup file will need somewhere between a couple of seconds and a minute.

You can create as many copies of a database as you desire. We’ve not determined any boundaries about the amount of databases you could back up either.

Most of our Linux shared website hosting bundles deliver PgSQL support. Although falling behind MySQL with regards to acceptance and utilization, PgSQL databases are renowned for offering up the maximum level of safety for your web site content material. This is the primary reason why companies like Skype and Yahoo go with PgSQL databases as an alternative to MySQL.

With regards to database management, PgSQL is as simple as MySQL.

We’ve incorporated InnoDB – the brand new default MySQL database engine on our machines. InnoDB is great for significant database sites that demand high levels of overall performance and scalability. Trials show that web sites applying InnoDB based tables attain a 3–fold functionality increase for very large joins, as compared to those utilizing MyISAM tables.

InnoDB takes advantage of row–level locking so as to clear away the effectiveness difficulties witnessed at the maximum usage times of the prior release of the database engine – MyISAM, which utilizes table–level locking.

From your comprehensive database stats tool built–into the Website Control Panel, you’re going to be able to keep tabs of the stress generated by your busy web sites 24 / 7. Every single overload difficulty with your web sites could lower the loading rates and have a bad impact on the overall impression of your site visitors. Hence, having data for the database work right away, it will be straightforward to resolve overload difficulties in a timely manner.

The database stats interface displays details of the quantity of daily, hourly and monthly lookups, so that you can review how the load is spread over several time frames.