Re: Circular Replication & GRANTs

2012-02-17 Thread Johan De Meersman
- Original Message - > From: "Jason J. W. Williams" > > I've got an issue where two MySQL servers are in circular/multimaster > replication. One is server_id 6871 and the other 206871. The issue is > that GRANT statements issued on 6871 are replicated to 206871 and > then > back to 6871 w

Design advice for hotel availability program

2012-02-17 Thread Tompkins Neil
Hi, I'm in the process of starting to design a hotel booking system that will eventually consist of over 10,000 hotels all with different room types, rates and availability for different dates. My question is does anyone have any experience with regards the best way to store the daily rates. Am