I'm currently researching how to develop a Wordpress site on top of Kubernetes. I would like to be able to develop Wordpress sites while the live site is running in production. However this would result in a problem. The development database would not be able to merge with live database. Because in the live database there would be additions to all sorts of database fields made by users. For example orders in Woocommerce, update address data and user information. Is it possible to separate. All these user managed data from the live database? So changes in the backend of the development environment can be merged with the live database without conflicts? With changes, I mean for example changes to pages and content. If there is any documentation about how other organisations are doing this I would find this really interesting.
If I'm on the wrong path, please correct me. Other ideas are also welcome.