Databases Manager

Administering your databases is much easier than before, due to the Website Control Panel user interface for MySQL and PgSQL management! Even if you do not have in depth expertise in managing databases, it will be simple to use SiteSource’s Databases Manager.

You may create a brand new database by only keying in the user name and password or produce a database back–up with only a click of the mouse. Furthermore, within the Data Manager you will have direct access to the admin area for each and every database, to help you to quickly manage it.

Within the Databases Manager you’ll be able to create an archived copy of your database whenever you would like! This way, you will always have a data backup of your dynamic information in case your site gets hacked or if you erroneously get rid of a database. To produce a backup: click on the ’clock’ symbol beside a particular database and then wait for a couple of seconds for the process to be completed.

There are no confines on the number of databases you would be able to back up or the quantity of backups you can make for a database.

PgSQL databases are much less popular when compared to the widespread MySQL databases. Even so, they’re a preferred alternative for web developers who are looking for the greatest security for their sites and apps. Thanks to the incredibly user–friendly Databases Manager incorporated into the SiteSource Control Panel, you can control your PostgreSQL databases with merely a mouse click.

You will find PgSQL databases provided by default within the top website hosting plans packages. In case you are with a basic hosting package, it’s possible to ask for PgSQL databases to be added in your web hosting account as upgrades.

With SiteSource, you shall invariably discover the newest variant of MySQL and also the default MySQL storage engine – InnoDB, mounted.

InnoDB is definitely more stable when compared to the earlier storage engine’s edition – MyISAM. It is ACID–compliant and, above all – it includes full transaction support. Furthermore, it makes use of row–level locking, in contrast to MyISAM’s table–level locking, that used to cause functionality problems at high usage occasions.

Through the in–depth database stats tool incorporated into the Website Control Panel, you’ll be able to keep track of the load created by your busy websites round the clock. Every overload problem with your websites could lower the loading rates and have a damaging effect on the overall experience of your respective site visitors. Therefore, by having data about the database load immediately, it will be possible to fix overload difficulties at once.

The database data interface reveals data of the amount of daily, hourly and monthly lookups, so you can review the way the load is spread over various time periods.