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

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

am 03.12.2010 19:05:20 von Ryan Chan

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@m.gmane.org

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

am 22.12.2010 10:05:05 von david.yang

--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@gmail.com



2010/12/4 Ryan Chan

> 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@gmail.com
>
>

--20cf3043430096507e0497fc0cd3--