Hello Egor,
On 4/20/2012 8:52 AM, nixofortune wrote:
Hi Shaw,
I have two more question here.
1. Why those rows hasn't been deleted on slaves?
2. Why no slow logs entries were created?
Many thanks for your time and effort.
1) Perhaps the slave has not reached that point in the binary logs? You
Hi Shaw,
I have two more question here.
1. Why those rows hasn't been deleted on slaves?
2. Why no slow logs entries were created?
Many thanks for your time and effort.
Egor
On 20 April 2012 12:51, shawn green wrote:
> Hello Egor,
>
>
> On 4/20/2012 7:17 AM, nixofortune wrote:
>
>> Hi guys,
>>
Hi Reindl,
Many thanks for your contribution.
I did remember we discussed rsync backup method in the past and I was able
successfully to do this on our staging 100Gig + MASTER<=>MASTER replication
setup.
The downtime was really minimum, minutes not hours.
It used to fail on regular basis as we tri
Hi Shawn,
Great! This is most likely what happened.
I saw yesterday when the drama developed, that mysql does huge amount of
select queries, but couldn't identified the source. the was no long running
threads, no slow logs entries as well.
Now I understand what happened.
This is a table definition
Am 20.04.2012 13:44, schrieb nixofortune:
> Thanks,
> So the actions should be:
> 1. Stop slaves
> 2. On Slaves: SET GLOBAL binlog_format=MIXED
> 3. Start slaves.
not "SET GLOBAL", put things you want in my.cnf
you want them also get active after restart :-)
> What is "restart the replication f
Hello All,
On 4/20/2012 7:44 AM, nixofortune wrote:
Thanks,
So the actions should be:
1. Stop slaves
2. On Slaves: SET GLOBAL binlog_format=MIXED
3. Start slaves.
What is "restart the replication from scratch with a binary ident copy
(rsync)"
Is it to use rsync to rsync mysql data on masters an
Hello Egor,
On 4/20/2012 7:17 AM, nixofortune wrote:
Hi guys,
I'm am experiencing strange behaviour with the replication.
Our replication Setup looks like this:
Master1(5.1.46-log)
=Master2(5.1.46-log)
/ |
Thanks,
So the actions should be:
1. Stop slaves
2. On Slaves: SET GLOBAL binlog_format=MIXED
3. Start slaves.
What is "restart the replication from scratch with a binary ident copy
(rsync)"
Is it to use rsync to rsync mysql data on masters and slaves? and than run
chnge the master to to star
Am 20.04.2012 13:17, schrieb nixofortune:
> So far I found :
> binlog_format different:
> Masters (MIXED)
> Slaves (STATEMENT)
>
> sync_binlog different on one of the slaves: 1024 against 0 on the rest
binlog format "statement" is practically unuseable
there are way too much possible queries
Hi guys,
I'm am experiencing strange behaviour with the replication.
Our replication Setup looks like this:
Master1(5.1.46-log)
=Master2(5.1.46-log)
/ |\
Slave1(5.1.46-log) Slave2(5.1.52) Slave3(5.1.52)
10 matches
Mail list logo