Google datastudio connect MySQL 8 problem

Workaround is tu use proxysql

mysql_query_rules:

{
rule_id=1
active=1
match_pattern="\@\@query_cache_size"
replace_pattern="null"
apply=0
},
{
rule_id=2
active=1
match_pattern="\@\@query_cache_type"
replace_pattern="null"
apply=0
},
{
rule_id=3
active=1
match_pattern="\@\@tx_isolation"
replace_pattern="null"
apply=0
},

Leave a Reply

Your email address will not be published. Required fields are marked *