I have a application running on my k3s cluster which consist of the app itself and a mysql database.
The problem is when of the nodes restarted and the database moves to another node, the ip address of the database changes. That mean i can no longer access the app unless i figure out the new ip address of the database and edit the configuration file of the app with the new ip address .
Anyone knows how to solve this? My MySQL database is running as a statefulset. The app is running as a deployment.