mcrauwel

node default {
 
  class { '::proxysql':
    listen_port              => 3306,
    admin_username           => 'admin',
    admin_password           => Sensitive('654321'),
    monitor_username         => 'monitor',
    monitor_password         => Sensitive('123456'),
    override_config_settings => {
      mysql_variables => {

mcrauwel

#!/usr/bin/python
#
# Convert a Row-Based-Replication binary log to Statement-Based-Replication format, cheating a little.
# This script exists since Percona Toolkit's pt-query-digest cannot digest RBR format. The script
# generates enough for it to work with.
# Expecting standard input
# Expected input is the output of "mysqlbinlog --verbose --base64-output=DECODE-ROWS <binlog_file_name>"
# For example:
# $ mysqlbinlog --verbose --base64-output=DECODE-ROWS mysql-bin.000006 | python binlog-rbr-to-sbr.py | pt-query-digest --type=binlog --order-by Query_time:cnt --group-by fingerprint
#