Databases Manager

The Databases Manager within our Site Control Panel has a refined yet convenient user interface. You can set up a brand new MySQL or PostgreSQL database by just typing in a username and security password. Additionally, you could make a back–up file or modify the security password of an database with merely a click of the mouse.

Within the Databases Manager you have direct access to the administration area for each of your databases, meaning you can make effortless alterations if you ever need to.

If you have dealt with databases, you know making a manual database backup is not really an elementary task. In an effort to change this, we’ve created a simple tool that can back up your whole database with simply a single click of the mouse. The data backup file will be prepared for you in under a minute, with respect to the size of the selected database.

You won’t notice any limitations on the actual number of backups you may make for any chosen database.

Most of Yates Web Solutions’s shared website hosting plans bundles deliver PgSQL support. Although falling behind MySQL regarding level of popularity and usage, PgSQL databases are renowned for offering the best level of protection for your website content. It is the key reason why brands like Skype and Yahoo rely upon PgSQL databases instead of MySQL.

When it comes to database management, PgSQL is equally simple as MySQL.

We have set up InnoDB – the brand new default MySQL database engine on all of our servers. InnoDB is great for sizeable database websites that need high levels of overall performance and scalability. Experiments have established that websites employing InnoDB based tables reach a 3–fold performance boost for very large joins, compared to those working with MyISAM tables.

InnoDB works by using row–level locking so as to clear away the operation issues detected at the peak usage times of the prior release of the database engine – MyISAM, which utilizes table–level locking.

We offer you a simple and easy approach to keep an eye on the database utilization on your powerful sites. From the thorough database statistics user interface, that is integrated into the Site Control Panel, you’re able to keep track of the load produced from your active sites in real time. The displayed info will let you evaluate the database load variations on an hourly basis, every day or monthly.

You’re able to keep an eye on the database load for your web sites from the Database Stats portion of the Site Control Panel. The table onscreen shows the database queries accumulated during the present month. To review info for a past month, simply click on the back arrows placed at the top.