Setting Up MySSQL replication with SSL on Ubuntu and Windows

--00163692011a9b211d048be6a437
Content-Type: text/plain; charset=ISO-8859-1

Hi,

We are running Ubuntu 10.04 LTS with MySQL 5.1.46 and Windows 2003 with
MySQL 5.1.46. Normal master to master replication between the two server is
running fine. However, we now want to set-up the replication with SSL to
ensure that all data which is replicated both ways between the two servers
is encrypted. Currently on the Ubuntu 10.04 server, SSL has been installed
and is already working with a existing client connection.

My question is how to we get it working for replication over SSL between the
two servers.

Cheers
Neil

--00163692011a9b211d048be6a437--

Re: Setting Up MySSQL replication with SSL on Ubuntu and Windows

Google?
http://dev.mysql.com/doc/refman/5.0/en/replication-solutions -ssl.html

This is for MySQL 5.1, I imagine its probably the same in 5.1 but
another little google should be able to confirm that for you....

Quoting Tompkins Neil :

> Hi,
>
> We are running Ubuntu 10.04 LTS with MySQL 5.1.46 and Windows 2003 with
> MySQL 5.1.46. Normal master to master replication between the two server is
> running fine. However, we now want to set-up the replication with SSL to
> ensure that all data which is replicated both ways between the two servers
> is encrypted. Currently on the Ubuntu 10.04 server, SSL has been installed
> and is already working with a existing client connection.
>
> My question is how to we get it working for replication over SSL between the
> two servers.
>
> Cheers
> Neil
>






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

Re: Setting Up MySSQL replication with SSL on Ubuntu and Windows

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

Hi

I found this documentation. However, I need more information on setting up
SSL on Windows ?

Neil

On Wed, Jul 21, 2010 at 3:39 PM, wrote:

> Google?
> http://dev.mysql.com/doc/refman/5.0/en/replication-solutions -ssl.html
>
> This is for MySQL 5.1, I imagine its probably the same in 5.1 but another
> little google should be able to confirm that for you....
>
>
> Quoting Tompkins Neil :
>
> Hi,
>>
>> We are running Ubuntu 10.04 LTS with MySQL 5.1.46 and Windows 2003 with
>> MySQL 5.1.46. Normal master to master replication between the two server
>> is
>> running fine. However, we now want to set-up the replication with SSL to
>> ensure that all data which is replicated both ways between the two servers
>> is encrypted. Currently on the Ubuntu 10.04 server, SSL has been
>> installed
>> and is already working with a existing client connection.
>>
>> My question is how to we get it working for replication over SSL between
>> the
>> two servers.
>>
>> Cheers
>> Neil
>>
>>
>
>
>
>
>

--0016e644d5aecbdb8d048be6ca8b--

Re: Setting Up MySSQL replication with SSL on Ubuntu and Windows

According to this you must install OpenSSL then compile MySQL from source....

http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html

Would be nice if someone on the list with prior experience would comment....

Quoting Tompkins Neil :

> Hi
>
> I found this documentation. However, I need more information on setting up
> SSL on Windows ?
>
> Neil
>





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

Re: Setting Up MySSQL replication with SSL on Ubuntu and Windows

Hi!


a.smith@ukgrid.net schrieb:
> According to this you must install OpenSSL then compile MySQL from
> source....
>=20
> http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html

You cannot (in general) assume that some hint you find somewhere for
MySQL 5.0 still applies to MySQL 5.1.
Specifically if the source is the MySQL manual, there is absolutely no
reason to use the 5.0 manual when you are dealing with 5.1, there is a
5.1 manual available.

>=20
> Would be nice if someone on the list with prior experience would
> comment....

Discussing SSL: it is included with current versions of MySQL 5.1 on
Windows.
Sadly, 5.1.46 is a special case: When testing it, there was trouble on
the machines, so the SSL tests were not attempted.
Definitely, both 5.1.45 and 5.1.47 include SSL and passed the tests.

My hint to Neil:
Try to run the MySQL test suite on your machine, it includes SSL tests.
If these pass, your server (and client) does include SSL.

>=20
> Quoting Tompkins Neil :
>=20
>> Hi
>>
>> I found this documentation. However, I need more information on
>> setting up
>> SSL on Windows ?

I don't deal with Windows, so I can't help with this.


Regards,
Jörg

--=20
Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@Sun.COM
(+49 30) 417 01 487
ORACLE Deutschland B.V. & Co. KG, Komturstrasse 18a, D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603


--
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