RE: 4.0.20 replication

DePhillips, Michael P writes:
> Hello Sinisa
> 
> > Seems like we shall need to take a deeper look at this.
> OK.
> 
> > Can you send us your master my.cnf
> 
> # The following options will be passed to all MySQL clients
> [client]
> port            = 3306
> socket          = /tmp/mysql.3306.sock
> 
> # Here follows entries for some specific programs
> 
> # The MySQL server
> [mysqld]
> port            = 3306
> socket          = /tmp/mysql.3306.sock
> datadir         = /db01/offline/data
> skip-locking
> set-variable    = key_buffer=256M
> set-variable    = max_allowed_packet=1M
> set-variable    = table_cache=1024
> set-variable    = max_connections=512
> set-variable    = sort_buffer=1M
> set-variable    = record_buffer=1M
> set-variable    = myisam_sort_buffer_size=64M
> set-variable    = thread_cache=8
> set-variable    = thread_concurrency=8  # Try number of CPU's*2
> log-bin
> server-id       = 880673316
> 
> [mysqldump]
> quick
> set-variable    = max_allowed_packet=16M
> 
> [mysql]
> no-auto-rehash
> 
> 
> >tell us what to do exactly to get 110 or more connections for 10 slaves ??
>   BTW. It will increase to 512 if I let it (see max-connections above)
> 
> The machine its running on:
> uname -a Linux robinson.star.bnl.gov 2.4.20-30.7.legacysmp #1 SMP Fri Feb 20
> 10:12:55 PST 2004 i686 unknown
> 
> The slaves are on similar machines running your binaries of versions ranging
> from 4.0.16 to 4.0.20.
> 
> I've been running this type of replication for years, and with no problems.
> I've done nothing different or special in setting this up.  It is pretty
> much done right our of Paul's book.  
> 
> One point you will be interested in...
> I've recently upgraded the master from 3.23.58 to 4.0.20, this is when the
> problem began. All my slaves where 4.0.xx for over a year now. (yes I ran
> mysql_fix_privilege_tables).
> 
> Replication is being done. Show master status corresponds to show slave
> status etc.  The connections, however, keep growing.
> 
> I gladly supply any information I can and help in any way possible.  Also I
> was going to drop back a version on the master, but I'll keep this one
> running as long as I know your working on the problem.
> 
> Thanks
> Michael
> 
> 

Hi!

We do need some more info.

Just check that server-id is different on all slaves and dffers from
the master.

Also, send us slave info for 3 or 4 of your slaves.

We need replication user , it's privileges and output from SHOW SLAVE
STATUS from the same 3 or 4 slave installations.

-- 

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Full time Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus



-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]