holland-discuss team mailing list archive

[Brandon Metcalf <bwmetcalf@xxxxxxxxx>]

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
>>
>