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?

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.