I'm starting new project and would like ask your opinion. They like to have multi-master replication of a single table between Chicago and Denver. A record could be written in Denver, then same row read in Chicago. The opposite is also true. Replication delay should be less than 100 ms. Load is 100 TSP
I'm not even sure is possible to replicate that fast. What technology should I look at? I heard multi-master replication is not recommended any more.