Women in Technology

Hear us Roar



Article:
  Live Backups of MySQL Using Replication
Subject:   Replica requirements
Date:   2005-06-17 02:38:12
From:   leeg
Thanks for this article - very timely as far as I'm concerned as I'm about to put a MySQL-based app live :-)


What sort of performance does the replica server need relative to the master? It looks like the updates to the replica DB can happen asynchronously as another thread is polling the logfile, so perhaps it doesn't need to be an identical box to the master. But where does the point come that the backup is compromised because the replicant can't keep up?

Main Topics Newest First

Showing messages 1 through 1 of 1.

  • Replica requirements
    2005-07-08 10:53:49  ugob [View]

    If your slave is dedicated, it doesn't have to be very powerful, as it only receives Updates + Inserts.