Ad Widget

Collapse

Separate Server nodes configuration requires importing schema?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • UVS
    Junior Member
    • Apr 2024
    • 2

    #1

    Separate Server nodes configuration requires importing schema?

    Hey there,
    I am deploying Zabbix High availability monitoring spanning on 6 Ubuntu 21.04 machines all able to communicate. Here is my end goal.
    2x mysql databases with master-master replication
    2x Zabbix server nodes
    2x frontends. Each able to point both databases.

    I implemented M-M replication but now stuck at configuring server nodes. I cannot find proper answer to the whether do i need to import initial schema on DBs or on Server nodes as well. When I try, error “table ‘role’ already exists” comes up. Server config files are pointing to DBs with all necessary parameters. But HA is not enabled.

    Apologies if the message is unclear or vague. I am willing to explain more if required.

    Thanks a million!
  • markfree
    Senior Member
    • Apr 2019
    • 868

    #2
    Usually the initial schema is imported on the Zabbix DB.
    When you say "server nodes", do you mean Zabbix server nodes? You can read more information about Zabbix HA here.

    As for MySQL replication, are you following the MySQL documentation?

    Comment

    Working...