Binlog file changes its name
Hi, I have also found that the master bin log file changing its name from myhostname-bin. to mysql.XXX and to other different names. I am running mysql Ver 11.12 Distrib 3.23.33, for hp-hpux11.00 (hppa2.0w). When I did sar -v 5 I found that inod-sz is on maximum: 14:39:05 text-sz ov proc-sz ov inod-sz ov file-sz ov 14:39:10 N/A N/A 185/2048 0 2248/2248 0 7789/10010 0 Is there any relation between inod size and the changing of the master bin log file? Any help would be appreciated. Regards, Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Binlogfile change its name
Hi, I have also found that the master bin log file changing its name from myhostname-bin. to mysql.XXX and to other different names. I am running mysql Ver 11.12 Distrib 3.23.33, for hp-hpux11.00 (hppa2.0w). When I did sar -v 5 I found that inod-sz is on maximum: 14:39:05 text-sz ov proc-sz ov inod-sz ov file-sz ov 14:39:10 N/A N/A 185/2048 0 2248/2248 0 7789/10010 0 Is there any relation between inod size and the changing of the master bin log file? Any help would be appreciated. Regards, Tedy Aulia -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to reload my.cnf?
Hi Gleb, I understand that the replication shouldn't break, but restarting master means losing the updates made to the master database, which we can't afford to do that. TA Hello. Why are you afraid of shutting down the server for a while? Is it so critical? If yes, send more detailed description of your situation. Replication shouldn't break. From: http://dev.mysql.com/doc/refman/5.0/en/replication-features.html It is safe to shut down a master server and restart it later. Tedy Aulia wrote: Hi Gleb, Thanks for your reply. I am using MySQL 3.23.33. The ones that I will need to add in my.cnf are the syncronisation parameters as follow: binlog-do-db=XYZ replicate-do-db=XYZ replicate-ignore-table=XYZ.table1 replicate-ignore-table=XYZ.table2 replicate-ignore-table=XYZ.table3 Database XYZ was in synch for the past 12 months, I have found database is not in synch anymore as the parameters I mentioned above are missing in my.cnf. I want to put back those parameters but I can't afford to restart the server as MySQL server is also used by other database which is currently in synch and runs happily. Cheers, TA Hello. You can change some variables without restarting the server. See: http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html Tedy Aulia wrote: Hi All, I will need to change my.cnf in master machine, but I can't afford to restart MySQL server as the server has been used for heavy traffic databases. Can anyone tell me how to do it? Cheers, *Tedy Aulia*
Re: How to reload my.cnf?
Hi Gleb, Thanks for your reply. I am using MySQL 3.23.33. The ones that I will need to add in my.cnf are the syncronisation parameters as follow: binlog-do-db=XYZ replicate-do-db=XYZ replicate-ignore-table=XYZ.table1 replicate-ignore-table=XYZ.table2 replicate-ignore-table=XYZ.table3 Database XYZ was in synch for the past 12 months, I have found database is not in synch anymore as the parameters I mentioned above are missing in my.cnf. I want to put back those parameters but I can't afford to restart the server as MySQL server is also used by other database which is currently in synch and runs happily. Cheers, TA Hello. You can change some variables without restarting the server. See: http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html Tedy Aulia wrote: Hi All, I will need to change my.cnf in master machine, but I can't afford to restart MySQL server as the server has been used for heavy traffic databases. Can anyone tell me how to do it? Cheers, *Tedy Aulia* -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@/stripped/ /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com
How to reload my.cnf?
Hi All, I will need to change my.cnf in master machine, but I can't afford to restart MySQL server as the server has been used for heavy traffic databases. Can anyone tell me how to do it? Cheers, *Tedy Aulia*
RE: Master Log Files
Thanks for your reply Gleb, I understand that we can setup the binlogfile name in 'my.cnf' file, but I am sure that there is no change in the 'my.cnf'. The hostname program reports the machine name correctly i.e. foo. Cheers, Tedy -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Thursday, 1 September 2005 1:47 PM To: mysql@lists.mysql.com Subject: Re: Master Log Files Hello. Program options can be specified in different ways, check them all. See: http://dev.mysql.com/doc/mysql/en/program-options.html What name does the hostname program reports? Tedy Aulia [EMAIL PROTECTED] wrote: Hi All, I have found that the binlogfiles have changed their name. Initially the files were using the name of the server followed by the number i.e. foo.###. Since two weeks ago the binlog files have changed to be mysql.###. As far as I remember there is no change in my.cnf file so far. I am using MySQL version 3.23.33 Could someone explain why the case I mentioned above has happened? Your help would be appreciated. Cheers, Tedy Aulia -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Master Log Files
Thanks for your reply Gleb, I understand that we can setup the binlogfile name in 'my.cnf' file, but I am sure that there is no change in the 'my.cnf'. The hostname program reports the machine name correctly i.e. foo. Cheers, Tedy -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Thursday, 1 September 2005 1:47 PM To: mysql@lists.mysql.com Subject: Re: Master Log Files Hello. Program options can be specified in different ways, check them all. See: http://dev.mysql.com/doc/mysql/en/program-options.html What name does the hostname program reports? Tedy Aulia [EMAIL PROTECTED] wrote: Hi All, I have found that the binlogfiles have changed their name. Initially the files were using the name of the server followed by the number i.e. foo.###. Since two weeks ago the binlog files have changed to be mysql.###. As far as I remember there is no change in my.cnf file so far. I am using MySQL version 3.23.33 Could someone explain why the case I mentioned above has happened? Your help would be appreciated. Cheers, Tedy Aulia -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Master Log Files
Hi All, I have found that the binlogfiles have changed their name. Initially the files were using the name of the server followed by the number i.e. foo.###. Since two weeks ago the binlog files have changed to be mysql.###. As far as I remember there is no change in my.cnf file so far. I am using MySQL version 3.23.33 Could someone explain why the case I mentioned above has happened? Your help would be appreciated. Cheers, Tedy Aulia