Database Manager

The Database Manager in our Online Control Panel provides a refined but uncomplicated interface. It is easy to configure a completely new MySQL or PostgreSQL database by just entering a user name and password. What’s more, you can create a back–up file or change the security password of an database with only a click of the mouse.

Through the Database Manager you’ve got direct access to the administrator area for every one of your databases, allowing you to make simple and easy adjustments if you ever have to.

Via the Database Manager it is simple to create an archived backup of your database whenever you would like! Thus, you are going to always have a backup of your operating content in the event your website gets broken into or if you mistakenly get rid of a database. To generate a back–up: click the ’clock’ icon alongside a certain database and after that wait for a couple of seconds for the process to be performed.

There are no limitations on the quantity of databases you can back up or the number of backups you can make for any database.

Most of ElSitioParaMi.com’s shared hosting plans packages feature PgSQL support. Whilst falling behind MySQL when it comes to popularity and utilization, PgSQL databases are famous for offering up the maximum level of stability for your website content. That’s the key reason why companies such as Skype and Yahoo rely upon PgSQL databases instead of MySQL.

When it comes to database administration, PgSQL is equally quick as MySQL.

The MySQL databases on ElSitioParaMi.com’s machines work with the most recent version of the InnoDB storage engine. InnoDB was made to ensure the top effectiveness for sites that operate with significant amounts of data. It delivers CPU effectiveness that could not be matched up by other different disk–based relational database engines.

InnoDB is ACID–compliant and offers total transaction support, meaning it is possible to update/insert/create/alter/drop repeatedly for one "operation" of your app. In addition, it takes advantage of row–level locking in lieu of MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

With the all–inclusive database stats tool included in the Online Control Panel, you will be able to keep tabs of the load produced by your dynamic websites around the clock. Virtually any overload problem with your web sites could slow the loading rates and have a damaging influence over the online experience of your respective site visitors. Consequently, by having details about the database work live, it will be easier to eliminate overload problems right away.

The database data user interface reveals data of the quantity of daily, hourly and monthly lookups, allowing you to analyze just how the load is distributed over several time periods.