On Thu, Feb 9, 2012 at 6:43 PM, John Hinnegan <[email protected]>wrote:
> I'm using AWS RDS / MySQL for my DB layer. > > I ran migrations on my sandbox environment, and then on my production > environment, and I'm getting slight differences. I'm fairly new to MySQL. > The differences are these AUTO_INCREMENT fields. Should I take the > difference to indicate that I've messed up my migrations and should start > fresh? Or is it possible for the same migrations to result in different > schemas? > > Schema's dumped using mysqldump: > mysqldump -u xxx -pxxx dbnamexxx --no-data=true --add-drop-table=false -h > dbhostxxx > dbnamexxx.schema > > then diffed > 50c50 > < ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 > COLLATE=utf8_unicode_ci; > --- > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > 69c69 > < ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 > COLLATE=utf8_unicode_ci; > --- > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > 86c86 > < ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 > COLLATE=utf8_unicode_ci; > --- > > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > Maybe the AUTOINCREMENT is related to master-master replication on one of the 2 Mysql installations ? http://dev.mysql.com/doc/refman/5.1/ja/replication-auto-increment.html If it has master-master replication, the AUTO_INCREMENT _must_ be set to avoid collisions of the sequences for the id's HTH, Peter -- *** Available for a new project *** Peter Vandenabeele http://twitter.com/peter_v http://rails.vandenabeele.com http://coderwall.com/peter_v -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
