{"comment":{"url":"https://api.github.com/repos/puppetlabs/puppetlabs-mysql/comments/17760980","html_url":"https://github.com/puppetlabs/puppetlabs-mysql/commit/96c9d6d9a749e0e68f6006c80c86fcfab72d9763#commitcomment-17760980","id":17760980,"user":{"login":"cubiclelord","id":9519908,"avatar_url":"https://avatars.githubusercontent.com/u/9519908?v=3","gravatar_id":"","url":"https://api.github.com/users/cubiclelord","html_url":"https://github.com/cubiclelord","followers_url":"https://api.github.com/users/cubiclelord/followers","following_url":"https://api.github.com/users/cubiclelord/following{/other_user}","gists_url":"https://api.github.com/users/cubiclelord/gists{/gist_id}","starred_url":"https://api.github.com/users/cubiclelord/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cubiclelord/subscriptions","organizations_url":"https://api.github.com/users/cubiclelord/orgs","repos_url":"https://api.github.com/users/cubiclelord/repos","events_url":"https://api.github.com/users/cubiclelord/events{/privacy}","received_events_url":"https://api.github.com/users/cubiclelord/received_events","type":"User","site_admin":false},"position":null,"line":null,"path":null,"commit_id":"96c9d6d9a749e0e68f6006c80c86fcfab72d9763","created_at":"2016-06-06T22:14:58Z","updated_at":"2016-06-06T22:14:58Z","body":"Hey guys, there is a problem with the way that you are fixing this.\r\n\r\nWe just upgraded to the MySQL forge module 3.8.0 (skipping 3.7.0, which is when this change was introduced.) \r\n\r\nAccording to the MySQL server documentation (https://dev.mysql.com/doc/refman/5.6/en/replication-options.html#option_mysqld_server-id) the largest integer allowed for server-id is 2^32. The current code creates much larger integers and thus mysql chokes and and sets the server-id to be the largest server-id that it allows which is 4294967295.\r\n\r\nHere is an example that broke replication with my setup:\r\n```\r\n# facter macaddress\r\nbc:76:4e:11:21:56\r\n\r\n# cat /etc/mysql/my.cnf\r\n...\r\nserver-id = 203863693462\r\n\r\n(none):SELECT @@server_id;\r\n+-------------+\r\n| @@server_id |\r\nbq. +-------------+\r\n|   4294967295 |\r\n+-------------+\r\n```\r\n\r\nIf you have 2 servers with MAC addresses that are higher than 2^32 then both servers get set to the same highest value and then replication breaks. Can we please revert this change or figure out a way to get a number that is always less than 2^32?"}}
{"actor":{"display_login":"cubiclelord"}}