Databases Manager

Managing your databases is easier than in the past, thanks to the Web Site Control Panel interface for MySQL and PgSQL management! Assuming you do not have in depth experience of dealing with databases, you will find it an easy task to work with saman’s Databases Manager.

You can create a brand new database by only entering the username and security password or make a database backup with simply a mouse click. Moreover, via the Data Manager you’ll possess direct access to the administrator area for each and every database, which means you can effectively update it.

We have changed the manual database back–up generation into a quite easy activity. To execute this: in the Databases Manager, click on the ’clock’ icon beside the database that you intend to back up and then hang on for a few seconds for the backup process to take place. Depending upon the size of the database, the generation of a backup file will take somewhere between a couple of seconds and a minute.

You can make as many back–ups per database as you wish. We have not set any confines about the volume of databases that you can back up either.

PgSQL databases are significantly less popular as opposed to the common MySQL databases. Nonetheless, they represent a favored alternative for programmers who are looking for the greatest safety for their websites and apps. Thanks to the incredibly user–friendly Databases Manager included in the saman Control Panel, you can administer all of your PostgreSQL databases with a mouse click.

You are going to find PgSQL databases integrated by default with the top Linux cloud web hosting packages. Provided that you are using a standard hosting package, you’ll be able to ask for PgSQL databases to be added to your cloud hosting account as upgrades.

The MySQL databases on saman’s machines work with the latest version of the InnoDB storage engine. InnoDB was created to guarantee the top effectiveness for websites that work with significant volumes of data. It boasts CPU performance that can not be equalled by any other different disk–based relational database engines.

InnoDB is ACID–compliant and supplies complete transaction support, meaning that you’re able to update/insert/create/alter/drop several times for one "operation" of your app. Moreover, it works by using row–level locking as an alternative for MyISAM’s table–level locking, that increases multi–user concurrency and performance.

From the thorough database statistics tool built–into the Web Site Control Panel, you are going to be able to keep tabs of the load created by your busy web sites at any hour. Every single overload trouble with your web sites can lower the loading speeds and have a bad impact on the overall experience of your respective website visitors. Consequently, by having information for the database load in real time, it will be easy to fix overload difficulties without delay.

The database statistics user interface shows info of the quantity of daily, hourly and monthly lookups, so that you can examine the way the load is allocated over various time periods.