multi server setup - removing old clients

Discussion in 'General' started by craigfanman, Apr 7, 2017.

  1. craigfanman

    craigfanman Member

    hi. I'm preparing for a migration, in testing it seems like copying clients takes a long time so I'm trying to remove old ones, I have like 6k clients but only really 1k active.

    So my plan was this, go through and if site was turned off for more than a year delete client (jst delete row from master db). However if I delete this from the master database, it does not seem to replicate this to the other nodes. So would I have to run this query seperately on each server? Cheers
  2. Jesse Norell

    Jesse Norell Well-Known Member

    maybe you could resync the clients after you remove them from the master? if that doesn't do the job, you could probably write a little script to use the api and apply the same logic.

Share This Page