Database Manager

Administering your databases is simpler than ever, on account of the Control Panel user interface for MySQL and PgSQL control! Even if you do not have thorough knowledge in utilizing databases, it will be easy to manage Creekside Technologies’s Database Manager.

You can make a completely new database merely by typing the username and security password or make a database backup with a mouse click. Likewise, through the Data Manager you will have direct access to the management area for each individual database, so you can almost instantly update it.

Within the Database Manager you can make an archived duplicate of your database whenever you want! That way, you’ll always have a back–up of your dynamic content if your site gets compromised or you incorrectly get rid of a database. To generate a backup: click the ’clock’ symbol beside any database and after that wait for a few seconds for the backup process to be performed.

There won’t be any limits on the number of databases you can back up or the amount of back–ups you can create for any database.

PgSQL databases are significantly less sought after than the common MySQL databases. On the other hand, they’re a preferred selection for developers who seek the utmost protection for their websites and web apps. Via the incredibly user–friendly Database Manager integrated into the Creekside Technologies Control Panel, you can administer all your PostgreSQL databases with merely a click of the mouse.

You can discover PgSQL databases included by default inside the advanced hosting packages. Assuming that you are with a regular hosting package, it’s possible to request PgSQL databases to be included in your account as upgrades.

The MySQL databases on our servers utilize the most current version of the InnoDB storage engine. InnoDB was designed to ensure the max effectiveness for sites that deal with sizeable volumes of data. It provides CPU efficiency that can not be matched by any alternative disk–based relational database engines.

InnoDB is ACID–compliant and provides full transaction support, so that you’ll be able to update/insert/create/alter/drop a couple of times for a single "operation" of your web application. Additionally, it works by using row–level locking as a substitute for MyISAM’s table–level locking, that increases multi–user concurrency and efficiency.

From the all–inclusive database statistics tool included in the Control Panel, it is possible to keep a record of the load created by your busy web sites 24 hour a day. Any overload problem with your web sites could reduce the loading speeds and have a negative effect on the online experience of your website visitors. Consequently, by having info for the database work right away, you are able to fix overload issues as quickly as possible.

The database stats user interface reveals details of the quantity of daily, hourly and monthly queries, so that you can assess just how the load is distributed over several time frames.