I've got a master slave wiki setup. I'm also using RSS extension to
collect multiple feeds from different sources (the feeds are also being
replicated on other machines in both environments so the feeds are the
same). The problem is that the primary site is using a different
private ip addressing scheme than the secondary site so I have to do a
minor edit change in a template on the slave to point to a slightly
different ip address which means the database is now no longer the same
as the master which creates database errors - in this case duplicate
primary key errors.
Is there a way to do this - possibly doing a raw SQL update on the CLI
in the right table on the slave so we don't insert another additional
record in the table ?
thanks,
Chris