ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Fail-over solutions

    Scheduled Pinned Locked Moved IT Discussion
    mysqlphpapachewindows server
    25 Posts 8 Posters 2.4k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • ObsolesceO
      Obsolesce @scottalanmiller
      last edited by Obsolesce

      @scottalanmiller said in Fail-over solutions:

      For MySQL HA, the "go to" solution is generally Galera.

      http://galeracluster.com/

      It's similar licensing to MySQL so a good match there, and is specifically the primary MySQL application layer HA product out there. I've used this in some pretty demanding environments (over 35K concurrent users.)

      Is this active:active load balancing or active:passive/standby?

      scottalanmillerS 1 Reply Last reply Reply Quote 0
      • dbeatoD
        dbeato @scottalanmiller
        last edited by

        @scottalanmiller said in Fail-over solutions:

        For MySQL HA, the "go to" solution is generally Galera.

        http://galeracluster.com/

        It's similar licensing to MySQL so a good match there, and is specifically the primary MySQL application layer HA product out there. I've used this in some pretty demanding environments (over 35K concurrent users.)

        You don’t recommend Percona right?

        1 scottalanmillerS 2 Replies Last reply Reply Quote 0
        • 1
          1337 @dbeato
          last edited by

          @dbeato said in Fail-over solutions:

          @scottalanmiller said in Fail-over solutions:

          For MySQL HA, the "go to" solution is generally Galera.

          http://galeracluster.com/

          It's similar licensing to MySQL so a good match there, and is specifically the primary MySQL application layer HA product out there. I've used this in some pretty demanding environments (over 35K concurrent users.)

          You don’t recommend Percona right?

          It looks like Galera is an integrated part of MariaDB since v10.1, a few years back. Maybe that would be another option.

          JaredBuschJ scottalanmillerS 2 Replies Last reply Reply Quote 1
          • JaredBuschJ
            JaredBusch @1337
            last edited by

            @pete-s said in Fail-over solutions:

            @dbeato said in Fail-over solutions:

            @scottalanmiller said in Fail-over solutions:

            For MySQL HA, the "go to" solution is generally Galera.

            http://galeracluster.com/

            It's similar licensing to MySQL so a good match there, and is specifically the primary MySQL application layer HA product out there. I've used this in some pretty demanding environments (over 35K concurrent users.)

            You don’t recommend Percona right?

            It looks like Galera is an integrated part of MariaDB since v10.1, a few years back. Maybe that would be another option.

            MariaDB is what is installed anymore when you do a yum/dnf install mysql anyway. Unless you have the specific repository for MySQL.

            1 Reply Last reply Reply Quote 0
            • 1
              1337 @scottalanmiller
              last edited by

              @scottalanmiller said in Fail-over solutions:

              @pete-s said in Fail-over solutions:

              @stacksofplates

              The customer standardizes on windows but the software is cross-platform.

              But super slow and cumbersome on Windows 🙂 Both MySQL and PHP famously are dogs on Windows.

              I don't think that's true anymore. I haven't run any benchmarks on the same hardware but I think speed was brought up to parity with MySQL 5.5 by Oracle. And PHP after Microsoft started to work with Zend so around PHP 5.4 or so. Linux will probably always have the upper hand since that is the huge majority of installations and it would be my preference as well.

              ObsolesceO 1 Reply Last reply Reply Quote 0
              • ObsolesceO
                Obsolesce @1337
                last edited by

                @pete-s said in Fail-over solutions:

                @scottalanmiller said in Fail-over solutions:

                @pete-s said in Fail-over solutions:

                @stacksofplates

                The customer standardizes on windows but the software is cross-platform.

                But super slow and cumbersome on Windows 🙂 Both MySQL and PHP famously are dogs on Windows.

                I don't think that's true anymore. I haven't run any benchmarks on the same hardware but I think speed was brought up to parity with MySQL 5.5 by Oracle. And PHP after Microsoft started to work with Zend so around PHP 5.4 or so. Linux will probably always have the upper hand since that is the huge majority of installations and it would be my preference as well.

                One example (real-life example), i have two production web servers set up. One on Windows and one Linux. They both use Apache, MariaDB, etc... The Windows one is (no exaggeration here) at least 5x - 10x slower in all aspects.

                1 Reply Last reply Reply Quote 1
                • scottalanmillerS
                  scottalanmiller @Obsolesce
                  last edited by

                  @obsolesce said in Fail-over solutions:

                  @scottalanmiller said in Fail-over solutions:

                  For MySQL HA, the "go to" solution is generally Galera.

                  http://galeracluster.com/

                  It's similar licensing to MySQL so a good match there, and is specifically the primary MySQL application layer HA product out there. I've used this in some pretty demanding environments (over 35K concurrent users.)

                  Is this active:active load balancing or active:passive/standby?

                  Active - Active, but we are talking about FT here, not LB.

                  1 Reply Last reply Reply Quote 1
                  • scottalanmillerS
                    scottalanmiller @dbeato
                    last edited by

                    @dbeato said in Fail-over solutions:

                    @scottalanmiller said in Fail-over solutions:

                    For MySQL HA, the "go to" solution is generally Galera.

                    http://galeracluster.com/

                    It's similar licensing to MySQL so a good match there, and is specifically the primary MySQL application layer HA product out there. I've used this in some pretty demanding environments (over 35K concurrent users.)

                    You don’t recommend Percona right?

                    I've not used it much.

                    1 Reply Last reply Reply Quote 1
                    • scottalanmillerS
                      scottalanmiller @1337
                      last edited by

                      @pete-s said in Fail-over solutions:

                      @dbeato said in Fail-over solutions:

                      @scottalanmiller said in Fail-over solutions:

                      For MySQL HA, the "go to" solution is generally Galera.

                      http://galeracluster.com/

                      It's similar licensing to MySQL so a good match there, and is specifically the primary MySQL application layer HA product out there. I've used this in some pretty demanding environments (over 35K concurrent users.)

                      You don’t recommend Percona right?

                      It looks like Galera is an integrated part of MariaDB since v10.1, a few years back. Maybe that would be another option.

                      Nearly all of us only run MariaDB, it's where the more serious development has gone. MySQL is mostly just used as an alias for MariaDB.

                      jmooreJ 1 Reply Last reply Reply Quote 3
                      • jmooreJ
                        jmoore @scottalanmiller
                        last edited by

                        @scottalanmiller Yeah both of my webservers use mariadb for example

                        1 Reply Last reply Reply Quote 0
                        • 1
                        • 2
                        • 2 / 2
                        • First post
                          Last post