MariaDB Galera Cluster

Discussion in 'Pre-Sales Questions' started by robert_adams921, Apr 26, 2016.

  1. robert_adams921

    robert_adams921 New Member

    Joined:
    Apr 26, 2016
    Messages:
    2
  2. caesar

    caesar aMember Pro Developer Staff Member

    Joined:
    Oct 16, 2009
    Messages:
    1,659
    Hello Robert,

    I see two issue:

    1. aMemeber uses GET_LOCK but this function is not supported by this cluster.
    2. one aMemeber table require MyISAM engine (am_helpdesk_faq) we use FULLTEXT index in this table but InnoDB does not support it (at least until MySQL 5.6). In case of you do not use helpdesk module you can disregard this item.

    Best Regards.
  3. robert_adams921

    robert_adams921 New Member

    Joined:
    Apr 26, 2016
    Messages:
    2
    Thanks for the quick resposnse. I was hoping it would be easy. The idea of having a redundant 3-node sql cluster for billing is very appealing.

    It looks like the FULLTEXT issue can be resolved by running a newer MySQL/MariaDB. Do you think working around the GET_LOCK issue is approachable?

    -Robert
  4. caesar

    caesar aMember Pro Developer Staff Member

    Joined:
    Oct 16, 2009
    Messages:
    1,659
    It is possible to use another synchronization way instead of GET_LOCK but it require changes in core files.

Share This Page