From: Marcus Bointon
Date: December 16 2007 11:34am
Subject: Re: I want to send writes to the master and reads to the slaves
List-Archive: http://lists.mysql.com/replication/1059
Message-Id: <3E297987-AEBA-4EFA-909E-CFE07E7E6FB8@synchromedia.co.uk>
MIME-Version: 1.0 (Apple Message framework v915)
Content-Type: multipart/signed; boundary=Apple-Mail-9-454346439; micalg=sha1; protocol="application/pkcs7-signature"

--Apple-Mail-9-454346439
Content-Type: text/plain;
	charset=US-ASCII;
	format=flowed;
	delsp=yes
Content-Transfer-Encoding: 7bit

On 16 Dec 2007, at 05:59, Mike Steele wrote:

> I don't have the authority, prerogative, right, power, or any other  
> god-like characteristic, necessary to change the application.  So, I  
> was hoping there was some proxy (something well beyond "balance") I  
> could stick between the application and the MySQL servers to direct  
> writes to one server and reads to the rest.

It might be overkill, but you could probably do this with sequoia.  
Look on http://sequoia.continuent.org/

Marcus
-- 
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-9-454346439
Content-Disposition: attachment;
	filename=smime.p7s
Content-Type: application/pkcs7-signature;
	name=smime.p7s
