Gentoo Archives: gentoo-commits

From: "Robin H. Johnson" <robbat2@g.o>
To: gentoo-commits@l.g.o
Subject: [gentoo-commits] proj/gentoo-news:master commit in: 2013/2013-06-01-mysql-pbxt-dropped/
Date: Sun, 02 Jun 2013 19:44:12
Message-Id: 1370202233.d26774080551f4b7d70f1ec2e4dc653df3cf3b1a.robbat2@gentoo
1 commit: d26774080551f4b7d70f1ec2e4dc653df3cf3b1a
2 Author: Robin H. Johnson <robbat2 <AT> gentoo <DOT> org>
3 AuthorDate: Sun Jun 2 19:43:53 2013 +0000
4 Commit: Robin H. Johnson <robbat2 <AT> gentoo <DOT> org>
5 CommitDate: Sun Jun 2 19:43:53 2013 +0000
6 URL: http://sources.gentoo.org/gitweb/?p=proj/gentoo-news.git;a=commit;h=d2677408
7
8 PBXT now unsupported in MySQL/MariaDB
9
10 Signed-off-by: Robin H. Johnson <robbat2 <AT> gentoo.org>
11
12 ---
13 .../2013-06-01-mysql-pbxt-dropped.txt | 41 ++++++++++++++++++++++
14 1 file changed, 41 insertions(+)
15
16 diff --git a/2013/2013-06-01-mysql-pbxt-dropped/2013-06-01-mysql-pbxt-dropped.txt b/2013/2013-06-01-mysql-pbxt-dropped/2013-06-01-mysql-pbxt-dropped.txt
17 new file mode 100644
18 index 0000000..5b759b8
19 --- /dev/null
20 +++ b/2013/2013-06-01-mysql-pbxt-dropped/2013-06-01-mysql-pbxt-dropped.txt
21 @@ -0,0 +1,41 @@
22 +Title: PBXT now unsupported in MySQL/MariaDB
23 +Author: Robin H. Johnson <robbat2@g.o>
24 +Content-Type: text/plain
25 +Posted: 2013-06-01
26 +Revision: 2
27 +News-Item-Format: 1.0
28 +Display-If-Installed: dev-db/mysql[pbxt,-minimal]
29 +Display-If-Installed: dev-db/mysql-cluster[pbxt,-minimal]
30 +Display-If-Installed: dev-db/mariadb[pbxt,-minimal]
31 +Display-If-Installed: dev-db/mariadb-galera[pbxt,-minimal]
32 +Display-If-Installed: dev-db/percona-server[pbxt,-minimal]
33 +Display-If-Installed: dev-db/google-mysql[pbxt,-minimal]
34 +
35 +The PBXT/PrimeBase engine is unsupported upstream in MySQL & MariaDB for some
36 +time now [1]. It is no longer built in the upstream MariaDB 5.5 binaries[2][3]
37 +and if it is enabled in a source build, it fails many tests [4].
38 +
39 +In light of this, the MySQL team has decided to mask it in
40 +profiles/base/package.use.mask for all relevant packages.
41 +>=dev-db/mysql-5.5 pbxt
42 +>=dev-db/mysql-cluster-5.5 pbxt # overlay
43 +>=dev-db/mariadb-5.5 pbxt
44 +>=dev-db/mariadb-galera-5.5 pbxt # overlay
45 +>=dev-db/percona-server-5.5 pbxt # overlay
46 +>=dev-db/google-mysql-5.5 pbxt # overlay
47 +
48 +All users who have data stored in PBXT-backed tables MUST convert the tables
49 +to another format BEFORE upgrading to MySQL/MariaDB 5.5, as the tables will
50 +become inaccessible otherwise.
51 +
52 +We will continue to allow it to be built in the 5.0/5.1 series, to make the
53 +above data migration easy, but we strongly encourage all users to move their
54 +data out of the PBXT engine.
55 +
56 +If you need to check for PBXT tables easily, look in your MySQL/MariaDB
57 +datadir for any files with a .xt extension.
58 +
59 +1. https://lists.launchpad.net/pbxt-discuss/msg00134.html
60 +2. http://www.bytebot.net/blog/archives/2012/05/25/mariadb-5-5-has-deprecated-pbxt
61 +3. https://kb.askmonty.org/en/about-pbxt/
62 +4. https://bugs.gentoo.org/show_bug.cgi?id=471616#c1