Percona Cluster stops replication inserts

42 views
Skip to first unread message

amol

unread,
Oct 18, 2012, 1:28:02 AM10/18/12
to percona-d...@googlegroups.com
Hi i am experiencing a strange behavior with the cluster in my test env, i have 10 schema and all the existng schema replicate fine, only 1 schema which is fairly new does not replicate inserts across the cluster 

i tried dropping the schema and re inserting the dump but to no success?

does this sound relevant to anyone? how do i debug this one?

amol

unread,
Oct 18, 2012, 3:54:16 PM10/18/12
to percona-d...@googlegroups.com
would it have something to do with the parameter gcache.size = 128M

the gcache.size has reached 130M on all the nodes?

i am currently trying to force a SST and restore the other 2 nodes and they check fi the cluster still functions fine for the schema?

is there anything i can try?

Alex Yurchenko

unread,
Oct 24, 2012, 12:50:15 AM10/24/12
to percona-d...@googlegroups.com
On 2012-10-18 22:54, amol wrote:
> would it have something to do with the parameter gcache.size = 128M

No. This is totally unrelated.

> the gcache.size has reached 130M on all the nodes?
>
> i am currently trying to force a SST and restore the other 2 nodes
> and they
> check fi the cluster still functions fine for the schema?
>
> is there anything i can try?

Check if your tables are all InnoDB and that you don't use any
replication filtering options.

> On Thursday, October 18, 2012 1:28:02 AM UTC-4, amol wrote:
>>
>> Hi i am experiencing a strange behavior with the cluster in my test
>> env, i
>> have 10 schema and all the existng schema replicate fine, only 1
>> schema
>> which is fairly new does not replicate inserts across the cluster
>>
>> i tried dropping the schema and re inserting the dump but to no
>> success?
>>
>> does this sound relevant to anyone? how do i debug this one?
>>

--
Alexey Yurchenko,
Codership Oy, www.codership.com
Skype: alexey.yurchenko, Phone: +358-400-516-011

Amol Kedar

unread,
Oct 24, 2012, 1:09:40 AM10/24/12
to percona-d...@googlegroups.com
Thanks Alex, yes my problem was that the replication filtering was on
> --
> You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
> To post to this group, send email to percona-d...@googlegroups.com.
>
>

Reply all
Reply to author
Forward
0 new messages