CODEWITHSUNDEEP
mysqlamazon-ec2parametersmariadbmariadb-10.3
JollyRoger
JollyRoger

Reputation: 53

where is the default system variable value is configured in mariadb?

I am looking to find where the system variable "binlog_format" is configured in mariadb on EC2(10.3.29-MariaDB-0ubuntu0.20.04). However running "show variables" display the binlog format.

this value should be configured somewhere and i cannot seem to find it anywhere?

I have checked in the following places

mysql --help | grep "Default options" -A 1

Default options are read from the following files in the given order:

/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf 
& /etc/initi.d/*

If this is not explicitly configured(since default value is MIXED in mariadb), can i safely assume i can overwrite this value under [mysqld]?

OR run "SET GLOBAL binlog_format=ROW" ?

please advise

Upvotes: 0

Views: 111

Answers (0)

Related Questions