0

Can I update, insert and delete from the multiple mysql nodes in the mysql cluster ?

neotam
  • 2,611
  • 1
  • 31
  • 53

1 Answers1

0

If you have a real mysql cluster, you can delete from all. If you have replication with master and slave you have to do it on mysql master.

recycler
  • 1,301
  • 9
  • 9
  • What about insert and update? Can I insert/update records from multiple mysql node in the cluster Where those changes should sync to other mysql nodes incluster – neotam Feb 18 '16 at 22:15
  • you can do. the master is syncing internally. Be aware to use the "mysql cluster" solution and not a simple master - slave replication. If you there update on the nodes, this will never be synced with master. For this you need the "mysql cluster" solution. – recycler Feb 20 '16 at 09:00