Database Sharding SQL

==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠== You can decompress Drawing data with the command palette: 'Decompress current Excalidraw file'. For more info check in plugin settings under 'Saving'

Excalidraw Data

Text Elements

Shard manager ^bdqK6liG

Master database shard ^eIvD7Tfn

Master database shard ^pDg7iEdh

Master database shard 3 ^Sy6Ph5FO

Service ^rd2M7gKr

Which shard do I use? ^8HkKI98X

Shard 3 ^lxu8SHFI

Database Sharding SQL ^iFr669tF

%%

Drawing

N4KAkARALgngDgUwgLgAQQQDwMYEMA2AlgCYBOuA7hADTgQBuCpAzoQPYB2KqATLZMzYBXUtiRoIACyhQ4zZAHoFAc0JRJQgEYA6bGwC2CgF7N6hbEcK4OCtptbErHALRY8RMpWdx8Q1TdIEfARcZgRmBShcZQUebTiANho6IIR9BA4oZm4AbXAwUDAiiBJuCEwAOQAtAEYqgAYeAE1CAHkABWdiAGYAVQAJAA5ogH0AdmSiyFhEMsDsKI5lYMni

zG5nABYxse1Nms36hJ4AVn5imA2eQd367pOak+Oz/MgKEnVuHhrdhJru641U7nSCSBCEZTSbj/BLxQYATiOwNeEGsy3EqHqIIgzCgpDYAGsEABhNj4NikMoAYhqCFptNWkE0uGwBOU+KEHGIpPJlIkeOszDguECmUZEAAZoR8PgAMqwFYSQQecW4/FEgDqH0kX2xasJCHlMEV6GVpWxHMhHHC2TQWJRbGF2DUlzQNXq9qmEHZwjgAEliLbUDkALr

YiXkdIB7gcIQy7GELlYMq4erijlc63MIOFL0zDHdV4AXz1CAQxGhjX+326g09xUYLHYXDdB2xjdYnAqnDE3AS8Ie3XhgwSgwTzAAIqkoOXuBKCGFsZphFyAKLBdKZIN5KYFV7FfNlGeYKCM4qlCQIP30CdjAAqEq4+6LrzDKKEcGIuBnFbdYxqI48PC/bHCO2JEBwBIxnG+DgWwrKzmg874GE+QlvkuaQBe6BXje96PuKh78lgp7YusaBbE8ezDv

UmyjmMLxeq6qDODwmxxAiSKMcU7zEJ8f4nNoYyDEC3GguCkKnmgmxjiiaImvWAh4gaPIUtS9J0kgS4smyGbcmSan8uQHBCiKGSkSiUoykaJo4mS5oovqmrarqjnKUSNkYnZKoWsIVo2twikQI6LIupWQU+h+Abbm+XoRrgUa/qgsbxiiibEMmEipgAaumK7EFmQYpbBjllklNT9t8CRjDwtHtkwnYtqg7o1PVTZdj2GI8McNTwn1CSbOOU7BD+c4

LggS75euaTmUVMHYh+X6jX+AHHMBwHXAk4GJlBaDFXBCFJchi4oseUnoAAsqEM6kKgS24MyYQADomZIIoVhalB3iRZRXbiTB3d+D2hAgqDMG9pAfZZnBQLKhBGF1QUSjDABiCXSsx3TYmdACCRDKE1EBiJkTDio2UDmAQeMQoT+gkMQKzYnomS4ImTDRhIlS1A0zRtJ0PQDMMyjjOKFIQomBDfSev3XQD92PaD4PveKuBCFAbAAErhPDGJ4kIE0o

hBCD9BJUJuvEaHnJhJRJRAADiCBGBUCAaoM/T6P0ADShDwqQ2WymM+DwhqGuEfAXnzIs6LiuRLG9XEdwPE8yJMVcI7xH8/43GJEC8fxvC1doFVjMB2fYmCEJm813SwtciLPNi8kYkFTkkgZfLoDSmkMtprKRVyqkd9AxmmaKFlxdKcoKl5ZpQ16rdanxOpoHwbnqoa09lLPeV+JIhWBdiIXOrA4XYpF/qBrksXFPFiXQalXrpZl6C4JsO+ZgFaCY

