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 ca

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 alternative

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"

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 al

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 system

Re: Data Replication

2001-05-31 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)

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'

Re: data replication using MySQL

2001-02-07 Thread Atle Veka
You might want to look at http://www.mysql.com/doc/R/e/Replication_Implementation.html The docs are *really* handy usually :) --Atle On Fri, 1 Jan 1999, neeraj_m wrote: > Sir, > > How can I do data replication using MySQL? I am having data on my > local server, say, people a

data replication using MySQL

2001-02-07 Thread neeraj_m
Sir, How can I do data replication using MySQL? I am having data on my local server, say, people are coming to my firm and giving there specifications. On pressing the submit button, this data should go to the database server, which is on Intranet. Now I want to develop an application, in