On 15/01/2010 11:54, Krishna Chandra Prajapati wrote:
Hi Brent,
I believe you missed log_slave_updates component on 2 and 1. You have
to enable binary logs + log_slave_updates on 2 and 1.
http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates
Th
Clark wrote:
> Hiya
>
> I have four servers.
>
> 1 < - > 2
> ||
> 4 5
>
> I have master - master replication working flawlessly between server id 1
> and 2.
> Server id 4 is a slave of 1.
> Server id 2 is a slave of 2.
>
>
Hiya
I have four servers.
1 < - > 2
||
4 5
I have master - master replication working flawlessly between server id
1 and 2.
Server id 4 is a slave of 1.
Server id 2 is a slave of 2.
For the slaves replications it works great, but ... I just realised ...
>> This handles part of the problem but a true load balanced master
>> solution is needed. There's no real advantage in spending 5, 10 or
>> $20,000 on a failover master if you can't load balance and the spare
>> will just sit idle.
> Sure there is. If your master blows up, you have a spare wait
On Mon, Sep 09, 2002 at 12:35:10PM -0500, Jeremy Tinley wrote:
> This handles part of the problem but a true load balanced master
> solution is needed. There's no real advantage in spending 5, 10 or
> $20,000 on a failover master if you can't load balance and the spare
> will just sit idle.
Sure
a
Cc: [EMAIL PROTECTED]
Subject: Re: Replications...
On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote:
> Jeremy Zawodny ([EMAIL PROTECTED]) écrivait:
> >
> >On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
> >> Hi,
> >>
> >> Does th
Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
>
>> >http://jeremy.zawodny.com/mysql/managing-mysql-replication_files/slide0121.htm
>> >
>> >Just make B a slave of A, C a slave of B, and A a slave of C.
>>
>> This is a good approach.
>
>Except that it's fragile. One machine can go down and "break the
On Sun, Sep 08, 2002 at 11:53:41PM +, Sam Przyswa wrote:
> Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
> >
> >> Does multi-master mean master to master, imagine you have 3 MySQL
> >> servers, A, B, C, with a load balancer in front end, if we make an
> >> update on A, is it possible to replicate/
t;> >> Does the next MySQL 4.x version will support cross replications
>> >> between several master servers in cluster ?
>> >
>> >Multi-master replication works as well in 4.x as it does in 3.23.xx.
>>
>> Does multi-master mean master to master, i
On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote:
> Jeremy Zawodny ([EMAIL PROTECTED]) écrivait:
> >
> >On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
> >> Hi,
> >>
> >> Does the next MySQL 4.x version will support cross replicati
Jeremy Zawodny ([EMAIL PROTECTED]) écrivait:
>
>On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
>> Hi,
>>
>> Does the next MySQL 4.x version will support cross replications
>> between several master servers in cluster ?
>
>Multi-master replicatio
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
> Hi,
>
> Does the next MySQL 4.x version will support cross replications
> between several master servers in cluster ?
Multi-master replication works as well in 4.x as it does in 3.23.xx.
Jeremy
--
Jeremy D. Zawodny
Hi,
Does the next MySQL 4.x version will support cross replications between several
master servers in cluster ?
Thanks in advance.
Sam.
--
Sam Przyswa - Chef de projet
Arial Concept - Intégrateur Internet
36, rue de Turin - 75008 - Paris
Tel: 01 40 54 86 04 - Fax: 01 40 54 83 01
Web: http
>Description:
Using "set character set cp1251_koi8" before updates insert right
data on master server (cp1251 from client recode to koi8 on server),
but replication on slave server wrong (data dosn't recode from
cp1251 to koi8).
>How-To-Repeat:
Setup replica
Hello all,
I'm moving from ASP to PHP & MSSQL to Mysql, but I have some
doubt.
It is possible in MySQL Bi-Directional Replications? If it's,
then I need to find some documentation about it. Where can I find i
>Description:
We have a master server which replicates to a slave. Both
are Solaris 2.7 machines running mysql-3.23.33 (Official MySQL binary).
The appropriate Master's my.cnf file looks like this:
server-id=221
binlog-do-db=Shopping
and the slave's looks like this:
server-id=200
mast
16 matches
Mail list logo