dM4fcIWUzoXnmVaE8IdgtQSHVFEHZmxfEGDnaBHUOC9jQCJB4o4gKr0fpOaciFUDHQNl6ZcnJiDTU3FkXI+5v4/1mMRaWIJzy2zgBOZQYxCCrmIDqZ8r4Fqfm/Lgn4q0gJjFovsIKEFdrJXmobeCRIjrjUthhNKjDmGsPYTqbGv9aHjzWBsCq8JtCDH2CXeiOdmKsXYkXARZcUR52Xs1BiQkRIp2KBXSS3AZKNyWApPU7k268nUt3LSKJmR9z0oP

I8I9hRj3FFZKexoZ72TnsUBeLkV4+PXp5LeiSd7+WzAfB0Towpug9GfDkF8YrhkjFeJK+00pJljqiE478Cqf0kQ/ZJwC3Q8B2PUeEhwTiYIbA1GBK8aptUat2JBGIfh0W+CJQ4Q0cFyJQgQ4oRC1wblmvfEqXpFp8PKlnNawjNiiO2pBbZB1ZFjRWdjH6Eg/o3UBlEBWL0laQ3TF9O5l1Za3XliDMGEMkmQGRpkOGCMvhI1RujfAmNbknmpgTMox

MbpkyYBTdwCLab00ZiiZmUQ2akA5ugB2TsXZuw9t7X2/tA7B1DofUg4sOCSy+RAB5csgYKwBcrRuatNba3BWgPWqzIBGxNpXc6NQLZFEAXuR+tsABC7RjaEHoHAQYAArEY3QLpGE9uqzQ8B6B3lXGHGh6BI5NxjtwRE2gEjVVLgxbEZjribAMbVboolsS2K+IXYuDqc6uKrjCOE9dnGQEtXadJKl24BI0uKEJul8rhKMoKKJ5kYmT0yUqbJUbnJL

1cvPXxWbTQ5pRJaPerSgpHyKc1EpKJz7RSvpUhK1SLl1Iyg03ASRfLEP3l/fc0BNGoH/tK0s/C7UtT6dccZIzh1PBnYg5B1cIGbGAo8LaaVsEjVwfgyaxDSFbLQDuKYVDB1mugD9ehWFbayhgAkdokgTgo1aBAZ89DT3YQgE0CUfpPb0DtjADWABHeV9BsBVHaFATYWATh3j9GeahXkRT4ioFwqY19IB7OWvYwRoDBi1WAmciRtSvTkkOtc1Co7F

FyrKLe+9j7n2mq8mdK1rYOJ/ABE40xVxDi2oYsJT1NjUn2MEgJsNUhTbnQ8XJLxzdc1+MMp3DSPdgk6X7vpfxKaTJprFOGTNm9s0+TXgaRe+dBlKQyQZktRmvTlr7ZiQ+hST7FIimUxtR6MOSiqUSkj556kpgmD2j+eS9pSKAbg9iCRuh3ASAMhdTVuibHgcMxdGIOMxaS+ZkoW6EDYd3cEqamytxtt2bw7DVi1p1lqquojJXihkauUhcacLzqsp

+U84Gz1XrvWHR8igUtWtst+Ry/5bziC9fDDDMFiNJuZDRnTGFf8WuYqReZUmbV0VU3xli4gDMglejxaza0hKFVKv6CqtVmrtW6v1Ya41osGX+GZdLe57W/lhC5ZDCbcleVa1YAK1AQqznG0k9CKVYAZXW0/RrQOgwCQUBgAB+CONsAUBRpIC6FR4T6AlExuYCAFiWrIro0B2gBzCI9eJ5iDiaqxYbkJ/NK9fX2pMeXUHboa4hq4p46OkbjNEmTUp

wJ8a1NhJjVp0e6a9PWSs95Byhb16mbsVl1uxa5dAogHZytjnQrOdra5307ngyedvq20L7SsL+ayoMZp9nv5noLMWMdSURxDkAkCeLfZETxcmUuwxRxQG1iCoQHLeXmsFf3UV8hR7KH7kQ0eS9cebZlE0MQIDnsEhEDtq+3cMqigfttoMDWHAjB3g1quAAUvCGomA7YAEVlDyrYAkVoCB6hGAQw7lMpAUM54Ae+pPn6caDD9EB4kxIgOtCEL0CoBI

7j9DGBdfAcB+jZCvV3rKPe2Codz9w98ZX+GHKEf2QCtXzc7PqzInd8iqP56USntPGes9460axuOA1tAiPhHMx1KJmL/ElRuHdHhG6F/y9G9TdAGW0ES1AIDXZ14EGhk15wc35wUyHi7jjV7kTWIUF2HlTTMl00sn03iSyRs2SV8SVwLXIMsxIMM3l2KC1xCxQK9GrT13dANyikvg82bTvnPwTCtxfnhFt1aV8wEE6WamuBOABD6mky9AQSan/DGB

906mhBODon+Grw3SwWGly2vxuQjw2RmmKz4P3yWkP1wzGFi22CxkNh2jqxFSv2WROjzBZVlEBVQH0GsGiHWzLU+Re3QDcJ608KZWUB8Liimx1ghVmygHmwxiW1OhIhWwkGRTCKGVIE23wCSPQDpl2xxQOxhiO3Zlthh3wDhwRyR2wBRzRwxyxxxwe0ZWe1a0CK+2CO8MpB5XVj+0iMFVIH1mBzFTcXNh4AUTvzzCHU1wJyjjyLSMam4Hw1aigRSw

4F9wLHqHwx4ABAgX4I7RTBxnFBDx0LD30JowkCEA1AnCgF6BxnqGymUAABkEg7YAANPwCcVoZoboJ4jNGXWg6zegizEzYTFXItWXbeHtXJIMKtJzf/OtL0CNZgnRCiXqboAxE4MYdiACMAi4dxR4aApOenBXaNTTIXTA1TUJJNcXdAAUbTAg7RN4IE5nYxaxL0QNCVTnOubnUqfhb/f4KQoPUpQ3Lg43Hgs3NpC/SAPSO3AdIiYdJ3AwkhKPbcWP

XcePV/dfT9SGHgC6MYZQT2SkN9ZU3cZPCQIvEvMvSvavWvBvJvFvNvDvdfGU1ELfHffvQ0k49AYfUfcfSfafWfefRfZfVfTvR05DbfPvW/E9QfW2b9X9f9QDEDMDCDKDGDODYM8Y0Ml06VPfUrMwg5Cw/DXpLQ+rOwkw0jRwijBAEY2VA8cYljT3FBE4WSOQpYlYysNBWsACYPAQ1EeVfY0PPQ5whhOYYgLUnUvU74uJWyME1AygtJVAtXac2zPy

CtJgqE3XGEoKeEoKWOZwIEV1YSUNbjaSf8aiCBEArEgEgXSkiADAzSEXcknA686kyXQg8A4TfDT/SnOA8VL4RA8LcqICD0OsOsP84oBtIU0MEUnzMLBg/KezUQiAdZBUow6PYU0w/ZaEI/UBHYRLMREssUy5Ac4VSUCIgHWqaI2IxbNAGwlw/wiAWUJgMwXsT6frVwxi8wfbA8RI7bVbEmdoxY9IymTIniiQHIvbcUQ7AlIlCAM4i4q4m4+4x4l4

5QN4j4r4+lBo/AAbWjdi5in7To/lXWXo4i0VeAyVYYiMqHQvYvUvcvKvGvevRvZvVvdvF/F+Z0t/XcsYFEtdGSSw6qUcfYUCyAZiQ4SVI4KLEuD0PqHYHOCAzET/YRavUAws2iXpREYKiTH8gSMnEC1nJA7xVA3A28lTQhUXCk4kvAmk6JaXSchJMgy8l2IE+TBc0tJc3eezNc4+DcgUzgipSybzGpGCy3HYrKFGYQpg+3GUiyiMsQ/hRobyqLHg

adAS2Y6itiZQqZPsRs+4BEWQ88fspw4ipCg9Yw4MN0ms89OsqMsoN2AkT2P0YcL4tDIoTzLDcwwCGiNE+4M/Ai6RcjJrY44oOANgRMVC49IoCGooRSaG/cDDMAKGsAZweoRK3pf4JKlddKyBFUrywSGiOibOOG7M+ra6UkfQOmGQcsdoUGsUUs8gkUKAeVdKRMZQbge3VIMhaS2Sy46424h4541494poT4s8Ei7AIQIMZGgxTEk4YcaveoIEH4Uc

