Advanced MySQL Replication Techniques
Subject:   Multi-Master to Slave
Date:   2009-09-07 14:07:06
From:   Jim Butler
Please tell me if this variation on the circular theme is possible. I have multiple application servers doing high volume writes into what is essentially a log table. This is currently a master and we use simple replication to a slave that we use for reporting off these logs.

Let's assume we use similar techniques as this article to ensure there are no auto-increment primary conflicts. Would it be possible then to have each app server writing to a separate MySQL database (to speed up the writes from the app server's perspective) and have all of these "masters" replicate to the slave reporting database? Logically, this works for my application since the app servers themselves never do anything with the log data (other than write it).