Database Manager

Database management may appear like a difficult task to new website hosting customers, nevertheless with the Database Manager, it’s in fact simple! To set up a completely new database, you simply need to enter in your username and password. Database back–ups are only a mouse click away too.Those who want to examine their databases and then modify them may use the phpMyAdmin and phpPgAdmin tools.

We’ve designed the manual database back–up formation into a quite simple task. To do so: in the Database Manager, click on the ’clock’ symbol on the side of the database that you would like to back up and afterwards wait around for a few seconds for the process to take place. With respect to the size of the database, the building of a backup file will need somewhere between a few seconds and a minute.

You can create as many backups of a database as you would like. We haven’t determined any boundaries for the amount of databases you could back up either.

Almost all of Alpha-Omega Systems’s cloud hosting bundles provide PgSQL support. Although falling behind MySQL in terms of acceptance and employment, PgSQL databases are famous for delivering the greatest level of safety for your web site content and articles. It is the key reason why companies like Skype and Yahoo make use of PgSQL databases as opposed to MySQL.

In relation to database administration, PgSQL is just as uncomplicated as MySQL.

We have added InnoDB – the new default MySQL database engine on every one of our machines. InnoDB is good for massive database sites which need high levels of effectiveness and scalability. Experiments have demonstrated that sites working with InnoDB based tables reach a 3–fold performance grow for huge joins, compared with those employing MyISAM tables.

InnoDB works by using row–level locking as a way to remove the functionality issues witnessed at the maximum consumption times of the previous variant of the database engine – MyISAM, which utilizes table–level locking.

Tracking the load generated by the databases within your dynamic website will help you reduce all overload issues that could slow it down and ward off visitors. As a result, we have bundled a in depth Database Stats tool straight into the Web Site Control Panel. There you can find thorough info on the inbound requests to your databases for every single hour, day and month.

Using the volume of daily and by the hour queries, it’s possible to determine which databases are utilized the most and then consider procedures to optimize their load.