156 reputation
5
bio website
location
age
visits member for 2 years
seen 3 hours ago

Apr
19
comment What's the latest on MySQL Proxy?
Thanks for this info.
Apr
2
comment Master-Master Replication in MySQL
@ekeyser, aah so a slave server uses the server_id on a query it reads from the bin-log of its master to know if it needs to replicate or not such query i.e. if it sees the query's server_id is the same as hers, then it won't replicate it, is my understanding correct? Thank you very much again!
Apr
2
comment Master-Master Replication in MySQL
so what you're saying is, the server_id of the server where a query i.e.bin-log, originated gets appended to the queries being replicated by the slaves, such that in a circular replication setup, this is how a server would know not to replicate a query on its master's bin-log once she sees the query's server_id is the same as hers. Is my understanding correct? Thank you very much for your patience in answering my questions!
Mar
28
comment Master-Master Replication in MySQL
Thank you very much for your response, once again!:)
Mar
27
comment 3 Databases, Best Replication Setup?
Sorry, I'm asking a lot of questions. So, what are differences between the setup I was considering(in the post) to the second one you suggested. I mean, wouldn't it be a good idea to apply master-master replication between db1 and db2, so db1 would just replicate from db2 in case it goes down, as compare to replicating from db3 (in your 2nd setup), considering they are on a different data center i.e. latency, etc. ?
Mar
27
comment 3 Databases, Best Replication Setup?
I don't know, but I feel that the name we have for the 3rd database in the DR site i.e. drdb, brought out some form of confusion.(?). We are not currently using a DRBD technology, and I don't think we are going to, because as you said in your answer, not all of our tables are InnoDB. And yeah, about the idea of upgrading to MySQL 5.5 from a previous version, how easy do you think is it? Is a downtime necessary and for how long? Thank you very much Rolando!