View Single Post
  #3  
Old 6th April 2007, 05:29
tfunky tfunky is offline
Member
 
Join Date: Jan 2007
Posts: 85
Thanks: 4
Thanked 2 Times in 2 Posts
Default

If I do order by in the query it works...problem is the php coder DIDN'T use order by in their queries...they just relied on the natural order in the database (lazy I know...but that's besides the point)

What makes me think something is screwy is that in the old database there in the right order, in the export from the old database their in the right order, if I load the dump to the #1 cluster member they get out of order...and when they replicate/sync to the #2 cluster membe they are in another different order (not in the "correct" order from the original, and not even in the same order as the #1 cluster member)

I would have thought that the 2 cluster members tables should be 100% identical.

Is that not the case?
Reply With Quote