Databases Manager

Managing your databases is less complicated than before, due to the Web Control Panel user interface for MySQL and PgSQL administration! Assuming you do not have considerable experience of dealing with databases, it will be very easy to manage Crystalaxis Technologies’s Databases Manager.

You can create a brand new database by only keying in the user name and security password or create a database back–up with a mouse click. Furthermore, within the Data Manager you’ll get direct access to the administrator area for each and every database, so its possible to quite simply revise it.

If you have worked with databases, you already know that creating a manual database back–up is just not a simple task. In an effort to change this, we’ve made a simple and easy to use tool that will back up your whole database with only a single click of the mouse. The back–up file shall be ready for you in less than a minute, based on the size of the chosen database.

There are no limitations on just how many copies you may make for a specific database.

PgSQL databases are significantly less famous than the standard MySQL databases. Then again, they represent a preferred alternative for programmers who are looking for the finest stability for their websites and apps. Due to the user–friendly Databases Manager integrated into the Crystalaxis Technologies Control Panel, you can manage your PostgreSQL databases with just a click of the mouse.

You are going to find PgSQL databases bundled automatically inside of the advanced Linux cloud hosting packages. Provided that you are with a standard hosting package, you can easily ask for PgSQL databases to be added in your cloud hosting account as upgrades.

The MySQL databases on Crystalaxis Technologies’s servers use the most recent release of the InnoDB storage engine. InnoDB is developed to guarantee the top performance for websites that operate with substantial amounts of data. It offers CPU effectiveness that can not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and gives complete transaction support, which means you are able to update/insert/create/alter/drop repeatedly for a single "operation" of your web application. Additionally, it works by using row–level locking in contrast to MyISAM’s table–level locking, that increases multi–user concurrency and effectiveness.

Tracking the load produced by the databases on your active site makes it possible to prevent any sort of overload troubles that can slow it down and ward off site visitors. As a result, we’ve built in a complete Database Stats tool within the Web Control Panel. There you shall find thorough info on the incoming requests to your databases for each and every hour, day and month.

Depending on the amount of day–to–day and hourly queries, it will be straightforward to find out which databases are employed the most and also take actions to optimize their load.