I have a specific need to create a single linux server which can host 4 MySQL instances with read replication. Here are a few questions I cannot seem to find answers to:
- Can you setup read replication through MySQL similar to Amazon RDS, or is Amazon using a propriety application to handle this read/write replication? If not, are there standalone packages for this kind of replication?
- Can you set individual settings for each MySQL installation? For instance I want a memory limit for MySQL running on port 64506 of 2GB, but MySQL installation on port 3306 should have a 16GB memory limit?