Database-Replication-diagram.excalidraw
==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠==
Database Replication — Leader-Follower and Multi-Leader Topology
Text Elements
Leader-Follower (Single-Leader) ^lfLabel Leader ^leader Writes go here ^leaderWrites Follower 1 ^follower1 sync replica ^syncLabel Follower 2 ^follower2 async replica ^asyncLabel Reads ^reads1 Reads ^reads2 Follower promoted to leader on failure ^failoverNote Multi-Leader ^mlLabel DC-1 Leader ^dc1 DC-2 Leader ^dc2 conflict resolution needed ^conflictLabel Follower A ^followerA Follower B ^followerB Lower write latency per DC, conflict complexity ^mlNote Replication lag = eventual consistency window; read-your-writes via sticky sessions or sync reads from leader ^lagNote
Excalidraw Data
Text Elements
Leader-Follower (Single-Leader) ^rftcIiJn
Leader ^IwrCzfLA
Writes go here ^EyeZq3Xw
Follower 1 ^q5Ct4xEW
Follower 2 ^R82PtskP
Multi-Leader ^2fsJfVxk
DC-1 Leader ^dc1-text
DC-2 Leader ^dc2-text
conflict resolution needed ^Em77OaYF
Follower A ^pgKZUwQ0
Follower B ^81SGEAz8
Lower write latency per DC, conflict complexity ^ml-note
Replication lag = eventual consistency window; read-your-writes via sticky sessions or sync reads from leader ^lag-note
%%
Drawing
N4KAkARALgngDgUwgLgAQQQDwMYEMA2AlgCYBOuA7hADTgQBuCpAzoQPYB2KqATLZMzYBXUtiRoIACyhQ4zZAHoFAc0JRJQgEYA6bGwC2CgF7N6hbEcK4OCtptbErHALRY8RMpWdx8Q1TdIEfARcZgRmBShcZQUebR4ARniaOiCEfQQOKGZuAG1wMFAwYogSbghSADMobABJQgApLn4S2ERyqCwoFOLITG4AFgAGFsgYbh4RgsgKEnUJgFYADniA
NgBmAeWeBYSATgX1hNGpBEJlaQmknZPOzG6JABkQ4iZnADE2fHw2CiZUAAUAGVCBxlMFnM9cK9SABKHolSqcKAgoziVAJADsJyRWXeuH0hHw4zQx2m0C6AEEiMouBJgtUEZBGKQoOYCNTznT0FA2HAmRBmFBSGwANYIADCXzYpHKAGIEghFYqBZpcNhRcoRUIOMQpT9ZRJhdZmHBcIEsgLKkT8EDYMFyoIPAKhSLxQB1OaSbhk3oVYQXDjhHKkk5
89VqEkYoZTP16LK4UFMWrEbgcITfMOkc6gggAFS65ShMI+Xx+f1IgJBYIhxaY8JOuCEvIASuFCGjuMKhAgTkQgwAJM4XB4Y+ILE4s1icCaTpjTjgAOU4Ym4qwWAyWex4w2x5NBr36ElwQwFhGYABE0p1U2hKgQwidXWKEHaYA6JE6yo2a+jYyUwgQW8MROLVhDgFMQ1QXIAF0cXIDIUzTDN8BObVdSDZgoPTTNyU0YRdQAUWCDIsig2CTiEOBiFw
G8fUxTEBi2BJVgYnY9z9ftRWQ3C/UkUIC3uR5QW4u8H17ckfg1IDuHvfBH3JcgKEE0cIAgAoAF8WiKEoynpF43nw/pbngdEKgQbAol/AUjwxYYTijVZ/xmL0fXs8lJGHS40AWVYn2FF99RleV9kxBJsB4VV1U1dC9WlQ10DlBBMUqBZKkqK0bTfD90C/VN/LdBBPWIeY0HWNCA0kTCoN9Epw2wSMfRjOcWHYbk+HJKc2uXDhV1JdYFkmTE9kxdYO
N03UsHKXAEjPS9rxksT5Ikv1n3FbKzLygVrHBP8nwQRaQPJMCqMgvI4PJSoEIQJC0Bw1DFII4hqp4h6/XwnViGI9JMmyc7KOo2jDqxRjmNYzF2L7ETXpOfjmBU4SOFE1A5IUzi2Gk4DUYQTTtP3YCIFqChSAlIxKkeSkBTaMy7m6E5bISBYJ3JKNMWciBZhK70fKGbR1iWQ4nLChjRqY2GvNHBIVkxZm/VposDNlHFkVRdFGeVvECSJKNasgWnOV
pcoxCyJgBRZNl3AN7kIEJYhiAdArAvikKRvCyKTjVDUTt1IKEugcgOFNc1fsy74NsdL5v3JNaitc0NHr8Krgx9MMzQa2AmvZ+MoiTUhbtQe6sxzDh80LJ5Fe25s2DbVhOzQbsVpKfsECHc5vLHG5OvnNrZy71rOB6vreCGdcBn5ga9hOA8puPd393m4I6KWtGAIC9b7U2yP8vJHacvZwDgN1iATog4hyIuv0roJG7gMLhOMOTu6UI9p7vtIv60Ao
8kqJopeMQYpiuxwaQ0ktDJ+vEShwwRmAlG4k+wY3FFjOBilKAqXKOpYoWkCg6UgHpdAhEYAIAAFoAEd1gAA0qAmXaEaQs9MfRMwctwbcJxOalVQJiFYA0eD81WAMRiTk9j83Fm3SW6xtAy1uGXdA7psydGYKgZQbBUCeUCFaFWHY1ZH1xFAfEhJiQp3JPrGk1tjadCVn3C2HITEdD5C6NekpnYSAVK7CKUUvaxV9h0AOQcLR00ullDeEdnSOw9HH
I6fptSBkfhEuqadGqkmauSbOiYgx51vs/ckMpi6l3uOUWRahwiKOUaopAjYq4100V2UgPYoaDglj6ccLUFy9z9F1AeK41arD2HsKWg0BhH2nrZCAuB1hzSvIvQ62NQmviCZ+Le21rJoH3gdQ+oFtSn3PvBa++c76RKei9cBb0SgfSIiRX6Wzv6Az/iDQBLE2ILHGpALiMMPICS6IjZG0zJIIKmcgyJqDpFqVxtg/G5QkTfF+EwBIzgjJU1MuUQIl
ld5lPJLZdyfodZLHZmw7mdl2aeVEdwBY+8HFeOcTwSoewEBMXcTFJ65LEoIE0JUTQB1Q62jmblBZMzirsI6vsxOhzYmQHqgk6M7N2ntWad1Tp3B+ZDCOOuHpU9JrDNwAMcZC0kHLRmeHeZISd5LNQCs4G6zwJnU/hfRE11dmZMFQ/LCrz3qv3OWRf6Vzf7AwAWDB5TyIAvKObDd5QkYHfPRpjWS4kQXFBwaUAmJCFgSigAMTAhF3TwpoTyOhaLiW
yxKDrEarDwkbG0HsIYI0FgHESJuMekiPINNJJibQ+a9ZAs+JCisGJ1FZFVm5DWuitYGPjnLKkNiJBmNNi1Kx+ArblFtvbVFq0yVOMSpS6ltKPbRW9nFA03iTRmj8Ry/V3LDXLsKnyvFR8olJydSOuJEYM6JKzsiVJyYMkQNFdmfwuTVIdvLP8Wa5TWztjrqgBudSW6No7q2hg3cZxoAFSUKVg81aPJ4TwCGnc/RDOmgsLVkydUrwEA4k9goeVGt2
twU1azjobMtdBa1kAr6IQ/ccyAsVhV7JOa6n67qrUAy9YfH1QC/V1ORtxyAUCPlhv+U3X5RHG4ccBXkiQGCwBYNjWCiQEKAOkB4LCtgxkjEIokEiqyVH6GIYxQWn02Li1czcgS6DJKZmMogHKddNLNVbo8Qy1dHnmWsvZTiQJ75N5ntXhe8JSGOOVWFUfMVT6JUyoQ7wVLS45WkiYoq8tE9VWHmmqsAjCA/7hqiy+MjW0fxUeWftM1dGLVnw9ZfW
1bGKqfS4/anjn034XJayUH+QNhOg1ExDR54nnWQJDVAT5UbdU/MjcvHGmC8Y4YJi2JYPAAAK2RRTbczTTHNfpbI7Fg4W/1uLuBs20EMJYY0dyVuWFWgYIiRz0RbVI1T6B/1QsrHPS+GiwMJFe5dZEejtaGNHfcOdE7fpTsseyWd470ALodtHFde6KVUu83Snd7njSB0PSHULYcuXkciyR6Ljn71xaFTExL8TksJCSXGV9uc7WfogNkn9+A0ESF+1
2gHJQmwgdruiCDoD6lEtJE0vuLTEMZdQ4MPY/CenlX3Gq6amIStlbk1Tyr5PquUb3vV2jfoT4Ma/q1nZ7X77PRiZJiApyvpuo/oxwTw36KjfueN/1gaC7dakzNuby34FLdgQtgFykgXqc04UbT6BzQigoM4YI0I3iVBhcwGAvVDvTVICnmydn2Y6xYg59hbM3vt1WLFwUmPgrONCm7PHniAuE98STgJZPwvBKjuel8l7WklBvQl1Oj6das5KHANg
oJ3f5F6GABfi/nLFCGNMMATGl8b7AM4KvO/a8b5gtMJj9fzRQEpIX34nloRTcgJkYgl+U834Jsn34Ap8C4DZfgbgOC23fcFFz2wFQECB8HZCZGYyBy0VGAN3FHcxcTCjcWmHj2ZHg2lXl1lV6nRH4X5gFixFg1w2PCWF1z+Sjwq3Xl7wNX7xF2NRoyhxKEt2awE0ujazv39E60dyD2d143fkuT9CGxuRE19xAU4hgSd2k1DSRnm2IwDQU2kKUzP1
ZAACEDxQRlA2CH8VDdQ1DXoY0E91sC8U809FZnBKgDNQggD89jwr8qFc1rNS8fRy9yQrs0B98+JoNa83MAs5QlhVglgEA9hitfN6VPoCcfFidLRSdOVKDT1qDYDY4ad0sE5ok70RV69CoyMaJmBPJt4/QktJ92YZ859yIN9l9ehV8wB19F8t8yjig3DF9D9qiT9/Jz8n9r8XgNDdQ2iKAX9DD38+wv8ghf8N8KQACLDeoQCEAwC8AICIAdE+1SRd
Z4j4DfD/DAj1MNMMth9UD+5MssCJgR4eBVcZYGICsZ4k89gSDFMatTdo5Vl6DIBGC+CbVbc2DONOCucXc+t+MPdPUvcm0fdgEJspcJMuCJDZtZMyDnk5Cw8Mdz8tDHAwROjiAESdCjk9C408FzJoRnA39U908YQrCk8bDi8eYmE0AlglgK88VKTq9RxSVCp4CFhsA0pVggi8Jt028sceRwjg5Iju9oicoKc4j0jB9wlr14sGc9VycsiciBR8jM4T
giifjajajKiYDKij8YC1TaSd8qjehj8DSWjWRujeig1yQH9TSOjrCi8Bjv9hjF9RjVI2xoQcgYC5ioDHD3SY4mSWTKg2SNiUC4NdjtjgyFxlcm12IlUhh/VCCk9KYp4F5StSCZCUVqMzcHjj56MmDfibdWM3iDkPj2NuDes3dnjIABDvVASxMQS2DwTQ9I8ZCpJEF5DjSoBUSkTzS/RNDVDOzA9vgMTE9sTiBcSbDTCgMTMs0RkSSrNUAbMxgJhN
xqT5VnMZcTUvDuSPNmTWT2T3pOT/NNyO8Ij/FL4wshTjcB8wlEiJT6dUij4Y5MjQg5Tx904CilTZ8VTSi9SNT9Tigaid91gKjfzN9mi4STSbCzTiTbSLSuiILrT+zizP97S0A/8nTygXTmt3T5iqlFjvSG8/Y5Rtz/TitkCtjFcMCOl9jSQtxAiDhHlYytdjwlCrjWyTc9o7iGsLdszyy5jWCuyR9CzUincviyyBsKzrkqy7kgT/cxCwSQ9ISmyY
TGyFChR4Tez1D+L79dQOyNKELByDCdNEwfgWRRzoK5ZTMoL+i7CMQWdyTeBALly6sG01yEhbKMdGTvCEBFUEgjhW8DzG8eSD0+STzEQzyIsRSY4h9ad2CUiappSYiIBZSZIXzxUWdCiPz58vzF91S9StSsqV8NTnBXLgLDS/y2yrTb9NKMBYLn94LpyzKm5Bif8UKRj5YJA4ARR9A2AbxUBOBYEiQRAl1Ade0cLow8KPLNykpvLfLSKKL0C2k0CI
zUASUXsBl9gzj1UJQWLYS/Q0ynLVp7joqnixLeLXiqr3ihKuCRK+N59T9KyRspKazRCpCqr6yFKFDmyUyVKohlD1LkSdLdDVtQUDL0BKVmAGhKgAA1TAbiahI7PJWczcBwxDHFcUoYAYFtNktiAYQRMaWDQld7RDa4WDNq9AAAWQzDZEhArgHQWP/gHQh2HTSOMS5HKAZBCp2JnVhx5DsQ3ICo82VCVCGsgE9hCJ9nb15KPSiKqwo0vISPYRvNis
zIVOfROBSQ5ztzyO/VzD5yBQpvwCprrAsV2oqVAwlxqQ+qTFbkJpgzIqSIWt2KWoSB3C2B4X2A1xw0YqTwvG2uUvivPNlpoNq3XI4vNwYO4pOpYxvgLI4Mus+J4P62YP4Ikoet9T90m1evkper9sWxbJ2pHxU1UjjzW10gJmIGwBhThThsRQsgs3RxO0GHsxZjXFRuvPnNODXN8j5oIoQHBhjD8tCO8PSipWIE0GPSN0DviKitQA9oEtvLiqySZz
fLmtDJQyy1QFYhB2xUZkGS9pGUIl9vK3iJlspxGVoIzKOojqTpePzPOsEuwiuoTpVLupTu90evTtrMzvhhk2zqPtkIj2xn0tLvKHLphXlmrtoQRusoGHLTsqbr9BcNQHuxbQrT8KESOCGA3G6TpI+xJqBQvAlCKtQCNp7RRFGpBwZqHR1i+wvxRwgEnWNuQyYC5robR2FtFLgM8r7tPGCPxwlqCqloFJPoiocWnsVtvQXryKXsVOSXZzSU52LJ5x
1v53QAIaIZIeA2rjNuqVqSlygxcrlwdoV3tqYcdvXpZ34TZMCOBM9sK2PHeEPv1w4dmQSovKDtuIOs4vDqax4qjoUY60dQfvjtLJup4vurfrTpEKblkq5zet/qcc+uuJQRjwAOLuBuAYkHLoMyrsnLMnMzTNnL8ORo3tboVvboJvbi7vcqdkmt7oYn7t4a5P5rlGHr2FHvHtccnucentnrpyVuipVpSxXvIqMcwKHlouWFrwOA2umgAHFHGoTnHh
Hcj3H2LPGw7Hir7cyb7o677Y6gnizrreCTrwmAT36onnkYniy4mvkEmlLAGgatMQbEqIpnBwHcmOhjsShbJulin4GShEGtxtA/D1hR5OFdhfJsNIFoMsRPsjF8HCGeBiGaawcRrgdQdhrB19FqH4WYc6GGGzZmGkduabYSBF17EJrmm6m2YeGOS/NB7DzJau9Tye8A7T7IrxSOt+m0jBm0q1a5H302ClGS5daAC1GkWNGd5TbxcdHLbpcbbia7a6
816qKN6BkBga11henSg97cABwFmZCHyJ7T69qQ71nMzjrr7mM+KEKAmHc47Dmn7brPdBDqyP7nrQTYms7bnFnEnWLo8VHgVHn9CMnLLU9QHnAsmiT6qrKG60Ba8/nSm8VlgcH9ryDHFanuGB7xbGWBHmXQrWXwqVmp6YsuWJHlbpHVbyRlTMrF81SgK8q62d8U3cqmijSwKL84LKqw2BRLSu3X8ZzhmTGdjwzzHOEeAeFelMMZnjxagDXvqMjjWR
TTW6DL6fHI6bWncLqDmX4QnjmrWIBTn/43WLmA0rng1v7JCfXFKAGnHVLfrtC+yncezH3dL7ogHcECZCJ9AGIAB5XAAATQcYgezSgbjY3smDspbYQfCSWGbVYh6RxpovVZHlTd4DwYAPjEqCIEskmKdGbDagAB0OAgwgJkrUWyHgd2YdFGacXodaHWa4cTZGHObiW6HeR+Ru75RqWGm6Wxbd1+ajzgqOm2WRHqcFay2x9F6J8ZG2cEwNahXtaRXA
2sOcOoA8OvgCPOBiPSPXhi2RlpXRrJdnr9GFXDHTHjHlXFrzGJ3LHKTJ5Nc7Gk8Gh53/ai3Flg7V20jLXtnrWzrbX7cutgmzlQmTnX6znImbHons7xDvX/X5Nb3FmlJA20mnnQ2PTO0mBKRDNjNzKpz8nrJEb/mFzqKk2nM0PXNqnOHJqvNN0+O+HamWU2V2HrRC2+99OOXEi69R8pTpPXzZOLOe4RnBvKKh4XsdhK0Z2k8ABpVzqrlx0T/Tldi+
7zrZ63HZ/xwLos3dkL/d3zw98L4985qLy5mLuSy9iE+J31+56NYNzEgmOAZQabohAAVQoAAEVaW8v4aOaIB0Vpnm7SQi1nCS09h4gekIZ7shEmYcaHP3CXLm0MO/0yw/tUAEyKO6aKGKPaPMyWbDYmPzFCXWQ2PGPUcyX67034DaufN6umm/YhPBGWXBT3PeVOXkjy2BnK2hm5Oc55HNa6olPf1yhBd/h0eTaxcjOLbINrb25FWh2rOzHVWWInJf
JektgpuRlHg5u5blmPOPGAJDrVv12D2/H+e6dAm2CjnE79uj3blIuZKzuvWLuGy/6/X87lMUmi6P341wUUeKwlCcvo2CvLNrKim7KpYyvstVybbKu5aqecc6u9z6Wc2qWmuQshGl2OvRHS32epOpGZOq3Rm0sFfR3VWBoBZDh0aGKnORkybtf03debi1mDevHNnjf9vTeY6Leqqrfn6XXJL7eM6Au+I4v3f/687lLvesSlgEggRZnCJKQjBiCQO0
LCmAfMUfRgeYPEibsjixolUtwtgjg68KnJZEeaHhe/f/hmLabyGMXERwcqHcex1Sf6H4cWPgyWHX+2GKWanmnqfs2Anenky35JM9G+83MRpJ16759+uhfEoOrT56KcckorZHpl0rA38pWEvMDMZ2i6mdZe5nEdkN2HZhkxmWiMeAMh2CYMNeuARcPX2PqZ89ezfAQIbyPg+d1ufnW+sPznrd8uBItJ1mE0O528xsp7APLF2d7vVw8E/P+sl1jxT8
B2RhCNpUDF6tALKMbWwuByZjFNXKfkEHokWj41468PpLhvUy+4nJ9yDLQTiAN+6tdme7XX/leX5RQC7yKVZnFPkgA1sSiTbbKg22qLalvyB+HgEflArLpWi/bZEhVXkGxsRu81aIU7SlgMRekQsagb+zoFLMGBTfdMqHQtZrdT8nfPZjwOEr8CwuQmCJsIJO5ntHe1zUfjnQjRSC72P1dsn9SqovtESb7FCHIL6LhtXmlQDAd906GkkOEsfWzIsR
0Hb92E+g0cJ4Xm7wEeOpgkWuYJT7AC82oAgtrYKoJZ9xOeKbrpKWcF9dUqbgiAB4LyD5VyiP5Rtr0HrYalGiBpYIavFCG1Vu2z7Gqu0W7ZqCielnJXOvQnaYYx4G4AgrqwOyJkJkyZJJjr3SFsVMh5rNdqdBzLsDTqnArdvfUt5FCD2tvIQtJSH5iDoEV3G9nUMWb3tGhr7f6k0L0p3chy+gfAM4A4DdV2G1MT5mB2+aN1imlAxyrwAYhrB9gQwP
pFgzg740YWSPIsKj2JiFJUAn+ToL1BgCoBEAlYAhtQFQCqdzA6nPQPoB8BYBGot/YHHXho5P9oqePUxO/yJ5f98ePNTjtMOME0tABYRZYdYLCp2DWe15JwZIwfSwDue8AgVukiQG85A2jwIUXIgQCiigYEoqUf8FlHyjOA2HRUWGJVHBBMA6ozAVoxlb1wpeejGXpLAIEkDi+nwpXjLEwZSxsU1fc4iMne6pCjWnTE1ufSyHQjNkG7fzoiP2bIi9
21vOEWiJPblDRB53bEdew+o3ckuhddBB0PpDRAqRNI6Nu83A7t0owgFSPmqxWBci2SteKtJiHXBTD4eCrAURIDbDTFaIbUAMcoFQAABeVAAgEYBZAhABAMMYHHPDijsAko2YLqF+AABuSYjiRgDCBSAzgYUfIlQBmBcAqAIUOYFFCSiwgWENqAohlB/igCz4s+CjE6qiiUWmLTHlqMf7Ytn+eLV/uzUNEk9jR0AXmmaMmpEUAyjTfyksKJzCdpa4
IuWpANz7QDnR+wl9PJ0QFVVhWQvDcVMRw7bi+qn+PcYeOPG/Qzx+AC8awCFCZAbxqAO8cQEfFQTnAr4kQB+L9EKIfxf4i2IBL/HBhQJvVSsDngmKBBXSMEgwHBIzwf9RcCYyXroxM6pjGkULQgZmLmpO0R4MsVykImoEtgSxpGCias0hEt8NmWZdvnCLyG8D2CBQx+o2L75/FXWx3B3p6yqHiCcR3YxLjIRkGpNNI4AC+CMjgBwA7QQMB0nrE8gZ
A2aRKFoAwEIAIAKAShBYUAPlDD1h6CIehiID8S1BOg+gO0JSwIqC0VQhU7AHVN+gNT0gZU5PhVKNBWCapnUwvN1ManvBbR6w4aV1KyA9Smp2fLrh1JmlQA5pzUw3GWOoK1TRps0xqS2B2FOitp9Uxqb+y558sCgh0saekE+CawUJPkJadtJWnjTPSKNe6UdPSAqQSWGE16ZdPmn3CXh/PC6TtPSCERnhPROqniWmkPS5p3RPMKoNiiQy3p+gd4Nd
D2k5RuMgobACKG+DkJuARVMHjgRlg8A/C3STcCzlnoYysZ+AADo4VWDxAeEAsHYPdhYg/DCpRgNgAYGynMgCAPYRpBuE4RLi9CgMx6ekD2n1izMT0GqVqBIB01IO50qWcQDtBTFiUhU+WWTTYCvAQZX+YIKCM2YkBGUcaJQl8AJikBlAaoAEIkGxC8AsQcoi2XKN5gLAGw5INsMoAzDmhEUps3AObIcr2URgPsu2S2nhCCyRpfiNaeKBOlshOAO7
c6VHTbCTRswfZONJkC1mHQcBkAbAEQH5BJizJJQEuHlKzkKFhAUAZuLKxOD6BzQ4oUgIuGvglzyQZc0gBXM1maBtZsrQWXYAABWtdZgECBLhwA1ZGskuE3K+qFT1QbIRgHmHZnNVUAcaOkZ+DSCWQe4atIQEKAMCwys0TuN3jUJtQGAgQc8iOdyFd6hAL888seRPMBqbFzpjgZgMnKlAmx7gZNTIEIHi7O51K22QIJUCYAiSzIScweSs1KDMAdKj
c5ufnMKnngyaJAGtt3NwDpS1CgClORbXACaY5iRIcIL/g0ggANIQAA==%%