I'm looking to have a master and slave DB on the same server, both in an Amazon RDS instance. Is this possible? I'm using MySQL Workbench to access it and am a little confused with the instructions I have seen so far.
0
votes
Why do you want master and slaves on the same server? Surely the point of replication is if one database server fails, there’s another your application can use? Or are you wanting a slave for reading and your master for writing or something?
– Martin Bean
Right the goal is to have slave to read and master to write.
– user2936644
2 Answers
1
votes
"On the same server" is not possible with Amazon RDS for MySQL, because RDS is a managed service. Amazon provides, configures, and has exclusive access to the actual server where an RDS instance is running... you, the user, do not have direct (shell) access to that machine, so you can't do the kind of customization of configuration that running a master and slave on the same server would require.
