Database Manager

Managing your databases is simpler than before, as a result of Website Control Panel user interface for MySQL and PgSQL management! Even if you do not have extensive experience in utilizing databases, you will find it easy to handle DotComLogic’s Database Manager.

You may create a new database just by specifying the username and security password or create a database back–up with just a click of the mouse. At the same time, with the Data Manager you’ll get direct access to the administration area for each database, to help you to immediately update it.

Assuming you have worked with databases, you know generating a manual database back–up is just not an elementary task. So as to change this, we have developed a simple and easy to use tool that will back up your complete database with a single mouse click. The backup file will be completely ready for you in under a minute, with respect to the size of the selected database.

There won’t be any restrictions on how many backups you may make for a chosen database.

You are going to find PgSQL support in our hosting plans. PgSQL databases may not be as famous and commonly used as MySQL, nevertheless they supply the maximum level of protection for your site content and articles. Due to this, many popular companies such as Skype and Yahoo employ PgSQL databases. Controlling PgSQL databases is as simple and easy as MySQL, because of the user–friendly interface of the Database Manager.

PgSQL databases are included by default with the most innovative web hosting plans. For the basic plans, they’re suggested as upgrades.

The MySQL databases on DotComLogic’s servers make use of the newest version of the InnoDB storage engine. InnoDB has been created to guarantee the highest performance for websites that process huge volumes of data. It presents CPU effectiveness that could not be equalled by any other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, meaning that it is possible to update/insert/create/alter/drop repeatedly for a single "operation" of your application. At the same time, it works by using row–level locking as a substitute for MyISAM’s table–level locking, that increases multi–user concurrency and functionality.

With the all–inclusive database statistics tool built into the Website Control Panel, you will be able to keep track of the stress accumulated from your dynamic web sites around the clock. Every overload issue with your sites could reduce the loading speeds and have a damaging influence over the overall experience of your site visitors. Thus, having details about the database work in real time, it will be straightforward to solve overload troubles right away.

The database statistics user interface reveals information of the volume of daily, hourly and monthly queries, which enables you to analyze the way the load is spread over various periods of time.