Merge lp:~hrvojem/percona-server/bug1379211-5.6 into lp:percona-server/5.6

Proposed by Hrvoje Matijakovic on 2014-10-10
Status: Merged
Approved by: Laurynas Biveinis on 2014-10-12
Approved revision: 677
Merged at revision: 679
Proposed branch: lp:~hrvojem/percona-server/bug1379211-5.6
Merge into: lp:percona-server/5.6
Diff against target: 70 lines (+55/-0)
2 files modified
doc/source/index.rst (+1/-0)
doc/source/tokudb/removing_tokudb.rst (+54/-0)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug1379211-5.6
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) 2014-10-10 Approve on 2014-10-12
Review via email: mp+237929@code.launchpad.net
To post a comment you must log in.
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/index.rst'
2--- doc/source/index.rst 2014-10-07 07:12:53 +0000
3+++ doc/source/index.rst 2014-10-10 09:41:14 +0000
4@@ -161,6 +161,7 @@
5 tokudb/using_tokudb
6 tokudb/tokudb_compression
7 tokudb/tokudb_multiple_clustering_keys
8+ tokudb/removing_tokudb
9
10 Reference
11 =========
12
13=== added file 'doc/source/tokudb/removing_tokudb.rst'
14--- doc/source/tokudb/removing_tokudb.rst 1970-01-01 00:00:00 +0000
15+++ doc/source/tokudb/removing_tokudb.rst 2014-10-10 09:41:14 +0000
16@@ -0,0 +1,54 @@
17+.. _removing_tokudb:
18+
19+================================
20+ Removing TokuDB storage engine
21+================================
22+
23+In case you want remove the TokuDB storage engine from |Percona Server| without causing any errors following is the recommended procedure:
24+
25+Change the tables from TokuDB to InnoDB
26+---------------------------------------
27+
28+If you still need the data in the TokuDB tables you'll need to alter the tables to other supported storage engine i.e., |InnoDB|:
29+
30+.. code-block:: mysql
31+
32+ mysql> ALTER TABLE City ENGINE=InnoDB;
33+
34+.. note::
35+
36+ In case you remove the TokuDB storage engine before you've changed your tables to other supported storage engine you won't be able to access that data without re-installing the TokuDB storage engine.
37+
38+Removing the plugins
39+--------------------
40+
41+Storage engine requires manual removal:
42+
43+.. code-block:: mysql
44+
45+ UNINSTALL PLUGIN tokudb;
46+ UNINSTALL PLUGIN tokudb_file_map;
47+ UNINSTALL PLUGIN tokudb_fractal_tree_info;
48+ UNINSTALL PLUGIN tokudb_fractal_tree_block_map;
49+ UNINSTALL PLUGIN tokudb_trx;
50+ UNINSTALL PLUGIN tokudb_locks;
51+ UNINSTALL PLUGIN tokudb_lock_waits;
52+
53+After the engine and the plugins have been uninstalled you can remove the TokuDB package by using the apt/yum commands:
54+
55+.. code-block:: bash
56+
57+ [root@centos ~]# yum remove Percona-Server-tokudb-56.x86_64
58+
59+or
60+
61+.. code-block:: bash
62+
63+ root@wheezy:~# apt-get remove percona-server-tokudb-5.6
64+
65+.. note::
66+
67+ Make sure you've removed all the TokuDB specific variables from your configuration file (:file:`my.cnf`) before you restart the server, otherwise server could show errors or warnings and won't be able to start.
68+
69+
70+

Subscribers

People subscribed via source and target branches