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 database with a script that runs every few minutes. Using this pull methodology you don't have to worry about losing metrics if your depot is down but you don't have the burden of up to tweleve databases to manage on one machine (twenty four databases total).
Another option would be to write the metrics to a flat file on the web server, then simply serve that file up via HTTP. You then have only one database to manage, you can pull the metrics into it very easily and you still don't have to worry about a down depot server. In your depot you then have a couple options. You could have one master table that contains metrics from all the machines and contains a column for the machine name or you could have a seperate table for each machine, and if you want to examine metrics for all machines you could use a merge table. --- Marc Knoop <[EMAIL PROTECTED]> 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? > > -- > ../mk > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
