[Maria-discuss] thank you for getting MyRocks into MariaDB 10.2
I look forward to trying it out. -- Mark Callaghan mdcallag@gmail.com
Hi Mark! Thanks for your hard work on MyRocks too :) Do you know if TokuDB hotbackup works for MyRocks? Or if there's an easy way to hotbackup with both TokuDB and MyRocks tables? I'm planning to convert a few TokuDB tables to test MyRocks in production... Jocelyn Le 23/05/2017 à 19:40, MARK CALLAGHAN a écrit :
I look forward to trying it out.
-- Mark Callaghan mdcallag@gmail.com <mailto:mdcallag@gmail.com>
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
I don't have MyRocks storage engine on my MariaDB 10.2.6 server according to SHOW ENGINES. So either it is not available in Windows yet or it is a plugin that must be enabled like is the case with TokuDB. It is an important storage engine and has to potential to become as big as InnoDB IMO (unlike TokuDB). -- Peter On Wed, May 24, 2017 at 9:35 AM, jocelyn fournier < jocelyn.fournier@gmail.com> wrote:
Hi Mark!
Thanks for your hard work on MyRocks too :) Do you know if TokuDB hotbackup works for MyRocks? Or if there's an easy way to hotbackup with both TokuDB and MyRocks tables? I'm planning to convert a few TokuDB tables to test MyRocks in production...
Jocelyn
Le 23/05/2017 à 19:40, MARK CALLAGHAN a écrit :
I look forward to trying it out.
-- Mark Callaghan mdcallag@gmail.com
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
Sorry .. please ignore my mail. It was intended for other recipients. -- Peter On Wed, May 24, 2017 at 12:22 PM, Peter Laursen <peter_laursen@webyog.com> wrote:
I don't have MyRocks storage engine on my MariaDB 10.2.6 server according to SHOW ENGINES. So either it is not available in Windows yet or it is a plugin that must be enabled like is the case with TokuDB. It is an important storage engine and has to potential to become as big as InnoDB IMO (unlike TokuDB).
-- Peter
On Wed, May 24, 2017 at 9:35 AM, jocelyn fournier < jocelyn.fournier@gmail.com> wrote:
Hi Mark!
Thanks for your hard work on MyRocks too :) Do you know if TokuDB hotbackup works for MyRocks? Or if there's an easy way to hotbackup with both TokuDB and MyRocks tables? I'm planning to convert a few TokuDB tables to test MyRocks in production...
Jocelyn
Le 23/05/2017 à 19:40, MARK CALLAGHAN a écrit :
I look forward to trying it out.
-- Mark Callaghan mdcallag@gmail.com
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
On 24.05.2017 12:22, Peter Laursen wrote:
I don't have MyRocks storage engine on my MariaDB 10.2.6 server according to SHOW ENGINES. So either it is not available in Windows yet or it is a plugin that must be enabled like is the case with TokuDB. It is an important storage engine and has to potential to become as big as InnoDB IMO (unlike TokuDB). It is available on Windows, but only in 64bit. And it is a plugin, you need install soname 'ha_rocksdb'
as described in https://mariadb.com/kb/en/mariadb/getting-started-with-myrocks/
-- Peter
On Wed, May 24, 2017 at 9:35 AM, jocelyn fournier <jocelyn.fournier@gmail.com <mailto:jocelyn.fournier@gmail.com>> wrote:
Hi Mark!
Thanks for your hard work on MyRocks too :) Do you know if TokuDB hotbackup works for MyRocks? Or if there's an easy way to hotbackup with both TokuDB and MyRocks tables? I'm planning to convert a few TokuDB tables to test MyRocks in production...
Jocelyn
Le 23/05/2017 à 19:40, MARK CALLAGHAN a écrit :
I look forward to trying it out.
-- Mark Callaghan mdcallag@gmail.com <mailto:mdcallag@gmail.com>
_______________________________________________ Mailing list:https://launchpad.net/~maria-discuss <https://launchpad.net/%7Emaria-discuss> Post to :maria-discuss@lists.launchpad.net <mailto:maria-discuss@lists.launchpad.net> Unsubscribe :https://launchpad.net/~maria-discuss <https://launchpad.net/%7Emaria-discuss> More help :https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss <https://launchpad.net/%7Emaria-discuss> Post to : maria-discuss@lists.launchpad.net <mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss <https://launchpad.net/%7Emaria-discuss> More help : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
I have figured out already. Found the link myself. Thanks anyway. -- Peter On Wed, May 24, 2017 at 1:45 PM, Vladislav Vaintroub <vvaintroub@gmail.com> wrote:
On 24.05.2017 12:22, Peter Laursen wrote:
I don't have MyRocks storage engine on my MariaDB 10.2.6 server according to SHOW ENGINES. So either it is not available in Windows yet or it is a plugin that must be enabled like is the case with TokuDB. It is an important storage engine and has to potential to become as big as InnoDB IMO (unlike TokuDB).
It is available on Windows, but only in 64bit. And it is a plugin, you need install soname 'ha_rocksdb'
as described in https://mariadb.com/kb/en/mariadb/getting-started-with- myrocks/
-- Peter
On Wed, May 24, 2017 at 9:35 AM, jocelyn fournier < jocelyn.fournier@gmail.com> wrote:
Hi Mark!
Thanks for your hard work on MyRocks too :) Do you know if TokuDB hotbackup works for MyRocks? Or if there's an easy way to hotbackup with both TokuDB and MyRocks tables? I'm planning to convert a few TokuDB tables to test MyRocks in production...
Jocelyn
Le 23/05/2017 à 19:40, MARK CALLAGHAN a écrit :
I look forward to trying it out.
-- Mark Callaghan mdcallag@gmail.com
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
On Wed, May 24, 2017 at 12:35 AM, jocelyn fournier < jocelyn.fournier@gmail.com> wrote:
Hi Mark!
Thanks for your hard work on MyRocks too :) Do you know if TokuDB hotbackup works for MyRocks? Or if there's an easy way to hotbackup with both TokuDB and MyRocks tables? I'm planning to convert a few TokuDB tables to test MyRocks in production...
I am not aware of a tool for that. -- Mark Callaghan mdcallag@gmail.com
On Wednesday, 24 May 2017 18:29:26 CEST MARK CALLAGHAN wrote:
On Wed, May 24, 2017 at 12:35 AM, jocelyn fournier <
jocelyn.fournier@gmail.com> wrote:
Hi Mark!
Thanks for your hard work on MyRocks too :) Do you know if TokuDB hotbackup works for MyRocks? Or if there's an easy way to hotbackup with both TokuDB and MyRocks tables? I'm planning to convert a few TokuDB tables to test MyRocks in production...
I am not aware of a tool for that.
What about myrocks_hotbackup? Wouldn't work for both TokuDB and MyRocks, but it would at least cover the latter, no? I have no idea how well it works with the version of MyRocks in MariaDB however. https://github.com/facebook/mysql-5.6/wiki/Physical-backup-with-myrocks_hotb... Grs, Heinz
On Wed, May 24, 2017 at 12:35 PM, Heinz Wiesinger <HMWiesinger@liwjatan.at> wrote:
On Wednesday, 24 May 2017 18:29:26 CEST MARK CALLAGHAN wrote:
On Wed, May 24, 2017 at 12:35 AM, jocelyn fournier <
jocelyn.fournier@gmail.com> wrote:
Hi Mark!
Thanks for your hard work on MyRocks too :) Do you know if TokuDB hotbackup works for MyRocks? Or if there's an easy way to hotbackup with both TokuDB and MyRocks tables? I'm planning to convert a few TokuDB tables to test MyRocks in production...
I am not aware of a tool for that.
What about myrocks_hotbackup? Wouldn't work for both TokuDB and MyRocks, but it would at least cover the latter, no? I have no idea how well it works with the version of MyRocks in MariaDB however.
https://github.com/facebook/mysql-5.6/wiki/Physical- backup-with-myrocks_hotbackup
myrocks_hotbackup is an option for MyRocks. I have yet to install MariaDB 10.2.6 and don't know whether they included it. I know it is frequently used. -- Mark Callaghan mdcallag@gmail.com
participants (5)
-
Heinz Wiesinger -
jocelyn fournier -
MARK CALLAGHAN -
Peter Laursen -
Vladislav Vaintroub