[HN Gopher] Announcing Vitess 12
       ___________________________________________________________________
        
       Announcing Vitess 12
        
       Author : ksec
       Score  : 33 points
       Date   : 2021-10-26 20:57 UTC (2 hours ago)
        
 (HTM) web link (vitess.io)
 (TXT) w3m dump (vitess.io)
        
       | bognition wrote:
       | Vitess is amazing. It lets you horizontally scale a mysql
       | database at the database level and not the application level.
       | 
       | With vanilla MySQL there are limits to how big a database can
       | get. If your application/dataset is continually growing,
       | eventually you will need to shard the database. With Vanilla
       | MySQL that entails spinning up a second primary db and teaching
       | the application which db to route queries too. Or putting it
       | another way, the sharding logic lives in the application.
       | 
       | With vitess the sharding logic lives "in the database" so your
       | application doesn't need to be updated.
       | 
       | It comes with the overhead of some middle ware but in my
       | experience that overhead is well worth keeping the sharding
       | complexity out of the application.
       | 
       | Keep in mind I'm not talking about a database with hundreds of
       | tables getting too big but rather a small set of tables that are
       | large enough and have enough traffic that scaling the underlying
       | instance becomes problematic.
        
         | annexrichmond wrote:
         | > With vanilla MySQL there are limits to how big a database can
         | get.
         | 
         | It's always been unclear to me what these limits are in
         | practice. Is it a certain combination of the number of rows for
         | table size in GBs?
        
       | oofbey wrote:
       | Really glad to see them using inclusive naming, and remove the
       | term "master" from their jargon. Watching movies like Django
       | Unchained has given me an appreciation for how simple words like
       | that can be triggering, so I work hard to avoid it in my
       | engineering.
        
       | diskzero wrote:
       | Vitess is a database solution for deploying, scaling and managing
       | large clusters of open-source database instances. It currently
       | supports MySQL, Percona and MariaDB. It's architected to run as
       | effectively in a public or private cloud architecture as it does
       | on dedicated hardware. It combines and extends many important SQL
       | features with the scalability of a NoSQL database.
        
       ___________________________________________________________________
       (page generated 2021-10-26 23:01 UTC)