So here's a question, particularly for POCs. Is "master" a problematic word when not juxtaposed with "slave"? My guess is not, because the word has a much broader meaning in English, but I'd like to hear your thoughts.
Show this thread
-
SQL replication can be accomplished multiple ways, SQL log shipping is just one of them :-) But either way, primary/replica works just fine. You can still query the replica (read-only) and changes to the primary are replicated to the replica.
The thing with master/slave is that it means... nothing. Just some vague notion of hierarchy. It is used in so many systems with different meanings that it has lost all nuance.