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 databases to be consolidated onto the DEPOT [as three separate > DBs]. Is configuration as simple as the correct entries in my.cnf? That is, > can muliple entries for master-host, master-user... exist? Any caveats with > this configuration?
You cannot do that. http://dev.mysql.com/books/hpmysql-excerpts/ch07.html See figure 7-2. You'd need to run 3 instances of MySQL on DEPOT, one for each WWW server you'd like to mirror. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]