Oracle has updated the commercial edition of its MySQL database for Windows, adding a graphical installer and the ability to do failover clustering, the company announced Tuesday.
Both of these features should help make MySQL Enterprise Edition a more viable database choice for Windows shops, potentially expanding its user base beyond enterprise Linux users, noted Oracle marketing executive Bertrand Matthelié, in a blog post announcing the features.
Oracle designed the new MySQL Installer for Windows to simplify the process of installing MySQL and its associated tools. The new user interface guides the user through the wizard-based installation process. It can install not only MySQL on a Windows computer but other associated programs as well, such as MySQL Workbench and MySQL Query Analyzer. The software also can automatically update all the MySQL products with bug fixes and upgrades as needed.
Failover clustering has also been added. This feature can be handy for those organization that require constant uptime, or HA (high availability), of their databases.
When run on Windows Server 2008 R2, MySQL Enterprise Edition can detect when a copy of MySQL stops operating, either because of hardware failure or due to some failure in the database software itself. The administrative console alerts the administrator to restart the database or server, while moving the workload over to another, duplicate, database.
Although MySQL has been capable of offering HA for awhile -- through a special edition called MySQL Cluster -- this version is easier to set up, requiring as few as two servers to operate.
Oracle will hold a Web tutorial session on Sept. 15 to further explain how to use these new features.