May 25, 2012

Post: Percona Live MySQL Conference & Expo Was A Great Event

…, but more importantly, the mood was strongly optimistic. I think a lot of people arrived … agreed that their target audience was there in large numbers and actively engaged. The exhibitors …development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and better…

Post: Falcon Storage Engine Design Review

…by changing meta data (it is not implemented in MySQL anyway though). Very interesting to see how …FOR UPDATE. This is also why Falcon has Optimistic locking concurrency which can give you problems …. Speaking with Oracle and PostgreSQL developers it looks like they all acknowledge this problem and …

Post: Test Drive of Solid

… for MySQL Beta 3 so I decided now is time to take a bit closer look on new transactional engine for MySQL. While… bug which hopefully be resolved in further versions. Test 5: UPDATE / SELECT FOR UPDATE in OPTIMISTIC mode Solid optimistic: Session1: mysql> begin; Query OK, 0 rows affected (0.00 sec) Session2: mysql> begin; Query OK…

Post: KISS KISS KISS

… we tend to look at the required capacity and data size within current horizon. In many cases even with super optimistic assumptions application… pushed to production, hacker break in, data center power failure etc. Google guys tells us single MySQL server on a good hardware…. Summary: So am I denying all MySQL industry practices (which we also covered in a great depth in our book) ? Not really. I…

Comment: Product to try: MySQL/MariaDB-Galera 0.8

… Great that you are finally looking into this. I’m personally also very excited about … application design). However, it is more solid than MySQL semi-sync in that the transaction is guaranteed to apply to… the transactions. (I suppose this is a variation of optimistic vs pessimistic locking problem.)…