Databases Manager

Managing your databases is less complicated than ever before, on account of the Web Control Panel user interface for MySQL and PgSQL administration! Even though you may not have detailed experience in making use of databases, it will be simple to manage Dedec Mexico’s Databases Manager.

You could make a whole new database by simply typing the user name and security password or create a database back–up with a simple click of the mouse. Additionally, via the Data Manager you will get direct access to the administrative area for each and every database, so you can easily modify it.

In case you have worked with databases, you know that creating a manual database backup is just not an elementary task. In order to change this, we’ve developed very simple tool that can back up the entire database with just a single mouse click. The backup file will be prepared for you in under a minute, depending upon the size of the selected database.

There won’t be any limitations on exactly how many backups you may make for any particular database.

Practically all of our shared web hosting plans plans grant PgSQL support. While falling behind MySQL with regard to level of popularity and utilization, PgSQL databases are renowned for offering up the best level of stability for your web site content material. This is the reason why businesses like Skype and Yahoo make use of PgSQL databases as opposed to MySQL.

With respect to database management, PgSQL is equally uncomplicated as MySQL.

The MySQL databases on Dedec Mexico’s web servers employ the most current version of the InnoDB storage engine. InnoDB was created to ensure the highest possible effectiveness for web sites that deal with significant amounts of data. It provides CPU performance that can not be matched by alternative disk–based relational database engines.

InnoDB is ACID–compliant and offers complete transaction support, meaning that you are able to update/insert/create/alter/drop a couple of times for a single "operation" of your web application. Additionally, it uses row–level locking as a substitute for MyISAM’s table–level locking, that improves multi–user concurrency and efficiency.

From the comprehensive database stats tool built–into the Web Control Panel, it’s possible to make a record of the stress created from your active sites around the clock. Virtually any overload difficulty with your web sites can lower the loading rates and have a damaging effect on the overall experience of your website visitors. Thus, having data for the database load instantly, you’ll be able to eliminate overload problems as soon as possible.

The database stats interface displays information of the number of daily, hourly and monthly queries, so its possible to assess just how the load is spread over different time frames.