tag:blogger.com,1999:blog-18125890.post2991654100339873619..comments2023-09-24T15:25:32.807+05:30Comments on Naresh: Install TokuDB Mysql Server along with Existing mysql-server on Centos/Ubuntu Server Nareshhttp://www.blogger.com/profile/18187716902126738230noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-18125890.post-85603485492748756012014-06-06T11:42:16.354+05:302014-06-06T11:42:16.354+05:30AFAIK, we can use MariaDB which has tokudb plugin ...AFAIK, we can use MariaDB which has tokudb plugin available for use. So, the steps would look like this<br /><br />1. Take backup of existing mysql data (mysqldump)<br />2. Uninstall mysql packages<br />3. Install MariaDB packages and enable tokudb from /etc/my.cnf.d/tokudb.conf<br />4. (use exact same settings for newer mariadb for innodb stuff)<br />5. Alter tables to use tokudb<br /><br />or<br /><br />compile the tokudb plugin for existing mysql server<br /><br />HTHNareshhttps://www.blogger.com/profile/18187716902126738230noreply@blogger.comtag:blogger.com,1999:blog-18125890.post-47875126035988333732014-06-03T15:43:31.652+05:302014-06-03T15:43:31.652+05:30Hi Naresh,
I think what Vamsi meant is if it is p...Hi Naresh,<br /><br />I think what Vamsi meant is if it is possible to patch somehow the existing, factory mysql to allow conversion of innodb to tokudb engine, without installing a fresh patched mysql (with tokudb). This is my question also. Panayiotis Omirouhttps://www.blogger.com/profile/03801418532180038846noreply@blogger.comtag:blogger.com,1999:blog-18125890.post-36422353871162062492014-04-24T11:01:35.114+05:302014-04-24T11:01:35.114+05:30Vamsi,
Yes, it is possible to convert the data. B...Vamsi,<br /><br />Yes, it is possible to convert the data. But, make sure to go through the User guide[1] to understand the differences between engines. (Read the FAQ for sure)<br /><br />[1] http://www.tokutek.com/wp-content/uploads/2014/03/mysql-5.5.36-tokudb-7.1.5-users-guide.pdfNareshhttps://www.blogger.com/profile/18187716902126738230noreply@blogger.comtag:blogger.com,1999:blog-18125890.post-1257227711906213102014-04-24T10:12:06.070+05:302014-04-24T10:12:06.070+05:30Hi Naresh,
Article of Tokudb is pretty informativ...Hi Naresh,<br /><br />Article of Tokudb is pretty informative,Just need few clarifications.<br /><br />#if i have data of 200GB in MySQL version 5.6 with innodb engine,is it possible to install tokudb engine in existing mysql and convert the tables with innodb to tokudb engine?anand vamsihttps://www.blogger.com/profile/03207477556343624216noreply@blogger.com