List:Commits« Previous MessageNext Message »
From:Øystein Grøvlen Date:October 29 2008 7:11pm
Subject:Re: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209
View as plain text  
Chuck Bell wrote:
> Hi Oystein, 
> 
>>>> 2. I do not understand why the binlog handling is necessary in
>>>>    LOGGER::backup_history_log_write/backup_progress_log_write.
>>>>    Please, explain. See [1] below.
>>> We must ensure the entries written to the backup logs are not 
>>> replicated to the slave. They should never be replicated. See R06.
>>>
>> But can't you turn it off for the entire backup/restore?  Do 
>> you have to turn it off for every write?
> 
> If we don't include it in the logging code, it is possible for the changes
> to be written to the binary log because restore (or backup) complete befores
> the final log entries are written. This way, we are ensured the backup log
> entries are never written to the log. See the other forms of logs -- they do
> exactly the same thing.

Seems reasonable.

> 
>>>> 3. Please, verify that restore may not enable slave 
>> connections after
>>>>    restore when it was disabled before restore. [3]
>>> This is ok. We set disable_slaves = FALSE regardless of whether we 
>>> turned it on (set to TRUE) or not. So this is safe to call 
>> without a 
>>> guard or checking to see if it was set to TRUE previously.
>> And there can not be a scenario where a user has disabled 
>> slaves prior to restore and do not want to have them enabled 
>> as a side effect of executing restore?
> 
> I don't know. I suppose it is possible but it was never considered in the
> lengthy architecture discussions. If you can think of such a scenario where
> a user would indeed like this, we can add it via a feature request (bug
> report). Feel free to do so if you'd like.

I do think I am the right person to do that.  I do not even know whether 
it is possible to turn off slave connections to a slave, and why you 
would do it.  I was just asking ...

--
Øystein
Thread
bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Chuck Bell29 Oct
  • Re: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Rafal Somla29 Oct
    • Re: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Chuck Bell29 Oct
  • Re: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Rafal Somla29 Oct
    • Re: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Chuck Bell29 Oct
  • Re: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Øystein Grøvlen29 Oct
    • Re: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Chuck Bell29 Oct
      • Re: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Øystein Grøvlen29 Oct
        • RE: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Chuck Bell29 Oct
          • Re: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Øystein Grøvlen29 Oct
  • Re: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Rafal Somla29 Oct
    • Re: bzr commit into mysql-6.0-backup branch (cbell:2720) WL#4209Chuck Bell29 Oct