<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>Am 03.07.2013 um 22:31 schrieb Lars Ellenberg <<a href="mailto:lars.ellenberg@linbit.com">lars.ellenberg@linbit.com</a>>:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span style="font-family: Monaco; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; display: inline !important; float: none; ">What purpose, exactly, is pacemaker supposed to serve in your setup?</span><br style="font-family: Monaco; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "></blockquote><div><br></div><div>Hi Lars,</div><div><br></div><div>running a two node Active/Passive-Cluster. As we don't have a STONITH-Device we decided to add a third node as quorum node into the setup and stop all services if we ever loose quorum.</div></div><br><div>Unfortunately the third node has to run an MySQL-Slave which should never become active, but pacemaker of course has to manage MySQL on the two other nodes.</div><div><br></div><div>It might not be the perfect Cluster setup you will find in any books but I can see nothing what's really wrong with it.</div><div><br></div><div>I could think of a setup were MySQL will run with one master and two slaves and forbid the migration/promotion to the third node but I would like to share the Database-Files between the active and the passive node via DRBD as I expect it to be more reliable. The downside is that you has to wait until the MySQL-Server on the (no longer) passive node has been started in case of failover, but I can live with that.</div><div><br></div><div>Of course, I'm very open to any comments or recommendations you might have.</div><div><br></div><div>Best regards</div><div>Denis Witt</div></body></html>