I am running sysbench on a 3 node galera cluster with a DB that has 500M rows.
When running the benchmark I get a lot of “Err1062 Duplicate entry” errors that forces sysbench to exit.
I read somewhere that there is an option --mysql-ignore-duplicates=on that would fix this, but sysbench 0.4.12 on ubuntu oneiric does appear to support such an option.
My sysbench command line is as follows:
sysbench --test=oltp --db-driver=mysql --mysql-engine-trx=yes --mysql-table-engine=innodb --mysql-user=XXX–mysql-password=XXX --num-threads=256 --max-requests=73000 --oltp-table-size=500000000 --mysql-host=XXX --mysql-port=3307 --oltp-test-mode=complex --oltp-auto-inc=off --oltp-dist-type=uniform run
Is there anyway I can use sysbench on galera cluster without getting these errors?
I get these errors consistently and more and more as the time goes on. This makes using sysbench impossible.