I've come up with pretty much the same solution to that problem. Here's
an alternative solution that requires a lot more work, but is prettier.
Set up a MySQL proxy server (of sorts). What it will do is act as a
slave to multiple masters, merge the log files it receives from them,
and act as
Hello, list. I have seen this subject come up here more than once,
but I have never seen a solution I liked.
The drill is pretty standard: I have several (4 to be more precise)
MySQL 4.1.2 servers running 13 different databases. All of them use
MyISAM tables, except for one, which uses
Jeremy Zawodny writes:
Can you, or anyone comment on the praticality of doing so? I estimate
10,000 to 30,000 records per web server, per day using 3 remote web
servers. The number of web servers would not likely grow to more than 12.
That should be a problem at all. I know of much larger i
On Tue, Jul 13, 2004 at 11:23:03AM -0400, Marc Knoop wrote:
> Jeremy Zawodny writes:
>
> >> The web servers record web metrics to local mysql databases. I would
> >> like those local databases to be consolidated onto the DEPOT [as three
> >> separate DBs].
>
> > You cannot do that.
> >
> >
Having that many instances on one box is going to be a
management nightmare. I can only imagine the recovery
scenarios should you have a hardware problem. Perhaps
you may want to think about writing your metric data
to a local mysql instance then pulling the data from
each instance into the depot
Jeremy Zawodny writes:
The web servers record web metrics to local mysql databases. I would
like those local databases to be consolidated onto the DEPOT [as three
separate DBs].
You cannot do that.
You'd need to run 3 instances of MySQL on DEPOT, one for each WWW
server you'd like to mirro
On Mon, Jul 12, 2004 at 03:49:33PM -0400, Marc Knoop wrote:
> I have 4 servers in my environment:
>
> DEPOT - master server
> WWW1 - web server #1
> WWW2 - web server #2
> WWW3 - web server #3
>
> The web servers record web metrics to local mysql databases. I would like
> those local d
I have 4 servers in my environment:
DEPOT - master server
WWW1 - web server #1
WWW2 - web server #2
WWW3 - web server #3
The web servers record web metrics to local mysql databases. I would like
those local databases to be consolidated onto the DEPOT [as three separate
DBs]. Is configurat
I have successfully configured two mysql instances to replicate to each
other (According to /doc/en/Replication_Features.html, it is possible to
do it in a A->B->C->A relationship, but I only did it with two servers
and I don't have log-slave-updates on (I think if I did, it would
immediately stop
On Mon, Nov 25, 2002 at 06:02:19PM -0600, Andy Bakun wrote:
> I have successfully configured two mysql instances to replicate to each
> other (According to /doc/en/Replication_Features.html, it is possible to
> do it in a A->B->C->A relationship, but I only did it with two servers
> and I don't hav
I have successfully configured two mysql instances to replicate to each
other (According to /doc/en/Replication_Features.html, it is possible to
do it in a A->B->C->A relationship, but I only did it with two servers
and I don't have log-slave-updates on (I think if I did, it would
immediately stop
11 matches
Mail list logo
