?? not sure i understand Platonides. I'm editing a template on the
slave wiki to accommodate for the different IP address of RSS feed which
makes
another record on one of the tables which creates a duplicate primary
key and so breaks the master-slave replication. Not sure what you mean
by 'having
a separate php instance . . . . . '
On 6/27/12 6:58 PM, Platonides wrote:
On 27/06/12 19:57, chris wrote:
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 ?
What? Why do you need to have different data in the slave?
The point is
precisely that both contain the same information. Moreover, you seem to
also have separate php instances accessing each of the copies of the db?
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l