I install memsql on host A to run some functional tests, then I added additional host B using Memsql Ops UI. However, host B does not show on host A Memsql Ops UI. I verified that Memsql Ops is running on host B by connect to port 9000 on host B. I receive this error when running memsql-ops follow -h A
Failed to connect to primary agent as follower: Agent at A:9000 cannot follow itself
Both hosts are running as primary right now.
Is there any chance that the MemSQL Ops install on host B is sharing its data with host A? For instance, did you copy the data directory from host A to host B when you installed MemSQL Ops on host B (by default, the data directory is in /var/lib/memsql-ops/data)?
MemSQL Ops automatically generates and saves agent IDs when a MemSQL Ops install first starts, which are UUIDs used to distinguish between different MemSQL Ops agents in a cluster. The error you're seeing indicates that you're trying to follow an agent with the same agent ID; one way that this could occur is if you're using the same data directory on both machines.