mysql Reload option!

can someone please explain how does "mysql reload" works comparing to "mysql restart".
I made some changes on my.conf file, and I can't afford to restart mysql server. since "reload" is one of the mysql options (mysql start|restart|stop|force-reload|relaod), I tried it, but it doesn't apply the changes that I made to my.conf.

thanks
CCVOIPAsked:
Who is Participating?
 
GaryConnect With a Mentor Commented:
Suggestions...
I don't see how because of the reasons above, is a few seconds that important?
It's not something I would be overly familiar with but the closest example I found is this which still requires restarting
http://plusbryan.com/mysql-replication-without-downtime
0
 
GaryCommented:
reload reloads the conf files (configuration files) without stopping the server/program which should be pretty much instantaneous

restart stops the server/program and then starts it again which takes time
0
 
CCVOIPAuthor Commented:
thanks for your reply.
if reload reloads the conf files, why it is not working for me. I uncommented two parameter within my.cnf:
   server-id = 1
   log_bin =  /var/log/mysql/mysql-bin.log
and saved the changes, then executed  /etc/init.d/mysql reload
but "show master status" still returns empty set
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
GaryCommented:
Not everything can be reloaded and log_bin would be one of them - that requires a restart - why would you want to change this while running?

I'll see if I can find a comprehensive list
0
 
CCVOIPAuthor Commented:
so the "reload" applies only for a dynamic variables!!
I was asked to set up a replication, and see if there is any way to do it without restarting the mysql server. I wonder if you have any suggestion to achieve that

thanks
0
 
GaryCommented:
Yes, cannot find a list of what you can change but yes dynamic variables that do not adversely affect the MySQL server.
So things like changing paths for example are not gonna work.
0
 
CCVOIPAuthor Commented:
thanks for the link. I am  going to work on it when there is no heavy access to the production server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.