Database Manager

The Database Manager within our Hosting Control Panel contains a refined yet simplified interface. It is easy to configure a whole new MySQL or PostgreSQL database by just entering a user name and password. Also, you could make a back–up file or change the security password of an database with simply a mouse click.

With the Database Manager you will possess direct access to the management area for each of your databases, which enables you to make simple and easy modifications if you ever need to.

Through the Database Manager it is simple to generate an archived duplicate of your database whenever you would like! This way, you will always have a back–up of your active content material in case your site gets hacked or if you mistakenly remove a database. To produce a backup: click the ’clock’ icon beside any database and afterwards wait for a couple of seconds for the process to be finalized.

There aren’t any restricts on the amount of databases you would be able to back up or the quantity of backups you can create for a database.

You are going to find PgSQL support in all of our web hosting services plans. PgSQL databases aren’t as popular and frequently used as MySQL, however they offer the maximum level of security for your website content. Due to this, many well–known businesses like Skype and Yahoo utilize PgSQL databases. Controlling PgSQL databases is as simple and easy as MySQL, due to the incredibly user–friendly interface of the Database Manager.

PgSQL databases are incorporated by default within the most sophisticated web hosting plans. For the regular bundles, they’re featured as upgrades.

The MySQL databases on 3Taccount’s servers use the most current version of the InnoDB storage engine. InnoDB has been created to guarantee the highest possible effectiveness for sites that operate with huge amounts of data. It provides CPU effectiveness that can not be equalled by other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies 100% transaction support, meaning you’re able to update/insert/create/alter/drop more than once for a single "operation" of your web application. In addition, it makes use of row–level locking in place of MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

Tracking the load caused by the databases for your active site will let you prevent any kind of overload issues that can slow it down and chase away website visitors. Therefore, we’ve designed a descriptive Database Stats tool straight into the Hosting Control Panel. There you will find complete information regarding the inbound requests to your databases for each hour, day and month.

Using the volume of day–to–day and per hour queries, you’re going to be able to find out which databases are utilized the most and also consider measures to enhance their work.