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.