Parameter(s) need to take care when setting replication over WAN

Hello,

I am setting MySQL (5.0) replication over WAN for backup purpose (with
SSL enabled).

I have read the document:
http://dev.mysql.com/doc/refman/5.0/en/replication.html, and wonder if
any special tunning needed for using replication over WAN.


Are there any configuration parameter(s) need special handling? What I
understand are:

- --master-connect-retry=60
- --master-retry-count=86400

Any others?


Thanks.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2 [at] m.gmane.org
Ryan Chan [ Fr, 03 Dezember 2010 19:05 ] [ ID #2051228 ]

Re: Parameter(s) need to take care when setting replication over WAN

--20cf3043430096507e0497fc0cd3
Content-Type: text/plain; charset=UTF-8

This is depending on your production environment.

David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao0608 [at] gmail.com



2010/12/4 Ryan Chan <ryanchan404 [at] gmail.com>

> Hello,
>
> I am setting MySQL (5.0) replication over WAN for backup purpose (with
> SSL enabled).
>
> I have read the document:
> http://dev.mysql.com/doc/refman/5.0/en/replication.html, and wonder if
> any special tunning needed for using replication over WAN.
>
>
> Are there any configuration parameter(s) need special handling? What I
> understand are:
>
> - --master-connect-retry=60
> - --master-retry-count=86400
>
> Any others?
>
>
> Thanks.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=yueliangdao0608 [at] gmail.com
>
>

--20cf3043430096507e0497fc0cd3--
david.yang [ Mi, 22 Dezember 2010 10:05 ] [ ID #2051982 ]
Datenbanken » gmane.comp.db.mysql.general » Parameter(s) need to take care when setting replication over WAN

Vorheriges Thema: MyQuery 3.4.1 Released
Nächstes Thema: Database procedures