… big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right… becomes massively used. First thing you need to know about partial replication – you can do filtering on the Master or on the… you can see no matter which road you take with partial MySQL Replication there are things to be careful with, so if you…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with… the one that’s actually partially implemented is a pool of threads, which was originally coded for MySQL 6.0, but is…, it wouldn’t be a great OLTP web database too. MySQL replication is one of the core, fundamental features — and it’s…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… in the stock MySQL. Yet another way is using DRBD to get a standby MySQL server or at least synchronously replicated master binary… complicated – one may use partial replication, replication to different storage engine, add some tables beyond tables which are being replicated which all has to…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… error rather than stalling forever which allows application to become partially functional as soon as possible. This hack is needed only… out of sync with database content. This will sometimes break replication but if you’re just planning on using binary log…. Partially written .frm files or .frm being unsync with internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication IO needs are …MySQL also has broken group commit (which we have partial fix for) meaning concurrent transaction commits will need to be serialized. Second, MySQL…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… of my favorite MySQL configurations for high availability is master-master replication, which is just like normal master-slave replication except that you can fail over in both directions. Aside from MySQL Cluster… need fast failover, you need some way to at least partially emulate a production workload on the standby machine. PS: I…
Post: Percona's Commitments to MySQL Users
November 5, 2010 By 10 Comments
… slowdowns over the last few years. This era is over. MySQL has never progressed so rapidly towards better features, better performance… for monitoring, query analysis, replication management, and other capabilities. If you’re worried about Oracle making MySQL closed-source, stop worrying. It… staff and over 900 customers. We think this success is partially because we’re fair to our customers. Our pricing model…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
… search results. I’m wondering if that is replication lag or issues with full text search index … sites have the same mistake (or shortcut) in MySQL Full Text Search configuration – relaying on minimum keyword …to search a very complex query and just get partial results if it can’t complete in time. …
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
… done, being pretty bad for MySQL Performance and concurrency ? The reason is – replication. In MySQL before 5.1 replication is statement based which means… – INSERT … SELECT actually performs read in locking mode and so partially bypasses versioning and retrieves latest committed row. So even if…
Post: Looking at Redis
August 27, 2009 By 27 Comments
… means if you crash during the dump you simply discard partial file. I also liked full pipelining support in the protocol… specify from which node to replicate and this is it. It is even more simple than with MySQL as you do not need to deal with snapshot or binary log position. Replication is asynchronous and…
