Hello, I got an issue with a multi node infrastructure. I have a master, and 4 nodes. Node1 and node2 in mirror, and node3 and 4 in mirror. Those nodes are web server. If I update the configuration for Node3, it is well updating on both node. If I update the configuration (adding web domain and stuff) on Node1, none of Node1 or 2 are updated... I don't see why. They both used to works, but I don't know till when it stop working... I Can connect to the master server from all Nodes thru MySQL. I got nothing in the logs... I already try an update with reconfiguration of the right. Any help will be appreciated!
I checked a little bit more... I got no error in the master sys_datalog table. The master web_domain table is well updated. The slave (Node1 and 2) database is not updated at all... Is it possible to force an update of the slave from the master. And create the missing config file on the slave, regarding is updated database?
Thank you very much for the answer, I already set the master log level to "debug". All I got is : Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock Every minute. Not sure what that means. Am I suppose to set "Node1" in debug instead of master? regards,
Hello again, I got this in the logs: Replication failed. Error: (web_database_user) in MySQL server: (localhost) The MySQL server is running with the --read-only option so it cannot execute this statement
So MySQL is not writable n this node and that's why ispconfig can not add something to the database. Check your MySQL config to find out why this node is read-only.
