Database Manager

Taking control of your databases now is easier than in the past, as a result of Online Control Panel interface for MySQL and PgSQL management! Provided you do not have detailed knowledge in managing databases, it will be easy to use the Database Manager.

You could make a new database by merely typing the username and security password or generate a database backup with merely a click of the mouse. Likewise, from the Data Manager you have direct access to the administration area for each and every database, which enables you to quite easily modify it.

From the Database Manager you’re able to create an archived copy of your database anytime you desire! Therefore, you will always have a data backup of your dynamic content if your site gets hacked or if you accidentally delete a database. To create a backup: click on the ’clock’ image next to a certain database and afterwards just wait for a few seconds for the process to be finished.

There are no limits for the number of databases you can back up or the quantity of backups you can make for a database.

Nearly all of our Linux hosting plans present PgSQL support. Although falling behind MySQL with respect to acceptance and employment, PgSQL databases are renowned for offering up the best level of safety for your web site content and articles. It is the reason why businesses like Skype and Yahoo employ PgSQL databases instead of MySQL.

In terms of database administration, PgSQL is equally straightforward as MySQL.

With AB3 WEB, LLC, you shall regularly find the most up–to–date edition of MySQL along with the default MySQL storage engine – InnoDB, mounted.

InnoDB is definitely more dependable than the previous storage engine’s version – MyISAM. It is ACID–compliant and, even more importantly – it gives you complete transaction support. Additionally, it utilizes row–level locking, rather than MyISAM’s table–level locking, that used to lead to efficiency issues at peak usage times.

With the all–encompassing database stats tool built into the Online Control Panel, it will be possible to make a record of the stress produced from your busy web sites 24 / 7. Every overload difficulty with your websites can lower the loading rates and have a bad effect on the overall experience of your respective site visitors. Consequently, by having details for the database work in real time, it is also possible to mend overload problems without delay.

The database stats user interface shows information of the volume of daily, hourly and monthly lookups, which enables you to assess just how the load is distributed over various time frames.