What is the industry/production grade solutions or if you have already any experience please share it. Thanks

    • xmunk@sh.itjust.works
      link
      fedilink
      arrow-up
      4
      arrow-down
      1
      ·
      edit-2
      10 months ago

      I’m glad someone else said it… It may sound glib but the performance limits between Postgres and MySQL are night and day.

      More seriously though… Read replication is how you horizontally scale any RDBMS. Read replication unlocks a serious amount of read bandwidth but it comes at a (usually steep) technical cost to migrate logic to be handle aware - especially when it comes to complex transactions.

        • xmunk@sh.itjust.works
          link
          fedilink
          arrow-up
          1
          arrow-down
          1
          ·
          10 months ago

          I provided a “real” answer, but I think it’s important to realize that MySQL is far behind the game in terms of performance… The Oracle acquisition really fucked that software and it hasn’t recovered.

          Anyways, horizontal scaling means replicas… But the specifics of that (and resources to aide with it) are highly dependent on their infrastructure… Self hosted? AWS RDS? Aurora? All those have really different starting points when considering a migration.