Truly shared nothing architectures are very difficult to do for a database unless you are willing to copy every data for each core which then creates a problem

Truly shared nothing architectures are very difficult to do for a database unless you are willing to copy every data for each core which then creates a problem of heavy memory usage. Then when it comes to net I/O there is still the problem of the IRQ coming to a specific core (or maybe a random core depending on the OS) which is not the core of your thread (if you have a shared nothing architecture). Lots of claims in this post.