Re: MYSQL data replication

2007-06-09 Thread Baron Schwartz
I don't run any master with that many slaves, for reasons that are irrelevant to this thread, but I know there is a point at which the slaves begin to place too much load on the master because they are all asking to read the binlog. I don't know what that point is exactly, but perhaps others

Re: MYSQL data replication

2007-06-08 Thread Jimmy Guerrero
Hello, Hmmm, I just reread your post and noticed the requirement of 50-60 slaves hanging off a single master. DRBD would NOT be the right solution here. -- Jimmy Jimmy Guerrero wrote: Hello, Although you state that there is no requirement for near real time synchronization, an

Re: MYSQL data replication

2007-06-08 Thread Jimmy Guerrero
Hello, Although you state that there is no requirement for near real time synchronization, an alternative might be to look into DRBD. Which if you are not familiar with, is block-level replication. See: http://www.mysql.com/products/enterprise/drbd.html Combining DRBD with Linux Heartbeat

Re: MYSQL data replication

2007-06-08 Thread Baron Schwartz
Hi sol, sol beach wrote: I have limited experience with MYSQL replication; which is why I am hoping others with more experience can answer a question or two. Let's say I have a MASTER MYSQL database. Let's say there are 50 - 60 other systems where I'd like to have MYSQL running on these slave

MYSQL data replication

2007-06-07 Thread sol beach
I have limited experience with MYSQL replication; which is why I am hoping others with more experience can answer a question or two. Let's say I have a MASTER MYSQL database. Let's say there are 50 - 60 other systems where I'd like to have MYSQL running on these slave systems. These slave systems

Re: Data Replication

2001-06-01 Thread Jeremy Zawodny
On Thu, May 31, 2001 at 11:25:08PM -0500, Duane Stark wrote: Hello all! I have two servers (both running mysql and freebsd) .. I also have data replication setup on them.. My question to you is this.. Both servers are phyiscally located in different locations.. a) When the data

Data Replication

2001-05-31 Thread Duane Stark
Hello all! I have two servers (both running mysql and freebsd) .. I also have data replication setup on them.. My question to you is this.. Both servers are phyiscally located in different locations.. a) When the data is replicated between the two servers, is it encrypted? b) if not, what's