Database Manager

The Database Manager in our Web Control Panel incorporates a refined but still convenient interface. You are able to configure a whole new MySQL or PostgreSQL database by just typing in a user name and password. Also, you can create a backup file or alter the password of the database with just a mouse click.

From the Database Manager you’ve got immediate access to the management area for each of your databases, meaning you can make simple and easy modifications if you ever need to.

In case you have dealt with databases, you are aware that creating a manual database back–up is simply not an elementary job. So as to change this, we’ve made a simple and easy to use tool that will back up the entire database with a single click. The data backup file will be set for you in less than a minute, with regards to the size of the selected database.

You won’t notice any limitations on exactly how many back–ups you can create for a specific database.

Most of LatinOL Hosting Panama’s Linux shared web hosting packages packages feature PgSQL support. Although falling behind MySQL with regard to level of popularity and application, PgSQL databases are famous for offering up the highest level of security for your website content material. That’s the key reason why companies like Skype and Yahoo rely upon PgSQL databases as a substitute for MySQL.

When considering database management, PgSQL is just as quick as MySQL.

The MySQL databases on our machines employ the most current version of the InnoDB storage engine. InnoDB is intended to ensure the optimum functionality for sites that deal with significant volumes of data. It supplies CPU performance that can not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and supplies full transaction support, which means that you’ll be able to update/insert/create/alter/drop a couple of times for a single "operation" of your web app. Moreover, it utilizes row–level locking in contrast to MyISAM’s table–level locking, that improves multi–user concurrency and functionality.

Our company offers you an uncomplicated route to observe the database consumption of your powerful web sites. From the thorough database stats user interface, that’s built–into the Web Control Panel, you’ll be able to keep track of the load created by your active sites in real time. The provided info will help you assess the database load variations every hour, on a daily basis or monthly.

It’s possible to record the database load for all your websites in the Database Stats part of the Web Control Panel. The table onscreen reveals the database lookups made during the present month. To check data for an earlier month, simply click on the back arrows positioned at the top.