Vicibox MySQL Master Slave Replication

[randy_delgado_03]

Good Day Everyone,

Guys here's the scenario:

I already established the Master-Slave Replication between Vicibox DB installation and a replication server, however when i try to let our agents login, the web server hangs. CPU process goes to its peak (Intel I7 8 core CPU 3.4 gigz). When i removed the replication and let the agents login, CPU went back to its daily average process like it should be.

Has someone did the same setup and successfully made a Master-Slave Replication without any conflicts?

Any suggestions would be highly appreciated ...

Thank you vicidial team ...

[williamconley]

I know this will sound simplistic ... could you post your EXACT method of master/slave replication? (including .cnf settings that have been changed?)

Only changes, now, don't go posting entire conf files ...

[randy_delgado_03]

Here's what i changed william:

"Master"

server-id=1
sync_binlog=1
binlog-do-db=[db_to_replicate] < just add another one of this line to add db to publish
log-bin=mysql-bin
binlog_format=mixed
server-id=1
innodb_flush_log_at_trx_commit = 1

"Slave"

server-id=2
log-bin=mysql-bin
binlog_format=mixed
master-connect-retry=60
replicate-do-db=asterisk
relay-log=mysqld-relay-bin
relay-log-index=mysqld-relay-bin.index

[williamconley]

is that ...ALL you changed?

i'm bettin' there's a bit more ...

[randy_delgado_03]

Yes william thats all i configured, the rest are all defaults.

Do you happen to have a sample config of my.cnf that you setted up on vicibox and works for replication purposes without any conflicts?

Thank you william ...

[williamconley]

not that I have access to at present.

how did you tell slave and/or master the location of the other server? (are you sure you didn't change anything else ).

also: what are you using the slave server for? (reporting or something more involved?) I know it shouldn't matter, but often that question gives rise to other things going on that may cause an issue.

[randy_delgado_03]

I configured this inside the slave console:

CHANGE MASTER TO MASTER_HOST='x.x.x.x', MASTER_USER='repl_user', MASTER_PASSWORD='repl_password', MASTER_LOG_FILE='mysql-bin.000010', MASTER_LOG_POS=645669;

Im going to use it for reporting so that my master wont get affected and also for backup purposes ...

[williamconley]

question: how is this "not going to overload" if every transaction here has to be transmitted to the slave ... and there are thousands of entries? how often do you "sync"? 60 seconds? does this sync successfully before the agents begin to dial?

http://linuxhelp123.blogspot.com/2010/0 ... ation.html

[randy_delgado_03]

*and there are thousands of entries?
- Just the usual routine of vicibox db.

*how often do you "sync"? 60 seconds?
-Yes as specified.

*does this sync successfully before the agents begin to dial?
-Yes this sync fine before the agents log in.

[williamconley]

master and slave on same physical network (no lag worthy of note)?