1

Read from one MySQL server, write to another

view story
linux-howto

http://serverfault.com – I'd like an application to read data from a read replica of a production server, but write changes to a separate server--a sort of change log. Is this possible? If not, what should I be doing instead? It's important that changes on the production server synchronize with the development server in realtime, if they're separate. All production tables will be running on InnoDB. (HowTos)