156 reputation
5
bio website
location
age
visits member for 2 years, 6 months
seen 2 days ago

Sep
9
awarded  Popular Question
Apr
19
comment What's the latest on MySQL Proxy?
Thanks for this info.
Apr
19
awarded  Teacher
Apr
19
answered Get Total in a single line in SQL Server
Apr
19
asked What's the latest on MySQL Proxy?
Apr
2
asked MySQL CLuster SETUP
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!
Apr
2
revised Master-Master Replication in MySQL
added 783 characters in body
Mar
28
revised Master-Master Replication in MySQL
added 634 characters in body
Mar
28
awarded  Supporter
Mar
28
revised Master-Master Replication in MySQL
deleted 1 characters in body
Mar
28
comment Master-Master Replication in MySQL
Thank you very much for your response, once again!:)
Mar
28
revised Master-Master Replication in MySQL
clarification
Mar
28
revised Master-Master Replication in MySQL
clarification
Mar
27
awarded  Editor
Mar
27
revised 3 Databases, Best Replication Setup?
added 295 characters in body
Mar
27
asked Master-Master Replication in MySQL
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!