Ad Widget

Collapse

Zabbix second server

Collapse
This topic has been answered.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • nikita_lnx
    Junior Member
    • Jun 2022
    • 10
    #1

    Zabbix second server

    Hello! My question about Zabbix HA
    My config is: PostgreSQL+Nginx+Zabbix 6.0
    We use two servers, I've already setup Zabbix HA
    But I stacked with DB. Any easy solution for this?
    I know some solutions - to create PostgreSQL HA cluster, but for my company it costs a lot.
    Maybe it could be possible to create like a second back up server if the first one will disconnect? (dump DB or something like this).​
    Tags: None
    • Answer selected by nikita_lnx at 07-03-2023, 09:54.
      cyber
      Senior Member
      Zabbix Certified SpecialistZabbix Certified Professional
      • Dec 2006
      • 4807
      Can you just answer topic , not comment.. its not possible to quote if needed...

      Native HA for server works ok.
      My experience is with https://pg-auto-failover.readthedocs.io/en/main/ works ok for my needs... you probably need also a haproxy in front of it with a VIP address, so it redirects queries to active host.
      I guess PG forums can give you more answers on the topic.
        • Selected Answer

        Comment

        • cyber
          Senior Member
          Zabbix Certified SpecialistZabbix Certified Professional
          • Dec 2006
          • 4807
          #2
          Why do you think it costs anything? Commercial support costs, but you don't have to...

            Comment

            • nikita_lnx
              #2.1
              nikita_lnx commented
              06-03-2023, 17:42
              Editing a comment
              because you need to host some 3-4 virtual servers (for patroni HA for example), we use cloud solutions. But all we need - when the first is down the second is online, maybe like a replica or something like that..
            • cyber
              Senior Member
              Zabbix Certified SpecialistZabbix Certified Professional
              • Dec 2006
              • 4807
              #3
              Even then you need another host..
              But this is a decision you have to make... spend some and have HA or not... Simple as that.

                Comment

                • nikita_lnx
                  #3.1
                  nikita_lnx commented
                  07-03-2023, 09:33
                  Editing a comment
                  Ok, I'd like to try. What do you recommend? Create Zabbix HA cluster (by Zabbix tools) and find solution for PostgreSQL? Or question about PostgreSQL not for this forum? Thank you!
                • cyber
                  Senior Member
                  Zabbix Certified SpecialistZabbix Certified Professional
                  • Dec 2006
                  • 4807
                  #4
                  Can you just answer topic , not comment.. its not possible to quote if needed...

                  Native HA for server works ok.
                  My experience is with https://pg-auto-failover.readthedocs.io/en/main/ works ok for my needs... you probably need also a haproxy in front of it with a VIP address, so it redirects queries to active host.
                  I guess PG forums can give you more answers on the topic.
                    • Selected Answer

                    Comment

                    • nikita_lnx
                      Junior Member
                      • Jun 2022
                      • 10
                      #5
                      Originally posted by cyber
                      Can you just answer topic , not comment.. its not possible to quote if needed...

                      Native HA for server works ok.
                      My experience is with https://pg-auto-failover.readthedocs.io/en/main/ works ok for my needs... you probably need also a haproxy in front of it with a VIP address, so it redirects queries to active host.
                      I guess PG forums can give you more answers on the topic.
                      sorry about comments ok, will try! Thank you for the answers!

                        Comment

                        Previous template Next
                        Working...