From: Marcus Bointon Date: September 21 2011 6:57pm Subject: Re: confirm subscribe to replication@lists.mysql.com List-Archive: http://lists.mysql.com/replication/2208 Message-Id: MIME-Version: 1.0 (Apple Message framework v1244.3) Content-Type: multipart/signed; boundary="Apple-Mail=_AC3FFC98-0471-4E63-88CF-EFF052193099"; protocol="application/pkcs7-signature"; micalg=sha1 --Apple-Mail=_AC3FFC98-0471-4E63-88CF-EFF052193099 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 On 21 Sep 2011, at 20:39, Wagner Bianchi wrote: > A good solution could be to use a MASTER <=3D> MASTER topology, using = MySQL > 5.1 or 5.5, in order to split writes between servers, operation will > decrease a little more your workload. I really wouldn't do that. Writing to both masters will not gain you any = performance and asks for all kinds of split-brain trouble. I've been = there, it's not pretty. If you manage your masters with MMM, you won't = be able to do it anyway as it sets passive masters to read-only. It's been said many times - MySQL replication is NOT a scaling solution. = MySQL Cluster and sharding are scaling solutions, but they are unrelated = to replication. Marcus --=20 Marcus Bointon Synchromedia Limited: Creators of http://www.smartmessages.net/ UK resellers of info@hand CRM solutions marcus@stripped | http://www.synchromedia.co.uk/ --Apple-Mail=_AC3FFC98-0471-4E63-88CF-EFF052193099 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIKZTCCBN0w ggPFoAMCAQICEHGS++YZX6xNEoV0cTSiGKcwDQYJKoZIhvcNAQEFBQAwezELMAkGA1UEBhMCR0Ix GzAZBgNVBAgMEkdyZWF0ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBwwHU2FsZm9yZDEaMBgGA1UECgwR Q29tb2RvIENBIExpbWl0ZWQxITAfBgNVBAMMGEFBQSBDZXJ0aWZpY2F0ZSBTZXJ2aWNlczAeFw0w NDAxMDEwMDAwMDBaFw0yODEyMzEyMzU5NTlaMIGuMQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQx FzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsx ITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJz dC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8A MIIBCgKCAQEAsjmFpPJ9q0E7YkY3rs3BYHW8OWX5ShpHornMSMxqmNVNNRm5pELlzkniii8efNIx B8dOtINknS4p1aJkxIW9hVE1eaROaJB7HHqkkqgX8pgV8pPMyaQylbsMTzC9mKALi+VuG6JG+ni8 om+rWV6lL8/K2m2qL+usobNqqrcuZzWLeeEeaYji5kbNoKXqvgvOdjp6Dpvq/NonWz1zHyLmSGHG TPNpsaguG7bUMSAsvIKKjqQOpdeJQ/wWWq8dcdcRWdq6hw2v+vPhwvCkxWeM1tZUOt4KpLoDd7Nl yP0e03RiqhjKaJMeoYV+9Udly/hNVyh00jT/MLbu9mIwFIws6wIDAQABo4IBJzCCASMwHwYDVR0j BBgwFoAUoBEKIz6W8Qfs4q8p74Klf9AwpLQwHQYDVR0OBBYEFImCZ33EnSZwAEu0UEh83j2uBG59 MA4GA1UdDwEB/wQEAwIBBjAPBgNVHRMBAf8EBTADAQH/MB0GA1UdJQQWMBQGCCsGAQUFBwMCBggr BgEFBQcDBDARBgNVHSAECjAIMAYGBFUdIAAwewYDVR0fBHQwcjA4oDagNIYyaHR0cDovL2NybC5j b21vZG9jYS5jb20vQUFBQ2VydGlmaWNhdGVTZXJ2aWNlcy5jcmwwNqA0oDKGMGh0dHA6Ly9jcmwu Y29tb2RvLm5ldC9BQUFDZXJ0aWZpY2F0ZVNlcnZpY2VzLmNybDARBglghkgBhvhCAQEEBAMCAQYw DQYJKoZIhvcNAQEFBQADggEBAJ2Vyzy4fqUJxB6/C8LHdo45PJTGEKpPDMngq4RdiVTgZTvzbRx8 NywlVF+WIfw3hJGdFdwUT4HPVB1rbEVgxy35l1FM+WbKPKCCjKbI8OLp1Er57D9Wyd12jMOCAU9s APMeGmF0BEcDqcZAV5G8ZSLFJ2dPV9tkWtmNH7qGL/QGrpxp7en0zykX2OBKnxogL5dMUbtGB8SK N04g4wkxaMeexIud6H4RvDJoEJYRmETYKlFgTYjrdDrfQwYyyDlWjDoRUtNBpEMD9O3vMyfbOeAU TibJ2PU54om4k123KSZB6rObroP8d3XK6Mq1/uJlSmM+RMTQw16Hc6mYHK9/FX8wggWAMIIEaKAD AgECAhB45yGLeTKVzBp0zj2pUeZjMA0GCSqGSIb3DQEBBQUAMIGuMQswCQYDVQQGEwJVUzELMAkG A1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNU IE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVRO LVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMB4XDTEwMTIwMTAwMDAw MFoXDTExMTIwMTIzNTk1OVowKjEoMCYGCSqGSIb3DQEJARYZbWFyY3VzQHN5bmNocm9tZWRpYS5j by51azCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAODmKfh7oLPd2UwbjvQqcrbdxe5G Uu5OWmIu3Yg0f4H3xaK8HTbMFvZH9ybZK3cYdi6/Y+0UBllpxENQcbLPx9aKIvH2toSWvemh8Zsm ja6f3xaCiCUUE7F9OIFj6vAt6qWQ1ukv7jzPxKHXhPJH6SQxR7MdA2SDfGoly0RKiL03Nmm0aGab QR9Pq7cjVzC5OZnFSQ0mYf4XmEjmPXM8gSE6UKTJHg7qYRisoZ87Nmi75y3YBGV8c8od8GB9M8WB JUvlLQazw01i3qBl0sabJnAbfJnn7yUWZdpaIZN8VexQMmtoSTO46wC7OTJPE3rjtKzUx1BVHEDf BHaQ1Y4ozZkCAwEAAaOCAhswggIXMB8GA1UdIwQYMBaAFImCZ33EnSZwAEu0UEh83j2uBG59MB0G A1UdDgQWBBTb2svxvnC+a+Z8vHGJmm2sQtIvQDAOBgNVHQ8BAf8EBAMCBaAwDAYDVR0TAQH/BAIw ADAgBgNVHSUEGTAXBggrBgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJYIZIAYb4QgEBBAQDAgUgMEYG A1UdIAQ/MD0wOwYMKwYBBAGyMQECAQEBMCswKQYIKwYBBQUHAgEWHWh0dHBzOi8vc2VjdXJlLmNv bW9kby5uZXQvQ1BTMIGlBgNVHR8EgZ0wgZowTKBKoEiGRmh0dHA6Ly9jcmwuY29tb2RvY2EuY29t L1VUTi1VU0VSRmlyc3QtQ2xpZW50QXV0aGVudGljYXRpb25hbmRFbWFpbC5jcmwwSqBIoEaGRGh0 dHA6Ly9jcmwuY29tb2RvLm5ldC9VVE4tVVNFUkZpcnN0LUNsaWVudEF1dGhlbnRpY2F0aW9uYW5k RW1haWwuY3JsMGwGCCsGAQUFBwEBBGAwXjA2BggrBgEFBQcwAoYqaHR0cDovL2NydC5jb21vZG9j YS5jb20vVVROQUFBQ2xpZW50Q0EuY3J0MCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5jb21vZG9j YS5jb20wJAYDVR0RBB0wG4EZbWFyY3VzQHN5bmNocm9tZWRpYS5jby51azANBgkqhkiG9w0BAQUF AAOCAQEAVBxEtai/N91HD7kLrSzYW06+bgmVvEsbv3BUldcJ+97QcWEsxlPMDoDzgbs39yfnZAvR 15eixbXl963AAcDXg5A+xjfHvM88+q2vMmKt6G5sB4JHI19TjBKfwALCBJ/CPp/ikUxmjoB3QN7i o7BdvZqerzi69zb4O7E4JHIBb7JctLypK5FChkC9tCZ3YEnwhSHcpSCocaPXSVLvpx6QfAy6poKc qG+Bu8zNL3Nr5MKFEO7RBWbizIjL3iMjNvhku2Yhd5CHejrjZlH2opeO/I6jCkgecAgVyyhLGUtQ cPYs0DHrpTDxbRhUO5DqPo520q2KpNv2L9UnkqXFOaj1HDGCA/wwggP4AgEBMIHDMIGuMQswCQYD VQQGEwJVUzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVU aGUgVVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2 MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsAhB4 5yGLeTKVzBp0zj2pUeZjMAkGBSsOAwIaBQCgggINMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEw HAYJKoZIhvcNAQkFMQ8XDTExMDkyMTE4NTcyM1owIwYJKoZIhvcNAQkEMRYEFAlFmTNvS/vLNv1r z/BppL/1s0asMIHUBgkrBgEEAYI3EAQxgcYwgcMwga4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJV VDEXMBUGA1UEBxMOU2FsdCBMYWtlIENpdHkxHjAcBgNVBAoTFVRoZSBVU0VSVFJVU1QgTmV0d29y azEhMB8GA1UECxMYaHR0cDovL3d3dy51c2VydHJ1c3QuY29tMTYwNAYDVQQDEy1VVE4tVVNFUkZp cnN0LUNsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgRW1haWwCEHjnIYt5MpXMGnTOPalR5mMwgdYG CyqGSIb3DQEJEAILMYHGoIHDMIGuMQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQxFzAVBgNVBAcT DlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsT GGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQg QXV0aGVudGljYXRpb24gYW5kIEVtYWlsAhB45yGLeTKVzBp0zj2pUeZjMA0GCSqGSIb3DQEBAQUA BIIBAC/sTqeloyQyhn/c5fO4qYM7ts9Fdkz9JtBvjhQOMo9wLu2i1Vo6SHrVWqdBQVzKYWJHZ5Rt nNzJtrLW1QPWlgUW7TaLbAcOmqGR3dt91beDANBcvNEcl/AbkYE2pR9v+bVl8TbRmdKwmyONwgbt lWglP1+t21GRs77vAoCsQkuYJldO3ydCKhd7vA39I5FjrdhwM6+eP8I3m2gNx5HrT0a0fze4dGHN nOmhNqBmcWGLFg9SKSkHPoljzpp+9IAop3sAEjp3j+oyH23/WK8ssd5ylb63U9v0QZAxi0xGMZEd qI2Y8S1kdoaRWjf+tB57nQQK9gfddgwRZbSb3WBd+KMAAAAAAAA= --Apple-Mail=_AC3FFC98-0471-4E63-88CF-EFF052193099--