New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add option for enabling both rocksdb and innodb storage engines at the same time. #106

Open
hermanlee opened this Issue Nov 17, 2015 · 2 comments

Comments

Projects
None yet
4 participants
@hermanlee
Contributor

hermanlee commented Nov 17, 2015

When the innodb storage engine comes up, the rocksdb storage engine is automatically disabled due to problems in support both transaction engines, or determining how crash safety is handled. However, there are some use cases where it would be nice to test with both storage engines running on the same server instance.

Add an option to mysqld that would allow enabling both storage engines to come up. By default, the option is disabled.

@mdcallag

This comment has been minimized.

Show comment
Hide comment
@mdcallag

mdcallag Oct 12, 2016

Supported in FB MySQL via option --allow-multiple-engines
c380d14

This was disabled out of fear that people would try to use XA between engines. Most of us prefer to avoid that. But the problem (and fear) exists between any pair of transactional engines -- InnoDB+TokuDB, InnoDB+RocksDB, RocksDB + TokuDB.

mdcallag commented Oct 12, 2016

Supported in FB MySQL via option --allow-multiple-engines
c380d14

This was disabled out of fear that people would try to use XA between engines. Most of us prefer to avoid that. But the problem (and fear) exists between any pair of transactional engines -- InnoDB+TokuDB, InnoDB+RocksDB, RocksDB + TokuDB.

@mdcallag

This comment has been minimized.

Show comment
Hide comment
@mdcallag

mdcallag Nov 19, 2016

allow-multiple-engines doesn't appear as a server variable. It should.

bin/mysql -uroot -p -e 'show global variables' | grep -i multiple

mdcallag commented Nov 19, 2016

allow-multiple-engines doesn't appear as a server variable. It should.

bin/mysql -uroot -p -e 'show global variables' | grep -i multiple

@mdcallag mdcallag reopened this Nov 19, 2016

@gunnarku gunnarku added the mid-pri label Apr 6, 2017

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment