What is MGER?
MGER (MySQL Group Replication Environment Manager) is an open-source tool designed specifically for managing MySQL database replication setups and performing automatic failover. It works by continuously monitoring the status of MySQL servers in a replication group and can promote a healthy slave to become the new master if the existing master goes down or becomes unreachable.
Some key features of MGER include:
- Automatic detection and registration of new slaves joining the replication group
- Monitoring of master and slave status and replication health
- Defined conditions for initiating automatic failover and promotion of a new master server
- Supports different MySQL replication technologies like Group Replication, Async Replication, Semi-sync etc.
- Web-based UI for configuring and monitoring replication status
- Command line interface for administration and scripting purposes
- Available for free under GPLv2 license
By automating many of the complex administrative tasks around MySQL high availability, MGER simplifies the process of setting up and managing robust MySQL replication topologies with built-in redundancy and failover capabilities. Its capabilities around auto-failover help minimize downtime and data loss in case the master server goes down unexpectedly.
Imgur, Flickr, ImgBB, Photobucket, PostImage.org, ImageShack, imgbox, TinyPic, Imagesocket, ImgPile, imghut, SlickPic are some alternatives to MGER.