Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Piwik breaks MySQL Group Replication #11673

Closed
mattab opened this issue May 8, 2017 · 1 comment
Closed

Piwik breaks MySQL Group Replication #11673

mattab opened this issue May 8, 2017 · 1 comment
Labels
duplicate For issues that already existed in our issue tracker and were reported previously.

Comments

@mattab
Copy link
Member

mattab commented May 8, 2017

(Initially reported in https://forum.piwik.org/t/piwik-3-0-3-breaks-mysql-group-replication/23796 )

When MySQL 5.7.17 is running in group replication (a high-availability feature introduced in MySQL 5.7.17), all tables are required to have a primary key. Installing Piwik 3.0.3 on MySQL 5.7.17 running in a group replication breaks the group because all of the Piwik tables do not contain a primary key. The solution is to add a primary key to the three Piwik tables that do not contain primary keys:

  • piwik_log_profiling
  • piwik_plugin_setting
  • piwik_site_setting

If possible, please make this change in Piwik 3.0.4 so we may continue with our high-availability setup. Thanks in advance.

Reference: https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
"Primary Keys. Every table that is to be replicated by the group must have an explicit primary key defined. Primary keys play an extremely important role in determining which transactions conflict by identifying exactly which rows each transaction has modified."

@mattab
Copy link
Member Author

mattab commented May 8, 2017

see duplicate issue: #11596

@mattab mattab closed this as completed May 8, 2017
@mattab mattab added the duplicate For issues that already existed in our issue tracker and were reported previously. label May 8, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
duplicate For issues that already existed in our issue tracker and were reported previously.
Projects
None yet
Development

No branches or pull requests

1 participant