init.d - need 'status' option

2004-10-06 Thread Marc Knoop
I am implementing mysql on a Redhat Cluster for high availability and will be using replication. I wanted to use 4.1.5, but learned that the cluster suite requires an init.d script that will answer to the 'status' command. 'status' does not seem to be included anymore. [RH will only support a

Consolidating Data

2004-07-23 Thread Marc Knoop
Greetings! I have several (~12) web servers which all record web metrics to their own local mysql database. I would like to consolidate data from each web server database to one master DB to within the hour. I wish to avoid running multiple instances of mysql on the "master" server, so repli

Re: Replication - multiple masters

2004-07-13 Thread Marc Knoop
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

Re: Replication - multiple masters

2004-07-13 Thread Marc Knoop
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

Replication - multiple masters

2004-07-12 Thread Marc Knoop
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