ehb0XAOAaEV1SQgCRLRERoU4XqOUr0DIYgJmrkFmtmgdDm8yaSkosoxHGAZHVHdHTHbHXHFW5GcWyExxbpf8AENEkA5Emir0ZQNW6EFE+oYRSQ04GK9EkSQ2+m9InGZ0sEXAIai3DALkJOlDFO22PEJwaOKsqy26/oe6x6wYdS06WsxPL0HcgCQSXpSw5OI84dWiT8wTN8xnZqG4bQb8wY1Afa8NWTfJQkq8yqkqzipkcqx8yq58nTOkyUYgqctq

6gwEzu4EmgpehqzXZczqnXbq0+etNzCCk3Qa+wkobs3AbPILFpJghCsIfhAZSwiO7oAEes3gZLdqZYlQ4pby+ZQKxZbdI6vdQwshOadO96vMz62OyQ36hChrIilrMoDUSQcwSQT7cbYgNgVAP0F6CWhAAAfj620okGQdQfQbuiwb9FQDwcIeiOmyiOhjm2hVhQSPhREvQBSP4ubMEoxXYYgDEumMgEkuO2ktNNsotIcutOcrtPqKey0pZVIewDQb

GwoeweobCFof0r5X+yMr6NsOtAGKDXB0h3vwkE9LHwnynxnzn26AXyXxXzX0rvPQzM8oOE/wJvRL6i8b6jAj/x9UEkOA2M2FgK9WEyClZMwt2FOCHE5LhKHr5xHrQNjTvKwPU1wNntpInNaq3pSTXpatBOXolJ3u1wKXXIPuDqPv6rilPrppGuflRH6AmpzGlKHRmoh2d2hEMUzg9HItWtnQqiDsgHkNbKZztXRNlqLKwkOorOAeQtAYoV3FPUdO

upVONPQHwEwCEEGFlH6BRngxerADeoP0gaORwoWX0eI2GogHgaAZRBBrBqVN3ERphrAHqDhvoWeavR+CiakMPKJvQ3AlJoMApp/GprBrPtxAZtNscCWAtqNKtsyBtth3h3tsduqJdrqPdvgglo2BRuqiOB1vlsCe+GCsgBDvVo52gJHCzgYnjsgGNuhfNv7Xhajy5vOJ5oUv5uUtUuForqNI9pxbtFtRfqHHYm2C8bRP2BVvJehESAHC/LpZxCiE

TuTpCDTvFIzuICzu3xzoiXzpWELtMfWc2e2d2fgw0SuursRJYjRIMW2Dp1OA9CdYWNTmovqEEibtCc7o/LuHbpcXgI2oKrkyKuvPHvvOwIHifMiUydquyf+KVcV2avnIKa3sYMhL3prXYN6vKSbQGpbWgvTqfk7XNbLTgpEKufvpdztROHdcsMyvkMrE2qXXXT6RiexoOsOIQflNOtQoQogcwosO8qBEGeufwrgfLMBsHOmFcPcO6CIZnZ6znboe

6N4EhSYYWxYdoqgCyKJjWy4bSIyJ3YEYnqJgKKkttnMe9Ksb9NsYDIcdkYlnkbouaPGyXa0a6IByB30ZB2yuamMatiNa/R/T/QA2A1A3A0g2g0wFgxLbGOcY8uJ2osEjYh/2bpkkGD2BftlpCYZ3zj0T2Fp09ZRAibQDWk/wjq4x50KsSeKuUxPYTTSajfwJqqIJ+M3vjdybM3yd+PVxyRXPTdKf3pc2zaN0grzd4L+sfgvoryaYhfEO/wGnw3/E

mYYCWL/m9z6dS1lf9o2OOGD2mcneOsKxQrAY1f7ZWk+qq3dBznETPpuZmbuZpvBv3E+bjzed3HhsRoqgw5+H9SvXc4BZc7j3w+2G6iI5xrI49DExOH+desBdxDJpBapqc4heVcZuZtheZaNtZdtm5vkr5qUsFrUtFplZQTJw9QGlifCM9sCkSrYmTmr1qjRqzkVYZYy9Zqy+KARagGksVWVVVQ1S1R1T1QNTgCNRNWldDrQF2HJ19bDWBWxclpRr

