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
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
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"
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
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
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)
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'
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
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