Database Manager

Managing your databases is less complicated than before, due to the Control Panel interface for MySQL and PgSQL administration! Even if you do not have thorough experience of handling databases, you will find it effortless to handle our Database Manager.

You can make a completely new database simply by entering the user name and password or make a database backup with a simple click of the mouse. Moreover, through the Data Manager you have direct access to the admin area for every single database, to help you to conveniently manage it.

We have changed the manual database backup formation into a very easy task. To execute this: in the Database Manager, click the ’clock’ symbol beside the database that you would like to back up and then wait around for a couple of seconds for the backup process to take place. Depending on the size of your database, the building of the backup file will require somewhere between a couple of seconds and a minute.

You may make as many backups per database as you would like. We haven’t determined any limits for the amount of databases you could back up too.

PgSQL databases are significantly less common when compared to the prevalent MySQL databases. Then again, they’re a favored choice for web developers who are looking for the greatest security for their web sites and apps. Because of the easy–to–use Database Manager incorporated into the Onlinksoft Hosting Control Panel, you can control all your PostgreSQL databases with simply a mouse click.

You can find PgSQL databases provided automatically inside the advanced Linux cloud hosting plans packages. Assuming that you are using a regular hosting package, you’re able to request PgSQL databases to be added in your cloud hosting account as upgrades.

The MySQL databases on our servers utilize the most current version of the InnoDB storage engine. InnoDB has been made to ensure the highest possible performance for websites that operate with significant volumes of data. It features CPU effectiveness that could not be matched up by other disk–based relational database engines.

InnoDB is ACID–compliant and grants total transaction support, meaning that you can update/insert/create/alter/drop many times for one "operation" of your web app. Also, it takes advantage of row–level locking in place of MyISAM’s table–level locking, that raises multi–user concurrency and effectiveness.

From your all–inclusive database statistics tool incorporated into the Control Panel, it’s possible to keep tabs of the stress produced through your busy sites at any hour. Virtually any overload issue with your websites could lower the loading rates and have a negative effect on the overall impression of your respective website visitors. Thus, having info for the database load live, it will be possible to eliminate overload difficulties straight away.

The database data user interface displays data of the quantity of daily, hourly and monthly queries, to help you to examine how the load is spread over several periods of time.