https://www.percona.com/downloads/Percona-Server-5.7/LATEST/ It contains a large number of good changes needed for many Reproducible: Always
Already the release of percona 5.7.19! Why Gentoo is lagging behind the progress?
I suspect the main issue is the same affecting "Oracle" MySQL 5.7 - https://bugs.gentoo.org/567590 MySQL ships with its own "fork" of boost which has patches that I'm guessing haven't been pushed upstream. Because of this, attempting to use the system version of boost causes GIS (geographic / coordinate) related tests to fail (so I assume it breaks GIS functionality). Gentoo's philosophy is to avoid such forked versions and use system libraries (avoids conflicts and backporting patches, benefits from upstream fixes and improvements). I haven't had much time to investigate yet (current excuse: my main linux box is currently awaiting RMA on the Ryzen processor) but there's several options which could be investigated: 1) Compile MySQL with a static copy of an older, patched "fork" of boost "as intended". I believe this is currently what is being done in the Gentoo mysql overlay. 2) Push patches upstream to either MySQL or boost so MySQL compiles against the current version of boost. From what little I know, "Oracle" MySQL isn't particularly open to community contribution, and I doubt boost want to accept patches for just 1 application (unless they're genuine bug fixes, which I'm guessing they're not, otherwise someone would've pushed the fixes upstream to boost already). Percona might be more accepting of community contributions. 3) Wait for MySQL 8.0, which is "just around the corner". I have no idea what the Percona lag time on 8.0 is likely to be, but obviously if Oracle have updated MySQL to work without patching boost, it'll mean less faffing around on Gentoo's end. TBH I wouldn't be particularly hopeful of this being the case. 4) Leave MySQL up to the users and concentrate on MariaDB and other alternatives. If users really want "Oracle" MySQL or Percona MySQL they can contribute to an overlay. Currently MySQL vs MariaDB isn't a big issue - 99.9% of users can use either interchangeably - but I suspect it may become bigger in the future as feature sets / implementations diverge. As always, the ultimate reason something hasn't been done yet in an open source project is because no one with enough time and interest/determination has done it yet.
Created attachment 522412 [details] Test ebuild for percona-server 5.7.21.20 See attached for a test ebuild for percona-server 5.7.21.20. It compiles and runs but I make no claims beyond that. Attaching in-case its of use for anyone wanting to develop further. Primary change is referencing tirpc as rpc/rpc.h is required for the group_replication plugin. Regards
Created attachment 546812 [details] Ebuild for percona-server-5.7.22.22 Based on test ebuild provided above, two changes were needed for our systems: 1) -DWITH_CURL=system, 2) glibc 2.26 does not provide rpcgen anymore, so net-libs/rpcsvc-proto dependency was needed too. Also available from our portage overlay https://github.com/skyfms/portage-overlay
The bug has been closed via the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=ab9bd9d38d16f125b7b3f3b443e89589e42e1933 commit ab9bd9d38d16f125b7b3f3b443e89589e42e1933 Author: Thomas Deutschmann <whissi@gentoo.org> AuthorDate: 2018-10-15 01:17:06 +0000 Commit: Thomas Deutschmann <whissi@gentoo.org> CommitDate: 2018-10-15 01:29:43 +0000 dev-db/percona-server: bump to v5.7.23-23 - Add CJK support for InnoDB full-text search via USE=cjk - Beginning with {mysql,percona-server}-5.7, we are moving configuration from a single my.cnf to several files in /etc/mysql/mysql.d. Closes: https://bugs.gentoo.org/611060 Package-Manager: Portage-2.3.50, Repoman-2.3.11 Signed-off-by: Thomas Deutschmann <whissi@gentoo.org> dev-db/percona-server/Manifest | 3 + dev-db/percona-server/files/my.cnf-5.7 | 3 + dev-db/percona-server/files/my.cnf.distro-client | 21 + dev-db/percona-server/files/my.cnf.distro-server | 28 + dev-db/percona-server/metadata.xml | 2 + .../percona-server/percona-server-5.7.23.23.ebuild | 1049 ++++++++++++++++++++ 6 files changed, 1106 insertions(+)