Re: Master - master replication

Hi Carl,

On Mon, May 24, 2010 at 13:42, Carl wrote:
> 1.  Is the data visible during transmission?
Not sure what you mean there?

> 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.htm=
l

cheers,

Walter Heck
Engineer @ Open Query (http://openquery.com)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Master - master replication

--_3b150dcf-1419-4d38-b962-49e00010ddfb_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hello Carl

MySQL advertises an encryption package using the ENCRYPT('hello') but to da=
te i have'nt find any information on where to download and configure the en=
crpytion package
did you look at http://www.critotech.com

?
Martin Gainty=20
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit=
=E9
=20
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=
..




> From: carl@etrak-plus.com
> To: mysql@lists.mysql.com
> Subject: Master - master replication
> Date: Mon=2C 24 May 2010 06:42:06 -0500
>=20
> I am setting up master - master replication between two sites that are in=
separate facilities that are hundreds of miles apart. =20
>=20
> The operating systems are Slackware 13=2C the MySql version is 5.1.41 (wi=
ll probably upgrade to latest.)
>=20
> I have two questions:
>=20
> 1. Is the data visible during transmission?
>=20
> 2. Is there a way to encrypt the data during transmission?
>=20
> Thanks=2C
>=20
> Carl
>=20
=20
____________________________________________________________ _____
The New Busy is not the too busy. Combine all your e-mail accounts with Hot=
mail.
http://www.windowslive.com/campaign/thenewbusy?tile=3Dmultia ccount&ocid=3DP=
ID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4=

--_3b150dcf-1419-4d38-b962-49e00010ddfb_--

Master - master replication

------=_NextPart_000_000D_01CAFB0C.3A22F7F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I am setting up master - master replication between two sites that are =
in separate facilities that are hundreds of miles apart. =20

The operating systems are Slackware 13, the MySql version is 5.1.41 =
(will probably upgrade to latest.)

I have two questions:

1. Is the data visible during transmission?

2. Is there a way to encrypt the data during transmission?

Thanks,

Carl


------=_NextPart_000_000D_01CAFB0C.3A22F7F0--

Re: Master - master replication

--0016e65a085c5d02ec048755996f
Content-Type: text/plain; charset=ISO-8859-1

also consider that it is much more likely that remote slaves will start
falling behind particularly if you throw encryption into the equation.

Regards

John

On 24 May 2010 13:24, Carl wrote:

> Walter,
>
> Don't know how I missed that but it exactly what I needed.
>
> Thanks,
>
> Carl
> ----- Original Message ----- From: "Walter Heck"
> To: "Carl"
> Cc:
> Sent: Monday, May 24, 2010 5:49 AM
> Subject: Re: Master - master replication
>
>
>
> Hi Carl,
>
> On Mon, May 24, 2010 at 13:42, Carl wrote:
>
>> 1. Is the data visible during transmission?
>>
> Not sure what you mean there?
>
> 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.html
>
> cheers,
>
> Walter Heck
> Engineer @ Open Query (http://openquery.com)
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=john.daisley@butterflysys tems.co.uk
>
>


--
John Daisley

Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer

Telephone: +44 (0)7918 621621
Email: john.daisley@butterflysystems.co.uk

--0016e65a085c5d02ec048755996f--

RE: Master - master replication

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


yes.. SSL can implement number of encryption algorithms

=20

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

http://www.pgp.com/

=20

export mysql 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@etrak-plus.com
> To: walter@openquery.com
> CC: mysql@lists.mysql.com
> 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"
> To: "Carl"
> Cc:
> 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 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@hotmail.com
>=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=3DPID283 26::T:WLMTAGL:O=
N:WL:en-US:WM_HMP:042010_3=

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