2013/2/14 Robert Citek
>
>
> According to the client, nothing is writing to the slave and
> everything is being logged at the master. I have not had the
> opportunity to independently verified any of this, yet. I do know
> that the slave is not in read-only mode, but rather "we promise not to
>
Agreed. Will do that along with several other possible changes. But
for the moment, I'm still gathering information and coming up with
plausible models.
Will also be turning on general mysql logging on both Master and
Slave, at least briefly, to see what statements are being run on both.
Regard
2013/2/13 Robert Citek
> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
> wrote:
> > Any other possibilities? Do other scenarios become likely if there
> > are two or more tables?
> >
> > Of those, which are the most likely?
>
> [from off-list responder]:
> > Other possibility: The replication i
Yes. Except for a handful of static MyISAM tables. But the tables
that are experiencing the issues are all InnoDB and large (a dozen or
so fields, but lots of records.)
Regards,
- Robert
On Thu, Feb 14, 2013 at 5:59 PM, Singer Wang wrote:
> Are you using all InnoDB?
>
> S
--
MySQL General Ma
On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui wrote:
> 2013/2/13 Robert Citek
>>
>> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
>> wrote:
>> > Any other possibilities? Do other scenarios become likely if there
>> > are two or more tables?
>> >
>> > Of those, which are the most likely?
>>
On Thu, Feb 14, 2013 at 5:46 PM, Rick James wrote:
>> Is it in read only mode?
> Furthermore, are all users logging in as non-SUPER users? Note: root
> bypasses the readonly flag!
No. The user that is commonly used does have Super privileges. I am
not sure why, but it does.
Regards,
- Rober
Are you using all InnoDB?
S
On Thu, Feb 14, 2013 at 5:55 PM, Robert Citek wrote:
> On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui
> wrote:
> > 2013/2/13 Robert Citek
> >>
> >> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
> >> wrote:
> >> > Any other possibilities? Do other scenarios bec
ysql
> Subject: Re: slave replication with lots of 'duplicate entry' errors
>
> 2013/2/13 Robert Citek
>
> > On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
>
> > wrote:
> > > Any other possibilities? Do other scenarios become likely if there
> &
ursday, February 14, 2013 2:59 PM
> To: Rick James
> Cc: mysql
> Subject: Re: slave replication with lots of 'duplicate entry' errors
>
> On Thu, Feb 14, 2013 at 5:46 PM, Rick James
> wrote:
> >> Is it in read only mode?
> > Furthermore, are all users logg
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek wrote:
> Any other possibilities? Do other scenarios become likely if there
> are two or more tables?
>
> Of those, which are the most likely?
[from off-list responder]:
> Other possibility: The replication is reading from master not from the point
10 matches
Mail list logo
