holland-discuss team mailing list archive

[Brandon Metcalf <bwmetcalf@xxxxxxxxx>]

Running _faster_mysql51_metadata() in
plugins/holland.lib.mysql/holland/lib/mysql/schema/base.py, as
expected, shows a mixture of tables and therefore '1' in the
is_transactional column for those that are InnoDB and '0' for those
that are MyISAM.  I haven't followed the code any further at this
point.

It seems like the code might be seeing one transactional table and
deciding to use --single-transaction based on this.


On Tue, Jan 25, 2011 at 8:36 AM, Brandon Metcalf <bwmetcalf@xxxxxxxxx> wrote:
> Below are /etc/holland/holland.conf,
> /etc/holland/providers/mysqldump.conf, and
> /etc/holland/backupsets/daily.conf.  First, I show the session where
> --single-transaction is going to be used along with the count of
> MyISAM tables in one of the DBs:
>
> root@foo:/etc/holland# mysql -e 'show table status' flow|grep -c MyISAM
> 48
> root@foo:/etc/holland# holland bk --dry-run daily
> Holland 1.0.6 started with pid 15797
> --- Starting dry run ---
> Creating backup path /archive/dump/holland/daily/20110125_063352
> Estimating size of mysqldump backup
> Estimated Backup Size: 50.00GB
> Starting backup[daily/20110125_063352] via plugin mysqldump
> Running in dry-run mode.
> Initiating connection to MySQL
> Stopped slave
> MySQL Replication has been stopped.
> Using mysqldump executable:
> /usr/local/mysql-5.1.37-linux-x86_64-glibc23/bin/mysqldump
> mysqldump version 5.1.37
> Using mysqldump option --flush-privileges
> Using mysqldump option --max-allowed-packet=128M
> Using mysqldump option --master-data=2
> Using /bin/gzip compression level 5
> Wrote backup manifest
> /archive/dump/holland/daily/20110125_063352/backup_data/MANIFEST.txt
> Executing: /usr/local/mysql-5.1.37-linux-x86_64-glibc23/bin/mysqldump
> --defaults-file=/archive/dump/holland/daily/20110125_063352/my.cnf
> --flush-privileges --max-allowed-packet=128M --master-data=2
> --single-transaction bigflow
> Executing: /usr/local/mysql-5.1.37-linux-x86_64-glibc23/bin/mysqldump
> --defaults-file=/archive/dump/holland/daily/20110125_063352/my.cnf
> --flush-privileges --max-allowed-packet=128M --master-data=2
> --single-transaction flow
> Executing: /usr/local/mysql-5.1.37-linux-x86_64-glibc23/bin/mysqldump
> --defaults-file=/archive/dump/holland/daily/20110125_063352/my.cnf
> --flush-privileges --max-allowed-packet=128M --master-data=2
> --single-transaction mysql
> Executing: /usr/local/mysql-5.1.37-linux-x86_64-glibc23/bin/mysqldump
> --defaults-file=/archive/dump/holland/daily/20110125_063352/my.cnf
> --flush-privileges --max-allowed-packet=128M --master-data=2
> --single-transaction newflow
> Restarted slave
> Backup completed in 0.04 seconds
> --- Ending dry run ---
>
> root@foo:/etc/holland# cat /etc/holland/holland.conf
> [holland]
> backup_directory=/archive/dump/holland
>
> [logging]
> filename=/var/log/holland/holland.log
> level=info
> root@foo:/etc/holland# cat /etc/holland/providers/mysqldump.conf
> [holland:backup]
> plugin = mysqldump
> backups-to-keep = 1
> auto-purge-failures = yes
> purge-policy = after-backup
>
> [mysqldump]
> extra-defaults = no
> mysql-binpath = /usr/local/mysql/bin
>
> lock-method = auto-detect
>
> databases = ,
> exclude-databases = ,
>
> tables = *,
> exclude-tables = ,
>
> engines = *,
> exclude-engines = ,
>
> flush-logs = no
> flush-privileges = yes
> dump-routines = no
> dump-events = no
> stop-slave = yes
> max-allowed-packet = 128M
> bin-log-position = yes
>
> file-per-database = yes
>
> additional-options = ,
>
> estimate-method = plugin
>
> [compression]
> method = gzip
> inline = yes
> level = 5
>
> [mysql:client]
> defaults-extra-file = /usr/local/mysql/data/my.cnf,
> # user = "" # no default
> # password = "" # no default
> # socket = "" # no default
> # host = "" # no default
> # port = "" # no default
> root@foo:/etc/holland# cat /etc/holland/backupsets/daily.conf
> [holland:backup]
> plugin = mysqldump
> backups-to-keep = 7
>
> [mysqldump]
> databases = bigflow, flow, newflow, mysql
> estimate-method = const:50G
>
> On Tue, Jan 25, 2011 at 8:21 AM, Andrew Garner <muzazzi@xxxxxxxxx> wrote:
>> I haven't seen that behavior.  If you have an example mysql
>> schema+holland config that can reproduce this I would be very
>> interested to see it.
>>
>> ~Andy
>>
>> On Tue, Jan 25, 2011 at 8:11 AM, Brandon Metcalf <bwmetcalf@xxxxxxxxx> wrote:
>>> I'm finding that using auto-detect with the mysqldump provider
>>> --single-transaction is being used against a DB with MyISAM tables.
>>> Anyone else seeing this?
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~holland-discuss
>>> Post to     : holland-discuss@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~holland-discuss
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>