mysql-mmm

lp:~seuis398/mysql-mmm/reliable_virtual_ip

Created by SeWoong Jeon on 2012-02-01 and last modified on 2012-02-07

Because there is a limit to the number of arp packet a switch can handle simultaneously, MMM arp packets can be ignored sometimes.
In that case, client host cannot access mysql db through virtual ip, because of wrong arp cache.
So, arp packet send interval need to be increased.

And... to make sure virtual ip is assigned exactly,
mmm_control executes "vip ping test" and displays the result. ("Net::Ping" is required.)

(Ex.) $ mmm_control show
db01(192.168.56.10) master/ONLINE. Roles: writer(192.168.56.20)/Ping_OK
db02(192.168.56.11) master/ONLINE. Roles: reader(192.168.56.21)/Ping_Error

Get this branch:: bzr branch lp:~seuis398/mysql-mmm/reliable_virtual_ip

Only SeWoong Jeon can upload to this branch. If you are SeWoong Jeon please log in for upload directions.

Branch merges

No branches dependent on this one.

Ready for review for merging into lp:mysql-mmm

mysql-mmm-core: Pending requested 2012-02-07

Related bugs

Link a bug report

Related blueprints

Branch information

Owner:: SeWoong Jeon

Project:: mysql-mmm

Status:: Development

Recent revisions

149. By SeWoong Jeon on 2012-02-02

To make sure vip is assigned exactly,
mmm_control executes "vip ping test" and displays the result.
"Net::Ping" is required.

(Ex.) $ mmm_control show
db01(192.168.56.10) master/ONLINE. Roles: writer(192.168.56.20)/Ping_OK
db02(192.168.56.11) master/ONLINE. Roles: reader(192.168.56.21)/Ping_Error

148. By SeWoong Jeon on 2012-02-01

Because there is a limit to the number of arp packet switch can handle simultaneously,
MMM arp packets can be ignored sometimes.
In that case, client host cannot access mysql db through virtual ip, because of wrong arp cache.

147. By Pascal Hofmann on 2010-05-07

Release 2.2.1

146. By Pascal Hofmann on 2010-05-05

Removed checks for incorrect state REPLICATION_BACKLOG (it's called REPLICATION_DELAY...).

145. By Pascal Hofmann on 2010-03-09

Added missing changelog entry.

144. By Pascal Hofmann on 2010-03-09

Release 2.2.0

143. By Pascal Hofmann on 2010-03-09

Non-buffered log4perl mail example in docs.

142. By Pascal Hofmann on 2010-03-09

Allow running multiple agents on the same host (bug #525719)

141. By Pascal Hofmann on 2010-03-09

  * Added manual mode (bug #531011), wait mode, config values 'mode' and 'wait_for_other_master'
  * Don't die at startup when no network connection is available - wait for it to appear instead (bug #416572)
  * Changed startup behaviour. mmm_mond will only go into passive mode if it detects the active_master_role on more than one host.
  * Added config value 'careful_startup' (bug #422549). If set to 0 mmm_mond won't ever switch into passive mode at startup.
  * Added check for invalid agent commands (prevents crash when mmmd_mon version 1.x talks to an 2.x agent).

140. By Pascal Hofmann on 2010-03-03

Fixed date format for 'mmm_control checks' (bug #531841)

Branch metadata

Branch format:: Branch format 6

Repository format:: Bazaar pack repository format 1 with rich root (needs bzr 1.0)

This branch contains Public Security information

Everyone can see this security related information.

Subscribers

SeWoong Jeon