I've recently installed MySQL server and client 5.5.28 through rpm packages on an openSUSE machine, and I was not able to locate
my.cnf file. I look into all directories
mysql --verbose --help | grep -C3 my.cnf printed which was
/etc/my.cnf (no such a file),
/etc/mysql/my.cnf(no directory as
usr/etc/my.cnf (don't have
etc in my
~/.my.cnf (doesn't exist). Then I tried
find / -name *.cnf which gave me:
/usr/share/doc/MySQL-server-standard-5.0.24a/my-huge.cnf /usr/share/doc/MySQL-server-standard-5.0.24a/my-innodb-heavy-4G.cnf /usr/share/doc/MySQL-server-standard-5.0.24a/my-large.cnf /usr/share/doc/MySQL-server-standard-5.0.24a/my-medium.cnf /usr/share/doc/MySQL-server-standard-5.0.24a/my-small.cnf /usr/share/ssl/openssl.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-innodb-heavy-4G.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf
I want to edit
my.cnf file to practice replication and high availability. I read somewhere that having
my.cnf file won't be necessary to use MySQL well not in my case... so I was thinking to rename one these
my.cnf and put it in the locations that MySQL would look for
my.cnf file. But I'm not sure first if this would work, and second which one to pick to be able to practice replication.
I don't want to make it complex for myself, so I was thinking to take the medium one... Am I doing the right thing?