i need to put in a high availability architecture of WordPress in place with two WordPress servers with different domain names and i need to set up database to have same data on all my Wordpress site servers but i can't do that since WordPress relies heavily on domain name in database
i already setup HAProxy Keepalived and two WordPress servers with different domain names and i need to set up database to have same data, because i need data to be synced across the two WordPress websites.