Comments on: MySQL Ripple: The First Impression of a MySQL Binlog Server https://www.percona.com/blog/mysql-ripple-first-impression-of-mysql-binlog-server/ Wed, 07 Aug 2019 13:28:35 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Jean-François Gagné https://www.percona.com/blog/mysql-ripple-first-impression-of-mysql-binlog-server/#comment-10970830 Sun, 26 May 2019 11:26:08 +0000 https://www.percona.com/blog/?p=55772#comment-10970830 LeFred talks about binary packages in below:
https://lefred.be/content/ripple-binlog-server-for-mysql/

]]>
By: Sveta Smirnova https://www.percona.com/blog/mysql-ripple-first-impression-of-mysql-binlog-server/#comment-10970592 Mon, 08 Apr 2019 20:55:58 +0000 https://www.percona.com/blog/?p=55772#comment-10970592 It has two options:

-ripple_purge_expire_logs_days (Purge binlog files older than this days
(0=disable). This is evaluated independently of ripple_purge_keep_size.)
type: int32 default: 0
-ripple_purge_logs_keep_size (Purge binlog files if total size exeeds this
value (0=disable). This is evaluated independently of
ripple_purge_expire_logs_days.) type: uint64 default: 0

I am not sure if this is what you need. But if you have a multiple master you can use multiple rippled instances for the better purge tuning.

]]>
By: Sveta Smirnova https://www.percona.com/blog/mysql-ripple-first-impression-of-mysql-binlog-server/#comment-10970591 Mon, 08 Apr 2019 20:53:33 +0000 https://www.percona.com/blog/?p=55772#comment-10970591 I did not find filters among its options.

]]>
By: Piotr Mazurkiewicz https://www.percona.com/blog/mysql-ripple-first-impression-of-mysql-binlog-server/#comment-10970569 Fri, 05 Apr 2019 10:18:35 +0000 https://www.percona.com/blog/?p=55772#comment-10970569 Does Ripple have similar functionality as mysqld, i.e. filtering tables (–replicate- * options)?

]]>
By: vo https://www.percona.com/blog/mysql-ripple-first-impression-of-mysql-binlog-server/#comment-10970492 Sat, 23 Mar 2019 08:30:58 +0000 https://www.percona.com/blog/?p=55772#comment-10970492 Looking forward for binary packages of this in the Percona yum repository, it would be useful for us!

]]>
By: Scott Klasing https://www.percona.com/blog/mysql-ripple-first-impression-of-mysql-binlog-server/#comment-10970486 Wed, 20 Mar 2019 16:39:27 +0000 https://www.percona.com/blog/?p=55772#comment-10970486 Does anyone know if Ripple manages the number of expire_logs_days for each M/S relationship?

I am very interested in this, not so much for relaying to many, many slaves, but to see if it will serve as a temporary stop gap for very large MANY TB databases, as in 30TB, where their 3TB binlog space is not large enough to accommodate storing enough days to SAFELY do backups. The binlog data transfer on these databases is > 41GB per hour, so to date XTRABACKUP is unable to backup the data; continuously errors out on logs wrapping. Past experience we increased log file sizes from 2GB to 6GB and it usually resolved these issues, but as of recent not even 41GB log file sizes were enough.

In summary we are now LFTP..ing one of the databases offline slaves to rebuild it, thus the expire_logs_days issue risks shorting binlog space while we risk an estimated 3.5 day copy with 6 days of logs.

Yes I would love to redesign these databases, sharding to multiple smaller nodes, but management has been unwilling to improve its design. Any insights appreciated!

]]>
By: Daniël van Eeden https://www.percona.com/blog/mysql-ripple-first-impression-of-mysql-binlog-server/#comment-10970471 Sun, 17 Mar 2019 14:44:56 +0000 https://www.percona.com/blog/?p=55772#comment-10970471 I added –ripple_master_password some time ago ( https://github.com/google/mysql-ripple/pull/5 ). I have open pull requests to add support for authenticating clients with mysql_native_password and handle MySQL 8.0 clients, which need AuthSwitchRequest/AuthSwitchResponse as it stubbornly tries to use caching_sha2_password.

]]>
By: Bajrang Panigrahi https://www.percona.com/blog/mysql-ripple-first-impression-of-mysql-binlog-server/#comment-10970470 Sat, 16 Mar 2019 08:26:56 +0000 https://www.percona.com/blog/?p=55772#comment-10970470 Interesting. We so also use the black hole storage engine, but this looks great will explore more into it.

Thanks for sharing.

]]>