Content-Transfer-Encoding: base64

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIILLzCCBN0w
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/FX8wggZKMIIFMqAD
AgECAhABjmOx1E79nPKh12HwFZY8MA0GCSqGSIb3DQEBBQUAMIGuMQswCQYDVQQGEwJVUzELMAkG
A1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNU
IE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVRO
LVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsMB4XDTA3MTEyODAwMDAw
MFoXDTA4MTEyNzIzNTk1OVowgeMxNTAzBgNVBAsTLENvbW9kbyBUcnVzdCBOZXR3b3JrIC0gUEVS
U09OQSBOT1QgVkFMSURBVEVEMUYwRAYDVQQLEz1UZXJtcyBhbmQgQ29uZGl0aW9ucyBvZiB1c2U6
IGh0dHA6Ly93d3cuY29tb2RvLm5ldC9yZXBvc2l0b3J5MR8wHQYDVQQLExYoYykyMDAzIENvbW9k
byBMaW1pdGVkMRcwFQYDVQQDEw5NYXJjdXMgQm9pbnRvbjEoMCYGCSqGSIb3DQEJARYZbWFyY3Vz
QHN5bmNocm9tZWRpYS5jby51azCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAMfdkFu7
ZFntxqysPCX4ZELsCGET2maGRji8pFDF0+kqR5yGUrI+de7BheAIy0IL7h89UeMSnJfYtnxb901y
LBFwIRC0R77i9ShXg4W3UC0hy3IfM0OTUZyjDWpdv3K7lRHDjEQy2iqF3fJSRchxQE6XfQiALWxF
foeU3NdTmjfqGcmPOiyv6ngDeEtx2766btbQMWaB8gp/kesA79jBfkip34bK7SE5r7K33iyCKQFB
nJkBydGk/MMRMPev3HX879YpBKthhbfvHNrDalpiRf6R78CV6L9DfpcyUvfbTYTf+fIEb3kxP3Q8
nShXggq1scwfWVtfwBQKORmbVO5rlaMCAwEAAaOCAiswggInMB8GA1UdIwQYMBaAFImCZ33EnSZw
AEu0UEh83j2uBG59MB0GA1UdDgQWBBRqnns+AZrtY4U86tNs3z+p9BTPYzAOBgNVHQ8BAf8EBAMC
BaAwDAYDVR0TAQH/BAIwADAgBgNVHSUEGTAXBggrBgEFBQcDBAYLKwYBBAGyMQEDBQIwEQYJYIZI
AYb4QgEBBAQDAgUgMEYGA1UdIAQ/MD0wOwYMKwYBBAGyMQECAQEBMCswKQYIKwYBBQUHAgEWHWh0
dHBzOi8vc2VjdXJlLmNvbW9kby5uZXQvQ1BTMIGlBgNVHR8EgZ0wgZowTKBKoEiGRmh0dHA6Ly9j
cmwuY29tb2RvY2EuY29tL1VUTi1VU0VSRmlyc3QtQ2xpZW50QXV0aGVudGljYXRpb25hbmRFbWFp
bC5jcmwwSqBIoEaGRGh0dHA6Ly9jcmwuY29tb2RvLm5ldC9VVE4tVVNFUkZpcnN0LUNsaWVudEF1
dGhlbnRpY2F0aW9uYW5kRW1haWwuY3JsMHwGCCsGAQUFBwEBBHAwbjA2BggrBgEFBQcwAoYqaHR0
cDovL2NydC5jb21vZG9jYS5jb20vVVROQUFBQ2xpZW50Q0EuY3J0MDQGCCsGAQUFBzAChihodHRw
Oi8vY3J0LmNvbW9kby5uZXQvVVROQUFBQ2xpZW50Q0EuY3J0MCQGA1UdEQQdMBuBGW1hcmN1c0Bz
eW5jaHJvbWVkaWEuY28udWswDQYJKoZIhvcNAQEFBQADggEBAITHsTuM4xG7XfdPBrS0Vtqy81ch
waexQ8BBWlWY0SA50eELvK+6gk89y5q6/zxOgUlTyXDRpVwwZGt96KBfyxpd20WHVRBsGtYSCTAP
Vt0ahdVNIrm2hWzPnAF9Vb8rczhaiLN7dgz43q9XgfOsBbXYL5erkZppsJS/v18etsFzeWkZ4Xkz
kZ1JTp7qCRMPswKsPV7JrtToP0eA+Meuhb2NaoZZwZwwoTJnuN845yzLx6TF/qHmUQFVfT6rF9/6
Qv2rjp2ZmQAj18IrhsgFFL/abTK7fTGfwyMa8RJgShpYRLF1doTrbJL300T+upnQ/ceNkGtdDNJW
eynQjSNka3cxggP8MIID+AIBATCBwzCBrjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcwFQYD
VQQHEw5TYWx0IExha2UgQ2l0eTEeMBwGA1UEChMVVGhlIFVTRVJUUlVTVCBOZXR3b3JrMSEwHwYD
VQQLExhodHRwOi8vd3d3LnVzZXJ0cnVzdC5jb20xNjA0BgNVBAMTLVVUTi1VU0VSRmlyc3QtQ2xp
ZW50IEF1dGhlbnRpY2F0aW9uIGFuZCBFbWFpbAIQAY5jsdRO/Zzyoddh8BWWPDAJBgUrDgMCGgUA
oIICDTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wNzEyMTYxMTM0
MzhaMCMGCSqGSIb3DQEJBDEWBBQe3aQjcNJq3ItNjo5B8pFidsiU8TCB1AYJKwYBBAGCNxAEMYHG
MIHDMIGuMQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5
MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNl
cnRydXN0LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24g
YW5kIEVtYWlsAhABjmOx1E79nPKh12HwFZY8MIHWBgsqhkiG9w0BCRACCzGBxqCBwzCBrjELMAkG
A1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcwFQYDVQQHEw5TYWx0IExha2UgQ2l0eTEeMBwGA1UEChMV
VGhlIFVTRVJUUlVTVCBOZXR3b3JrMSEwHwYDVQQLExhodHRwOi8vd3d3LnVzZXJ0cnVzdC5jb20x
NjA0BgNVBAMTLVVUTi1VU0VSRmlyc3QtQ2xpZW50IEF1dGhlbnRpY2F0aW9uIGFuZCBFbWFpbAIQ
AY5jsdRO/Zzyoddh8BWWPDANBgkqhkiG9w0BAQEFAASCAQB/mt7rRjsGisDgAQCtsN9xuC94XE+s
NRNYifHaFd9/rh4miNA7l0jxHWNMrPYI7ZtJ9DmbjG1FtgOwe9Hyw17PP5/53aWGrbIZdhLTycbM
RoK+oaMOpDhaJhWtA172nOktPwjgjyt+JOgyQd0rIuk4HICwnmP8R9sUqcEHTnKiTXBeolYYSXk8
zVdGVPzNRkhFhzlLw5Oihc4GD+lqoTmRPqSYJxmUwDOxNXsCbJgJgzLW0ye8yN0ez63BdQ3ocO6K
RJuLYXlV/IPAMnU6tm4Rlc7rhspZvJXCgLlrZWtTjxbzgtb8DpRbDjajY5tShBGSSk3CftnCx5Vi
Mio9FawsAAAAAAAA

--Apple-Mail-9-454346439--