Databases Manager

Administering your databases is easier than in the past, on account of the Website Control Panel user interface for MySQL and PgSQL management! In case you do not have in depth expertise in making use of databases, it will be effortless to deal with One Simple Hosting’s Databases Manager.

You could make a new database just by keying in the username and security password or create a database back–up with just a mouse click. In addition, from the Data Manager you’ll possess direct access to the administrator area for each individual database, which means you can instantly update it.

We’ve transformed the manual database back–up creation into a very simple activity. To execute that: inside of the Databases Manager, click the ’clock’ icon beside the database that you would like to back up and hang on for a few seconds for the backup process to take place. Depending upon the size of the database, the creation of the backup file is going to take between a few seconds and a minute.

You may make as many copies per database as you desire. We haven’t fixed any limitations for the amount of databases you can back up either.

You’re going to find PgSQL support in every one of our Linux hosting packages. PgSQL databases might not be as well–known and frequently used as MySQL, nonetheless they supply the best level of stability for your web site content and articles. Due to this, a number of popular companies like Skype and Yahoo implement PgSQL databases. Handling PgSQL databases is as simple and easy as MySQL, thanks to the easy–to–use user interface of the Databases Manager.

PgSQL databases are bundled automatically with the most advanced web hosting packages. For the basic plans, they are presented as upgrades.

We have added InnoDB – the brand new default MySQL database engine on our machines. InnoDB is perfect for substantial database websites that require high levels of general performance and scalability. Experiments demonstrate that websites working with InnoDB based tables attain a 3–fold functionality increase for significant joins, in contrast to those utilizing MyISAM tables.

InnoDB takes advantage of row–level locking as a way to remove the effectiveness difficulties observed at the peak consumption times of the previous variant of the database engine – MyISAM, which employs table–level locking.

One Simple Hosting offers you a straightforward route to keep track of the database use on your dynamic websites. Through the in depth database statistics user interface, which is built into the Website Control Panel, you can track the load made by your active websites in real time. The offered information will help you evaluate the database load variations each hour, on a daily basis or each month.

It’s possible to monitor the database load for all your web sites through the Database Stats part of the Website Control Panel. The table onscreen reveals the database queries accumulated within the present month. To inspect data for an earlier month, all you have to do is click on the back arrows situated at the top.