From: Martin Gainty
Date: May 24 2010 11:50am
Subject: RE: Master - master replication
List-Archive: http://lists.mysql.com/mysql/221677
Message-Id: <BLU142-W128E1E8DED9D6D9222C76AAEE70@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_67cdac98-ee70-4875-bc75-09cb37db8825_"

--_67cdac98-ee70-4875-bc75-09cb37db8825_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


yes.. SSL can implement <a number of> number of encryption algorithms

=20

but when a webserver configuration is configured with HTTP (instead ofHTTPS=
)

http://www.pgp.com/

=20

export mysql <DDL/DML> rows to PGP encrypter ..transmit via some secure mec=
hanism sftp/scp (or ftp/cp without secure handshakes)

the PGP decrypter at the other end will decrypt the received rows and const=
ruct import/update statements to MYSQL

=20

?
Martin Gainty=20
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit=
=E9

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
 pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
 ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
.



=20

> From: carl@stripped
> To: walter@stripped
> CC: mysql@stripped
> Subject: Re: Master - master replication
> Date: Mon=2C 24 May 2010 07:24:35 -0500
>=20
> Walter=2C
>=20
> Don't know how I missed that but it exactly what I needed.
>=20
> Thanks=2C
>=20
> Carl
> ----- Original Message -----=20
> From: "Walter Heck" <walter@stripped>
> To: "Carl" <carl@stripped>
> Cc: <mysql@stripped>
> Sent: Monday=2C May 24=2C 2010 5:49 AM
> Subject: Re: Master - master replication
>=20
>=20
> Hi Carl=2C
>=20
> On Mon=2C May 24=2C 2010 at 13:42=2C Carl <carl@stripped> wrote:
> > 1. Is the data visible during transmission?
> Not sure what you mean there?
>=20
> > 2. Is there a way to encrypt the data during transmission?
> MySQL supports SSL encryption of replication. Here's a good starting
> point: http://dev.mysql.com/doc/refman/5.1/en/replication-solutions-ssl.h=
tml
>=20
> cheers=2C
>=20
> Walter Heck
> Engineer @ Open Query (http://openquery.com)
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped
>=20
 		 	   		 =20
_________________________________________________________________
The New Busy is not the old busy. Search=2C chat and e-mail from your inbox=
.
http://www.windowslive.com/campaign/thenewbusy?ocid=3DPID28326::T:WLMTAGL:O=
N:WL:en-US:WM_HMP:042010_3=

--_67cdac98-ee70-4875-bc75-09cb37db8825_--