I have 3 servers running MySQL on RHEL6. I need to replace the servers with one’s running MariaDB on RHEL8. I know 2 of them are in master/slave configuration. I have been studying this but I still have some questions.
Is it possible for: Server A to be master to server B while at the same time, B is master to server C? In other words: A(Master) -> B(Slave/Master) -> C(Slave)
How do I determine how a MySQL server gets it’s data?
Can a mysqldump get configuration details concerning Master/Slave setup?
Does anyone have recommendations on how to and in what order to upgrade SQL servers?
Thank you for your time.