GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Excluding particular databases from cluster

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excluding particular databases from cluster

    Hi,

    I was wondering if there is any option to exclude some databases from cluster, that is private to only that node.?

    I tried "replicate-ignore-db" in my.cnf but it didn't work!.





  • #2
    Replication filters are working with standard MySQL replication, but not with Galera based replication. The XtraDB Cluster is designed to work best with identical data sets on each node, and any node that is suspected to have different data then others will be suspended.
    Theoretically, on your own risk, you can create MyISAM tables just on single node where wsrep_replicate_myisam is OFF on all nodes.

    Comment


    • #3
      So its not supported officially by the cluster!.
      would love to have this option as it will be more customizable..
      anyway thanx for the information.

      Comment

      Working...
      X