Hi, I am exploring the Sharding Sphere. I may have misunderstanding on the concepts. Very appreciated for your help on following questions.
1) Is sharding also applied on records update and insert? For example, the table sharding rules define even and odd numbers records on two different databases. When updating or inserting records, are these records updated and inserted on both databases? 2) If sharding also applied on records update and insert, if there are sharding rules defined on the primary key of a table but the key is automatically generated by database, inserting a new record would not know the key beforehand in the SQL Would this record inserted in all the databases or the database defined by the table sharding rule? 3) If a table has not sharding rule defined but all databases have the complete records, which database will execute the query on this table? 4) Can we define default rules when there is no sharding rule matched route the query randomly to a database like simple load balancing? Best Regards, Eric Poon
