List:General Discussion« Previous MessageNext Message »
From:spameden Date:October 16 2012 8:04pm
Subject:Re: Odd Behavior During Replication Start-Up
View as plain text  
Also, forgot to say you need to shutdown completely MySQL before rsync'ing
it's data, otherwise your snapshot might be inconsistent thus InnoDB fail.

Also make sure database shutdown was correct in the log.

2012/10/16 Tim Gustafson <tjg@stripped>

> > load data from master never worked for innodb.
>
> And the suggested mysqldump command does not work for MyISAM.
>
> Either way, the suggestion is a non-starter.  I could "flush tables
> with read lock" and then do a mysqldump but again that would take
> hours and all the databases would be read-only during the whole
> operation, and even the read-only performance would be poor.  I'd
> really prefer not to do that.
>
> I'll say again that the MySQL documentation specifically says that ZFS
> snapshots are a good way to make backups of MySQL databases.  Is the
> documentation incorrect?  Or perhaps does that also only work for
> MyISAM tables?  If so, that ought to be called out more clearly in the
> documentation.
>
> --
>
> Tim Gustafson
> tjg@stripped
> 831-459-5354
> Baskin Engineering, Room 313A
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

Thread
Odd Behavior During Replication Start-UpTim Gustafson16 Oct
  • Re: Odd Behavior During Replication Start-UpReindl Harald16 Oct
    • Re: Odd Behavior During Replication Start-UpMichael Dykman16 Oct
Re: Odd Behavior During Replication Start-UpTim Gustafson16 Oct
  • Re: Odd Behavior During Replication Start-UpMichael Dykman16 Oct
    • Re: Odd Behavior During Replication Start-UpTim Gustafson16 Oct
      • Re: Odd Behavior During Replication Start-Upspameden16 Oct
    • Re: Odd Behavior During Replication Start-UpReindl Harald16 Oct
      • Re: Odd Behavior During Replication Start-UpJohan De Meersman17 Oct
        • Re: Odd Behavior During Replication Start-UpReindl Harald17 Oct
          • Re: Odd Behavior During Replication Start-UpJohan De Meersman17 Oct
            • Re: Odd Behavior During Replication Start-UpReindl Harald17 Oct
              • Re: Odd Behavior During Replication Start-UpJohan De Meersman17 Oct
              • RE: Odd Behavior During Replication Start-UpRick James17 Oct
                • Re: Odd Behavior During Replication Start-UpReindl Harald17 Oct
                  • Re: Odd Behavior During Replication Start-UpTim Gustafson17 Oct
  • Re: Odd Behavior During Replication Start-Upspameden16 Oct
    • Re: Odd Behavior During Replication Start-UpShawn Green16 Oct