FW: Merge Tables Across Databases

2002-12-14 Thread Lou Scalpati
Can you create a merge table whose component tables exist in other databases? I am able to create merge tables for tables that are in one database but I want to be able to aggregate data from multiple databases. I am using 3.23 but I am migrating to 4.0.5a next week, if that makes a difference.

Re: E-Commerce, db-clustering and MySQL?

2002-12-08 Thread Lou Scalpati
Bjorn - you state to use auto_increment in 2-way replication. Others have said that this could cause a crash if the auto_increment field is duplicated. Have experienced any problems with it? - Original Message - From: Björn Pålsson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday,

RE: Two-Way Replication

2002-12-07 Thread Lou Scalpati
I have read 4.10.7 and the only caveat stated is that updates can occur in different orders on the different servers. Each of my updates are autonomous and that should not be a problem. Are there any other gotchas I should be concerned about. I saw a posting the stated not to turn on

Two-Way Replication

2002-12-06 Thread Lou Scalpati
I am new to this list and have not been able to find an answer in the searchable archive, So I am sorry if this question has been asked before. The documentation (section 4.10.7) mentions 2 way replication but does not give any information about how to set it up. I have searched the