Hi, On Fri, May 14, 2021 at 6:08 PM Swathi P <swathi.bluepe...@gmail.com> wrote: > In our sharding solution, we have multiple coodinator nodes. If we declare > the table column as serial data type, we might end up having duplicate values > for id column in the table_a in host_b (data node) as cconnections come from > multiple coordinatoor nodes and might end up in duplicate key violations. > > Hence we decided to have the coordinator nodes as stateless and hence > declared the column with no serial/sequence. Let me know if this makes sense.
It seems reasonable to me to make coodinator nodes stateless, but may I ask the reason you use multiple coordinator nodes? Best regards, Etsuro Fujita
