network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 1 month |
| seen | May 14 '12 at 17:07 | |
| stats | profile views | 4 |
|
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! |
|
Mar 26 |
awarded | Student |
