Re:Flickr-like ticket server in ~100 lines of Perl (~8k tick...
by jzawodn on Thursday September 22, 2011 @03:01PM
(#3027300)
Hmm. I see "ENGINE=MyISAM" in the code. Nowadays I can't stomach using MyISAM for anything I care about not having some sort of corruption. Given sufficient time and scale, I've seen far too many issues with MyISAM.
It'd be great to be able to specify that in the code so the user can opt for InnoDB (or engine of their choice). Perhaps a pull request is in my future...
Re:Flickr-like ticket server in ~100 lines of Perl (~8k tick...
by cosimo on Thursday September 22, 2011 @04:22PM
(#3027637)
I seem to remember that the MySQL behavior this is based on will only work with the MyISAM engine. In fact, Flickr is using MyISAM for this, IIRC. Anyway, your changes make perfect sense, so I merged them.
Will try what happens to the test suite with InnoDB.
It'd be great to be able to specify that in the code so the user can opt for InnoDB (or engine of their choice). Perhaps a pull request is in my future...
Will try what happens to the test suite with InnoDB.
https://github.com/cosimo/TicketServer/pulls
http://code.flickr.com/blog/2010/02/08/ticket-servers-distri...