uG8pqm6hgJORuCCsVchZVezrVbPuNu1YoF1aMn1aQENfdJKBRlIDtXhBiLcovToRRB3P2DiFXX7HPMSw2Or0yrMWCbiDUIGQOAqhkntZU/iszjJx2E4h+9HBrjZ1/YgQzgYkbNrbtXdZzi3Pk1o+F1SbFxnujZY4njY/qo44oKTcSbjY1zTeHuKFYJ6sPsFKqZvhqck781Gpfk9lk9qZxHELgR2GOG+CywbbdD6SbemUWp8aeEyoOKWQc8IWM/md

5/M5w0s5rGElgaufs8M8QYkAnBGw+xfZZtQFlDrzuPnbooN+eX+WN6WFN/N5iVIoxBrfiGWuAhrZknddoiUMYZiOYfiK3Z3c4dRR4a2xpiPEdAkrPZEfVY0rkeIfQGt861Bjt+UAd4t46O0ZXa/dIzZkMYlX/eoyHIkCMCMBRgnBqDvFaCaEe5WetdYhradRJ0SE4z9fpM7vdER77vE2x5DbHro/DcY8J+Y6l1Y7qtIPJ8TbyeTZ48XNgo6pKZYO

hPKbAsqdzeqfzbj/bXqdwGJB5/Z7moAoAgRA2iClF/7ol8wuqhklql6e0Pl56L0cV8jxM7PtV4qyEQ2ILK1/Tp17wXDxbsyglvVrE71BQrt7+N8KFBu2hDLY+GwQCUPPXJhCUd26sdWkzBj5FEz6YsBPiyhVi/ZDK3AXPsWQMZmV4gMXSyoBzGC4ASQDQJ4rlAtbMYrWkAHcqASbLYkKI3wSVEtUo64c7EXfYjgGyx7xMESjVXHqSTKoPlI2I/aq

mPxJ4T86CGuTjsrm47scaexTVchmzYKwk1+zPDfqzy35n0i2KYCcAfzvriEKoA0KwdFnYFDM1O0kK/tNzoiLVGgtg7LJ2ySjECmQSvQ9IfxkrHMB2UDb/pAJFRjtteE7AAUDWnZ0UQBwA5dmRTXb+8YBboOARHwkAICkBaKFAXwzQHR8WY57bAY9kfaJ8IA+AgyjoyIHGV+iZA04JdxL7oANQQGJoCJGyhQBWajAhPM9xrobAMSPdYCiXC4HsRGy

zfTgfcCLg0s4qwmUHvEDdyDBvuWtedIIN/a98RBLcXxOIJSZkkI2GmRTFVRfLz1Yk1PVUBTxn5U8U28bWngk3p4r9hOTPPqvoOBRs8EKxgrKBN1La9py26dSttCH7A1ws4CPTTgll97cMJk39Lut81lprEAGuhTwVUO7aKl3+AQizkcmCF4VzkvPf/vliAH69DeqfQFLEJxE28je+I+ITNj96UV/8qQxFMkT3ah9D2OQqPhgPyGx9ChmlEocn05Q

vsyh2fT9nCLz6kDf25lCgRDnACxRUQcAOAPKD4RwtpgYIdIGUC/CkAoI5wBgIQAQAUB5UU9aQbsKpASg9R+o1YETBEBjw/QM4fQPKHXgbDSqQjY0dbTNGaipBOwoeBk2J42ie8dotICjEXpk8kkRo90YizNEWjV6XHfIH6JNGBiQSc/ZemGI9H6ANYGggTsUHFr+ieuZo1oDcP1wqjkx4Yz0dALiLUUsxtogMbmPAEJDCxKY00WkAGzB9aR5YnMe

aLS7HdTu7PGMcWP0CrhM6qrVOnqyJyhjmA2AfEDKC+LFILEoCEArVCiwPBrgQdHEAOLJD4Ba+pHbynxjlpYd8MUWIshACMBsADAMooZgQH1hg5GgScJ1sOD8rdIZqMqVsamLSDxiPhTBHEBDHQGhj2QJAehnTW9AMonRe4iAE3nwC2wqQxIeEEBKAkoxxq2ILWMoDjAihqQq4CcHBLglgS+8V47MeZCDFEh0xFMTgKZxVFwBAgZgYQMwDthfj3xL

Y03FrCTAMpMuqAa2BkAejBBYRz/JMUQApaA4+RxQJlPKKf7EVhAUAI2JUP1hVlgomgdVJMWYCygmUcAC6GwAygdj6JRFcAIAgXrBAcwL4IsEAA==

%%