4 ms·

what does 'more operationally friendly' mean? TIA

• shlomi-noach 4y ago
  Like the issues I mention in my post: modifying the data type of a column that is used by a foreign key; otherwise the fact you can't run Online DDL on a table that participates in foreign key relationship ; that INSTANT does not support (yet?) adding/removing foreign key constraints ; that cascaded writes are not written the the binary logs. These are all things that the casual developer doesn't deal with when designing a schema and writes an app that INSERTs/DELETEs/UPDATEs to tables with foreign keys. But once there's a need for a change; once you wire 3rd party tools onto your database, that's where the operations hit a wall.
  • _a_a_a_ 4y ago
    I didn't realise grep_it and you (shlomi-noach) were the same, apologies
    • shlomi-noach 4y ago
      We are not the same. My mistake for writing "OP".