… 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: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…. MySQL also has broken group commit (which we have partial fix for) meaning concurrent transaction commits will need to be serialized. Second, MySQL… use MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication…
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: 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: Master-Master or Master with Many Slaves
April 6, 2007 By 7 Comments
… for master-N-slaves systems but I find Master-Master replication much better approach in many cases. Kevin Writes “It requires… to handle much more write load. Especially keeping into account MySQL replication is single thread it might be not long before it… likely same data cached in their database caches. You can partially improve it by load partitioning but still it will not…
Comment: Master-Master or Master with Many Slaves
April 7, 2007 By 7 Comments
… application error which deletes/trashes all the data and gets replicated to all the slaves ?” Sure… but this is a non… to handle much more write load. Especially keeping into account MySQL replication is single thread it might be not long before it… likely same data cached in their database caches. You can partially improve it by load partitioning but still it will not…
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. …
Comment: Master-Master or Master with Many Slaves
April 7, 2007 By 7 Comments
… avoid problems in case there are bugs in MySQL replication) If properly planned the partial capacity should be no more than a few…
