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

    Linux Project

    IT Discussion
    5
    36
    5.8k
    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.
    • ?
      A Former User @scottalanmiller
      last edited by

      @scottalanmiller said:

      Truly identical you do with DRBD.

      Didn't want to do anything that highend. A once daily sync would be fine, I just don't want the site to be down. Since I am using wordpress could I just sync the DB? Any maybe sync the files using rSync?

      ? scottalanmillerS 2 Replies Last reply Reply Quote 0
      • ?
        A Former User @A Former User
        last edited by A Former User

        @Aaron-Studer said:

        @scottalanmiller said:

        Truly identical you do with DRBD.

        Didn't want to do anything that highend. A once daily sync would be fine, I just don't want the site to be down. Since I am using wordpress could I just sync the DB? Any maybe sync the files using rSync?

        You could setup a cron job to take a wordpress backup and a cron job on the second one to import the backup. Not the most elegant way to do it though.

        1 Reply Last reply Reply Quote 0
        • scottalanmillerS
          scottalanmiller @A Former User
          last edited by

          @Aaron-Studer said:

          @scottalanmiller said:

          Truly identical you do with DRBD.

          Didn't want to do anything that highend. A once daily sync would be fine, I just don't want the site to be down. Since I am using wordpress could I just sync the DB? Any maybe sync the files using rSync?

          Then Rsync. The answer is always Rsync with UNIX.

          ? 1 Reply Last reply Reply Quote 0
          • scottalanmillerS
            scottalanmiller
            last edited by

            Remember that a database has its files open, always. So you can't sync them. You have to backup and restore them. Nothing can sync an open file.

            1 Reply Last reply Reply Quote 0
            • ?
              A Former User @scottalanmiller
              last edited by

              @scottalanmiller will rsync ruin my DB?

              scottalanmillerS 1 Reply Last reply Reply Quote 0
              • scottalanmillerS
                scottalanmiller @A Former User
                last edited by

                @Aaron-Studer said:

                @scottalanmiller will rsync ruin my DB?

                Anything will.

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

                  If you want a full-on MySQL cluster...

                  http://galeracluster.com/

                  1 Reply Last reply Reply Quote 0
                  • ?
                    A Former User
                    last edited by

                    So in that case it would be a 2 part job, 1 sync WP directory. 2 backup \ restore DB?

                    scottalanmillerS 1 Reply Last reply Reply Quote 0
                    • scottalanmillerS
                      scottalanmiller @A Former User
                      last edited by

                      @Aaron-Studer said:

                      So in that case it would be a 2 part job, 1 sync WP directory. 2 backup \ restore DB?

                      You can do it that way.... three steps...

                      1. Backup
                      2. Sync
                      3. Restore
                      1 Reply Last reply Reply Quote 0
                      • ?
                        A Former User
                        last edited by A Former User

                        You could do something like this and have it store to something both can access: http://jamieflarity.com/computers/how-to-backup-your-wordpress-database-and-files-without-a-plugin/ then just do a cronjob to import the sql.gz on the second server

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

                          Or you could cluster the MySQL instances. It is pretty rare that you would want to protect a system anywhere but at the application level. The idea that you do it somewhere beneath the apps themselves is a notion that vendors like VMware try to push to SMB clients who don't understand that apps needs to replicate themselves and can do so far better than the platform can.

                          1 Reply Last reply Reply Quote 0
                          • ?
                            A Former User
                            last edited by

                            Hm..... Just found this....

                            https://wordpress.org/plugins/database-sync/

                            1 Reply Last reply Reply Quote 1
                            • ?
                              A Former User
                              last edited by

                              So want I am thinking about doing is running a server at home and on C@C, and having them in sync. then if ether one goes down, no problem.

                              scottalanmillerS 1 Reply Last reply Reply Quote 0
                              • scottalanmillerS
                                scottalanmiller @A Former User
                                last edited by

                                @Aaron-Studer said:

                                So want I am thinking about doing is running a server at home and on C@C, and having them in sync. then if ether one goes down, no problem.

                                That mostly makes sense. Dealing with the dynamic IP address of your house is the pain. But this doesn't explain the DNS thing.

                                1 Reply Last reply Reply Quote 0
                                • ?
                                  A Former User
                                  last edited by A Former User

                                  How do I setup cloudflare to point to 2 ip addresses?

                                  scottalanmillerS 1 Reply Last reply Reply Quote 0
                                  • scottalanmillerS
                                    scottalanmiller @A Former User
                                    last edited by

                                    @Aaron-Studer said:

                                    How do I setup cloudflare to point to 2 ip addresses?

                                    Stop. Everything is wrong here. What do you picture you are going to do with two IP addresses here?!?

                                    1 Reply Last reply Reply Quote 2
                                    • scottalanmillerS
                                      scottalanmiller
                                      last edited by

                                      And what do you imagine YOUR DNS servers are going to do?

                                      1 Reply Last reply Reply Quote 1
                                      • ?
                                        A Former User
                                        last edited by

                                        So I am going to have 2 IP addresses - one Public IP address from C@C and One Public IP from my home internet. How do I setup my domain in such a way that it trys C@C first, and if that does loads, loads my home server?

                                        scottalanmillerS 1 Reply Last reply Reply Quote 0
                                        • scottalanmillerS
                                          scottalanmiller @A Former User
                                          last edited by

                                          @Aaron-Studer said:

                                          So I am going to have 2 IP addresses - one Public IP address from C@C and One Public IP from my home internet. How do I setup my domain in such a way that it trys C@C first, and if that does loads, loads my home server?

                                          DNS does not do that. To do what you are picturing you need a load balancer like an F5 or HAProxy. DNS doesn't do this, ever. You are using the wrong tools and the wrong approach. If you want failover for webservers, you are getting into a whole new level of complexity. A huge one. Even after we fix this layer, you have to fix things like database sync when the system fails back and forth!!

                                          What you want is CloudFlare, don't even think of ever running your own DNS servers. No one should ever do this. Not in the SMB, not the Fortune 101, no one. DNS points to your main IP. If your site fails, manually switch the IP to your backup. That's about the best you are going to get.

                                          ? 1 Reply Last reply Reply Quote 1
                                          • scottalanmillerS
                                            scottalanmiller
                                            last edited by

                                            If you wanted failover, you would buy a bunch of VMs at AWS or Rackspace. Then buy a load balancer. Have the load balancer detect if one of the VMs fails. Then it would point to the other one. I manage load balancers at Rackspace for this all of the time.

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