Database Manager

Taking control of your databases is much simpler than ever, because of the Web Site Control Panel user interface for MySQL and PgSQL management! In case you do not have substantial experience of dealing with databases, you will find it simple to deal with DC-webhosting.com’s Database Manager.

You can make a completely new database simply by typing the username and password or produce a database backup with a mouse click. Also, through the Data Manager you’ll get direct access to the management area for every single database, meaning you can quite simply modify it.

From the Database Manager you’re able to create an archived duplicate of your database when you wish! Thus, you’ll always have a backup of your dynamic information in the event your site gets broken into or if you incorrectly remove a database. To produce a backup: click on the ’clock’ icon alongside a given database and after that simply wait for a couple of seconds for the process to be performed.

There are not any limits about the amount of databases you are able to back up or the quantity of backup copies you can make for a database.

You’ll find PgSQL support in our cloud web hosting packages. PgSQL databases aren’t as well–known and widespread as MySQL, however they offer the maximum level of protection for your site content and articles. For this reason, a lot of famous brands like Skype and Yahoo employ PgSQL databases. Dealing with PgSQL databases is as simple as MySQL, on account of the intuitive user interface of the Database Manager.

PgSQL databases are incorporated by default inside of the most sophisticated web hosting bundles. For the basic plans, they’re offered as upgrades.

We have set up InnoDB – the brand new default MySQL database engine on our web servers. InnoDB is ideal for significant database web sites which need high overall performance and scalability. Tests have revealed that websites employing InnoDB based tables achieve a 3–fold overall performance boost for big joins, compared with those utilizing MyISAM tables.

InnoDB utilizes row–level locking in order to clear away the operation problems observed at the peak consumption times of the earlier variant of the database engine – MyISAM, which utilizes table–level locking.

We provide you an easy route to keep an eye on the database usage for your powerful websites. Through the thorough database stats user interface, which is integrated into the Web Site Control Panel, it’s possible to record the load made through your busy sites in real time. The supplied information will allow you to analyze the database load variations each hour, each day or monthly.

You can monitor the database load for all of your websites within the Database Stats part of the Web Site Control Panel. The table on–screen features the database lookups generated during the present month. To take a look at info for a previous month, click on the back arrows situated at the top.