I have database text_production and I want to create a database called txt_development with the same information. I have a 3 node Galera cluster with percona 5.6, I dont want to cause any galera locks. So I dont think I can just dump the data from the production db right into the development db. Is there an easy way to do this. The DB is ~53GB.
Any ideas?