What's your configuration on the other node? The same config with a different auto-increment offset? Also, what does you mysql slave status look like? (from mysql console, execute 'show slave status\G;')
Here's a sample from an existing, working config (a little different since I'm replicating sqlgrey/sa_bayes): ###### NODE1: ###### Replication configuration for Baruwa server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 500M relay-log-index = /var/log/mysql/slave-relay-bin.index relay-log = /var/log/mysql/slave-relay-bin auto-increment-increment = 2 auto-increment-offset= 1 replicate-do-db = baruwa binlog_do_db = baruwa replicate-do-db = sqlgrey binlog_do_db = sqlgrey #replicate-do-db = sa_bayes binlog_do_db = sa_bayes ---------------- ###### NODE2: ###### Replication configuration for Baruwa server-id = 2 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 500M relay-log-index = /var/log/mysql/slave-relay-bin.index relay-log = /var/log/mysql/slave-relay-bin auto-increment-increment = 2 auto-increment-offset= 2 binlog_do_db = baruwa replicate-do-db = baruwa binlog_do_db = sqlgrey replicate-do-db = sqlgrey #binlog_do_db = sa_bayes replicate-do-db = sa_bayes ---------------- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Carlos R Laguna Sent: Tuesday, June 10, 2014 4:04 PM To: [email protected] Subject: Re: [Baruwa] Baruwa 1.1.2 Cluster questions El 04/06/14 11:04, Morgan, Jeffrey R escribió: > The amount of messages shown in the web interface should reflect the total > amount of received messages among all nodes. You can use the 'Reports' tab > and query/filter by 'Processed by' or by 'Headers' to see individual > processing counts... > > I can't answer the question about NDB since I'm using InnoDB and > master-master replication (with no issues)... as for your MySQL error: is > your MySQL server & Baruwa install hosted on the same box? Any errors in the > mysql log? > >> JR > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Carlos R Laguna > Sent: Monday, June 02, 2014 6:16 PM > To: [email protected] > Subject: [Baruwa] Baruwa 1.1.2 Cluster questions > > I have setup a cluster but if not clear to me if the amount off messages > processed show in the web interface of both server should be equal meaning > node1 + node2 = total of messages ? > > 2 It is save to use NDB mysql cluster instead of mysql native cluster ? > > 3 From the baruwa web interface i am unable to see messages/archives > > this is what it show the apache baruwa-error-logs > > return self.connection.rollback(), referer: > http://mx2.jovenclub.cu/messages/ > [Mon Jun 02 18:10:19 2014] [error] [client 192.168.20.3] > OperationalError: (2006, 'MySQL server has gone away'), referer: > http://mx2.jovenclub.cu/messages/ > i already try to increase thi value in mysql but no make difference > from > 16 to 32 > max_allowed_packet = 32M > > ________________________________________________________________ > XII Edicion del Evento Nacional de Informatica para Jovenes. INFOCLUB. > Septiembre. 2014. Ver www.jovenclub.cu > ________________________________________________________________ > > > -- > Este mensaje ha sido analizado por MailScanner en busca de virus y otros > contenidos peligrosos, y se considera que está limpio. > > > _______________________________________________ > http://pledgie.com/campaigns/12056 > > _______________________________________________ > http://pledgie.com/campaigns/12056 > Thanks for your replay and sorry it took me this long to answer back, i had to put work aside mean while recovering from a terrible fever, so catching up... to give answer to your questions yes baruwa and mysql are running in the same box but the node's write in different mysql master that may be the reason of my problem the other issue is that each node showme different amount of received or processed message, Spam and virus. My replic.cf server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 500M log-slave-updates auto_increment_increment = 2 auto_increment_offset = 1 innodb_flush_log_at_trx_commit = 1 sync_binlog = 1 binlog_do_db = baruwa binlog_ignore_db = mysql binlog_ignore_db = sa_bayes Thank for your time and effort. Regards ________________________________________________________________ XII Edicion del Evento Nacional de Informatica para Jovenes. INFOCLUB. Septiembre. 2014. Ver www.jovenclub.cu ________________________________________________________________ -- Este mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. _______________________________________________ http://pledgie.com/campaigns/12056 _______________________________________________ http://pledgie.com/campaigns/12056
