May 25, 2012

Post: dbqp and Xtrabackup testing

… basically, we take advantage of Pythons unittest and write classes …prepare call to run without error? Boom goes the dynamite!: # prepare our backup cmd = (“%s –apply-log –no-timestamp –use-memory=500M ” “–ibbackup=%s %s…suite=xtrabackup_basic –basedir=/path/to/mysql –xtrabackup-path=/mah/path –…

Comment: Alternatives of PHP ?

you’re right, pythons connector does not support server-side prepared statements yet. neither does the pure ruby connector (ruby/mysql), but the one built on top of libmysql (mysql/ruby) does. jim

Post: Alternatives of PHP ?

…and ‘var_dump’ 3. Unpredictable memory consumption – it’s easy in processing of big files … my requirements: – Stable binding to MySQL, support of new protocol with prepared statement is necessary. – good …support MySQL narrows the list to Perl, Ruby, Java, C, C++, even Python supports only old mysql

Post: Fishing with dynamite, brought to you by the randgen and dbqp

… the test: ./dbqp.py –default-server-type=mysql –basedir=/path/to/Percona-Server –suite=randgen_…s –parallel option. I also wanted to create multiple schemas and we did via a little randgen / python …setup, we need a crash / failure during the prepare phase of the backup. Interestingly this only …