Databases Manager

Database management might sound like a hard task to unskilled web hosting clients, nevertheless with FMGIC.com’s Databases Manager, it’s actually simple! To make a brand new database, you just have to type in the username and password. Database backup copies are only a mouse click away at the same time.Those who would like to explore their databases and update them are able to use the phpMyAdmin and phpPgAdmin tools.

In case you have dealt with databases, you already know that creating a manual database back–up isn’t a simple job. So as to change this, we’ve created very simple tool that will back up your whole database with just a single click of the mouse. The data backup file is going to be prepared for you in under a minute, with respect to the size of the selected database.

There are not any limitations on the actual number of back–ups you can make for any selected database.

Just about all of our Linux website hosting plans offer PgSQL support. While dropping behind MySQL regarding acceptance and utilization, PgSQL databases are renowned for presenting the maximum level of security for your web site content material. It is the primary reason why companies like Skype and Yahoo use PgSQL databases and not MySQL.

When considering database administration, PgSQL is identically quick as MySQL.

The MySQL databases on our servers utilize the most up–to–date build of the InnoDB storage engine. InnoDB was meant to ensure the highest possible performance for web sites that deal with sizeable volumes of data. It features CPU performance that can not be matched up by any other disk–based relational database engines.

InnoDB is ACID–compliant and provides complete transaction support, meaning you can update/insert/create/alter/drop repeatedly for a single "operation" of your web application. Also, it makes use of row–level locking instead of MyISAM’s table–level locking, that increases multi–user concurrency and functionality.

Checking the load accumulated by the databases for your powerful website assists you to prevent any overload troubles that can slow it down and chase away website visitors. For this purpose, we have included a in–depth Database Stats tool into the Online Control Panel. There you can find broad information about the arriving requests to your databases for each hour, day and month.

In line with the quantity of day–to–day and per hour queries, it will be easier to find out which databases are used the most and also take procedures to optimize their work.