This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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 | |
# |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 => { |