[Maria-discuss] thank you for getting MyRocks into MariaDB 10.2
I look forward to trying it out.
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.
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.
participants (5)
-
Heinz Wiesinger -
jocelyn fournier -
MARK CALLAGHAN -
Peter Laursen -
Vladislav Vaintroub