Hello,
I set up a replication architecture with MySql
everything works fine.
Now I concentrate on log-bin file and I have a question
I have understood (I hope... )
-that I can set a max_binlog_size,
-that a new file (extension n+1) will be used while reaching max_binlog_size,
-that the slave will know the new log-bin filename and position
so doing a 'purge master logs' will remove previous files ok, but
what is the high limit for the extension value ?
This question because a set up a mysql server,
running for months and months without stopping,
and with a lot of insert/update
In over words how to set a initial extension value WITHOUT stopping master nor slave ?
According to me, the only solution is doing a 'reset master' with a lot of care like :
("lock master"; "sync slave"; "reset master"; "reset slave"; "unlock master")
But doing a "lock master" seem to me dangerous for many reasons
Do I misunderstood something ?
Regards
--
Bernard CHAMBON
IN2P3 / CNRS (Centre de Calcul de LYON)
email: mailto:[EMAIL PROTECTED]
Tel : 04 72 69 42 18
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
