percona: Update to 5.6.40-84.0

[ryandesign (Ryan Carsten Schmidt)]

percona seems to have been updated (port version: 5.6.32-78.1, new version: 5.6.40-84.0)

[mf2k (Frank Schima)]

See #57827

[yan12125 (Chih-Hsuan Yen)]

In 8b7d032eacddc1d81ded2f26331109a29ed81efe/macports-ports (master):

percona: update to 8.0.15-6

• RocksDB does not build. Some relevant discussions:

​https://jira.percona.com/browse/PS-2285
​https://jira.percona.com/browse/PS-4116

I tried a few patching tricks. With this patch:

--- storage/rocksdb/CMakeLists.txt.orig 2019-06-22 02:42:18.000000000 +0800
+++ storage/rocksdb/CMakeLists.txt 2019-06-22 02:42:08.000000000 +0800
@@ -103,6 +103,8 @@

IF(HAVE_FALLOCATE AND HAVE_LINUX_FALLOC_H)

ADD_DEFINITIONS(-DROCKSDB_FALLOCATE_PRESENT)

ENDIF()

+ elseif(CMAKE_SYSTEM_NAME MATCHES "Darwin")
+ add_definitions(-DOS_MACOSX)

ENDIF()

ENDIF()

@@ -184,7 +186,7 @@

${ROCKSDB_LIB_SOURCES}

)

-SET(rocksdb_static_libs ${rocksdb_static_libs} ${ZLIB_LIBRARY} regex "-lrt")
+SET(rocksdb_static_libs ${rocksdb_static_libs} ${ZLIB_LIBRARY} regex)

MYSQL_ADD_PLUGIN(rocksdb ${ROCKSDB_SOURCES} STORAGE_ENGINE DEFAULT MODULE_ONLY

LINK_LIBRARIES ${rocksdb_static_libs}

--- storage/rocksdb/rdb_buff.h
+++ storage/rocksdb/rdb_buff.h
@@ -30,6 +30,16 @@

#include <string>
#include <vector>

+#if APPLE
+#include <libkern/OSByteOrder.h>
+#define htobe64(x) OSSwapHostToBigInt64(x)
+#define be64toh(x) OSSwapBigToHostInt64(x)
+#define htobe32(x) OSSwapHostToBigInt32(x)
+#define be32toh(x) OSSwapBigToHostInt32(x)
+#define htobe16(x) OSSwapHostToBigInt16(x)
+#define be16toh(x) OSSwapBigToHostInt16(x)
+#endif
+

namespace myrocks {

/*

RocksDB still fails when building ha_rocksdb.cc. A MariaDB commit [1]
seems related, but it does not apply on top of this Percona version.

• Many tricks in Portfile are borrowed from mysql8. Examples are the

boost workaround, compiler selection, legacysupport port group and
configurations about debug/non-debug variants.

• There are no more sample configuration files. There are no hard-coded

/etc/my.cnf paths found in the Percona code base, either.

• Skip running libmysql_api_test - it doesn't work as it uses absolute

paths for percona dylibs during the build.

• Switch to cmake 1.1 port group

Closes: #55912
Closes: #50960
See: #47197