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. > > <snip> > > You'd need to run 3 instances of MySQL on DEPOT, one for each WWW > > server you'd like to mirror. > > 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. > > My planned DEPOT server is a Dell PowerEdge - dual Xeon, 2GB memory and > oodles of disk space. > > Could mysql, or Linux ES 3.0 for that matter, handle it? Is there anyone on > this list running several instances of mysql on the same box? Any > experiences to share?
That should be a problem at all. I know of much larger instances (millions of records) doing the same on similar (or less) hardware. 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]
