Databases Manager

Overseeing your databases is much simpler than in the past, because of the Site Control Panel user interface for MySQL and PgSQL control! Even if you do not have thorough knowledge of working with databases, you will find it very easy to handle our Databases Manager.

You could make a completely new database by merely keying in the user name and password or make a database backup with simply a mouse click. Also, with the Data Manager you have direct access to the administrator area for each and every database, so you can almost instantly modify it.

With the Databases Manager you’ll be able to create an archived backup of your database whenever you want! Therefore, you will always have a data backup of your operating information in case your website gets compromised or if you incorrectly remove a database. To produce a backup: click on the ’clock’ icon on the side of any database and afterwards just wait for a few seconds for the process to be executed.

There aren’t any restrictions for the amount of databases you would be able to back up or the amount of backup copies you can create for any database.

PgSQL databases are less popular as opposed to the common MySQL databases. On the other hand, they represent a favored choice for developers who are looking for the greatest security for their sites and web applications. Thanks to the intuitive Databases Manager built into the Ikaros Web Hosting Control Panel, you can manage all of your PostgreSQL databases with a mouse click.

You can discover PgSQL databases provided automatically inside of the advanced Linux cloud hosting packages packages. In case you are with a regular hosting package, it is easy to request PgSQL databases to be added to your hosting account as upgrades.

We have set up InnoDB – the brand new standard MySQL database engine on each of our web servers. InnoDB is good for large database web sites that require high performance and scalability. Tests have revealed that sites applying InnoDB based tables reach a 3–fold overall performance grow for huge joins, as compared with those employing MyISAM tables.

InnoDB works by using row–level locking as a way to take away the performance difficulties discovered at the top usage times of the earlier release of the database engine – MyISAM, which uses table–level locking.

With the in–depth database statistics tool integrated into the Site Control Panel, you are going to be able to make a record of the stress accumulated by your busy web sites at any hour. Virtually any overload issue with your websites can lower the loading speeds and have a damaging influence over the overall experience of your respective visitors. Hence, by having information for the database work in real time, it will be easier to eliminate overload issues right away.

The database data user interface shows details of the number of daily, hourly and monthly lookups, which enables you to review the way the load is spread over various periods of time.