Forums

Covering OroCRM topics, including community updates and company announcements.  Subscribe

This topic contains 3 replies, has 2 voices, and was last updated by  andrew wilcox 1 year, 2 months ago.

  • Creator
    Topic
  • #22208

    andrew wilcox
    Participant

    Oracle’s preferred method for MySQL HA is to use GTID based replication. To enable GTID based replication, two things need to be added to the /etc/my.cnf file

    The oro_search_index_text table is MyISAM. Updates to a MyISAM table have certain restrictions when using GTIDs.

    The install script will break when the target database is set up for GTID based replication. The specific error is:

    Running this statement outside a transaction (or in autocommit mode) should solve this.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Author
    Replies
  • #22210

    andrew wilcox
    Participant

    (Using MySQL 5.7 BTW. GTIDs are post 5.1 IIRC)

    #22271
    Artem Liubeznyi
    Artem Liubeznyi
    Oro Core

    Hi Andrew,

    Thanks for sharing the issue. Is there anything we can help you in this regard, or you’re just sharing the knowledge to the community?

    #22273

    andrew wilcox
    Participant

    Hi Artem,

    Just sharing the issue and hoping for a fix in the near future.
    Andrew.

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

ssossossosso