> > You need to quiesce the InnoDb background threads. One technique is
> > mentioned here:
> > http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablesp
> aces.html
> >
> > Look for the section talking about "clean" backups.
>
> Now we're talkin. I'll check it out.
>
>
I read that secti
> > I'm starting to worry that you may be right. I know FLUSH
> TABLES WITH
> > READ LOCK does not work as expected with InnoDB, but is
> there really
> > no way to put InnoDB into a state where all changes have
> been flushed
> > to disk and it is safe to rsync the directory? Is stopping
>
> On 1/25/2011 10:45, Robinson, Eric wrote:
> >>> There is a very good reason: it is the phenomenon of row
> drift. The
> >>> master and slave can appear to be in good sync, but often
> it is not
> >>> actually the case.
> >>
> >> ... sounds interesting; have you got any document explaining thi
On 1/25/2011 09:00, Robinson, Eric wrote:
...
I'm starting to worry that you may be right. I know FLUSH TABLES WITH
READ LOCK does not work as expected with InnoDB, but is there really no
way to put InnoDB into a state where all changes have been flushed to
disk and it is safe to rsync the direc
On 1/25/2011 10:45, Robinson, Eric wrote:
There is a very good reason: it is the phenomenon of row drift. The
master and slave can appear to be in good sync, but often it is not
actually the case.
... sounds interesting; have you got any document explaining
this phenomenon? AFAIK, the things th
> 240 mysql-instances on 3 physical hosts?
> what crazy setup is this please?
Processors average 90% idle, peaks are low, iowait is low, the system is
not swapping, response time is good, and our users are happy all around
the country. What is crazy about that?
> The whole world can work with
Am 25.01.2011 18:38, schrieb Robinson, Eric:
>> 240 mysql-servers?
>> why there is no consolidation?
>
> I said 240+ mysql *instances*, not servers. It's actually just 3
> physical servers (not counting standby cluster nodes).
240 mysql-instances on 3 physical hosts?
what crazy setup is this ple
On Mon, Jan 24, 2011 at 6:43 PM, Gavin Towey wrote:
> If you show the EXPLAIN SELECT .. output, and the table structure, someone
> will be able to give a more definite answer.
>
>
Thanks for the reply Gavin. I actually did place this info in my very first
message on this thread, along with my bas
> 240 mysql-servers?
> why there is no consolidation?
I said 240+ mysql *instances*, not servers. It's actually just 3
physical servers (not counting standby cluster nodes).
> > just need a way to make the same thing work with InnoDB.
>
> this is simply impossible
That is very unfortunate.
Di
Am 25.01.2011 16:56, schrieb Robinson, Eric:
> You say that like it doesn't mean a huge amount of additional work,
> expense, and complexity. We currently have 240+ master MySQL instances
> and are adding them at a rate of several per week.
240 mysql-servers?
why there is no consolidation?
> B
> nobody cares if they are binary replica as long
> as the data is consistent and ident
Like I said, I'm no expert on this, but my approach seems like the only
way to 100% absolutely sure that the data on the slave is in fact
consistent and identical to the data on tha master.
> so start another
> > There is a very good reason: it is the phenomenon of row drift. The
> > master and slave can appear to be in good sync, but often it is not
> > actually the case.
>
> ... sounds interesting; have you got any document explaining
> this phenomenon? AFAIK, the things that (silently) break
> r
>-Original Message-
>From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
>Meersman
>Sent: Tuesday, January 25, 2011 9:56 AM
>To: Reindl Harald
>Cc: Robinson, Eric; mysql@lists.mysql.com
>Subject: Re: InnoDB and rsync
>
>> jesus christ nobody cares if they are binary r
Am 25.01.2011 15:56, schrieb Johan De Meersman:
>> jesus christ nobody cares if they are binary replica as long
>> as the data is consistent and ident
>>
>
> Actually, I can see this being an issue if you're using LVM snapshot backups
> or another similar technique - if the datafiles aren't all i
> Why don't you use a Maatkit solution like mk-checksum to
> ensure that your slaves have identical data with the master?
I looked at Maatkit a year or so ago. It looked pretty interesting, but
then I started reading the disclaimers carefully and they scared the
bejeepers out of me. Warnings abou
On 1/25/2011 8:00 AM, Robinson, Eric wrote:
your whole solution is crippled because why in the world are
you killing your salves and reinit them without any reason daily?
There is a very good reason: it is the phenomenon of row drift. The
master and slave can appear to be in good sync, but often
> jesus christ nobody cares if they are binary replica as long
> as the data is consistent and ident
>
Actually, I can see this being an issue if you're using LVM snapshot backups
or another similar technique - if the datafiles aren't all identical you
won't be able to restore to any machine from
Am 25.01.2011 15:00, schrieb Robinson, Eric:
>> your whole solution is crippled because why in the world are
>> you killing your salves and reinit them without any reason daily?
>
> There is a very good reason: it is the phenomenon of row drift. The
> master and slave can appear to be in good sy
On Tue, Jan 25, 2011 at 3:00 PM, Robinson, Eric wrote:
> > your whole solution is crippled because why in the world are
> > you killing your salves and reinit them without any reason daily?
>
> There is a very good reason: it is the phenomenon of row drift. The
>
Interesting. I never heard of tha
2011/1/25 Robinson, Eric :
>> your whole solution is crippled because why in the world are
>> you killing your salves and reinit them without any reason daily?
> There is a very good reason: it is the phenomenon of row drift. The
> master and slave can appear to be in good sync, but often it is not
> your whole solution is crippled because why in the world are
> you killing your salves and reinit them without any reason daily?
There is a very good reason: it is the phenomenon of row drift. The
master and slave can appear to be in good sync, but often it is not
actually the case. For this re
Hi!
SQL Maestro Group announces the release of Data Wizard for MySQL 11.1,
a powerful Windows GUI solution for MySQL data management.
The new version is immediately available at
http://www.sqlmaestro.com/products/mysql/datawizard/
Data Wizard for MySQL provides you with a number of easy-to-use
w
Am 25.01.2011 05:37, schrieb Robinson, Eric:
> Is there a way to safely backup an InnoDB database using rsync?
Not without stop mysqld
Foregt it, do not try it and stop searching if you do not waste time
If you understand how innodb works you will see that
this is not possible by design
your w
23 matches
Mail list logo
