Recommended Setup for MySQL Replication

Hi

Thanks you for the great plugin!

One of my clients that uses this plugin has a high traffic site that logs to the {prefix}_wfHits table.

The database server correctly does all of this, but the issue appears when I introduce MySQL Replication.

It appears to not be able to keep up with the quantity of changes and therefore the binlog processes pieces out of sequence (all normal for MySQL so far).

Replication halts as a result of this with errors such as:

1062 | Error ‘Duplicate entry ‘51019’ for key ‘PRIMARY” on query. Default database: ‘dbname’. Query: ‘insert into wp_wfHits (ctime, is404, isGoogle, IP, userID, newVisit, URL, referer, UA, jsRun) values (1440369283.636250, 0, 1, ‘ÿÿBùCR’, ‘0’, 1, ‘http://www.domainname.org/requested/path’, ”, ‘DoCoMo/2.0 N905i(c100;TB;W24H16) (compatible; Googlebot-Mobile/2.1; +http://www.google.com/bot.html)’, 0)’

So my question is, what is the recommended setup for us hosts who have clients using your plugin? I would prefer to leave replication on.

I have found that some hosts prohibit the Wordfence plugin for this reason, but I’d rather not block this great tool from my customers

referenced link here: http://wpengine.com/support/disallowed-plugins/

Also another thread I’ve been watching on a similar topic: https://wordpress.org/support/topic/wordfence-doesnt-play-nice-with-clustered-mysqlmariadb?replies=3

https://wordpress.org/plugins/wordfence/