0
votes
1answer
107 views

update and insert MySQL DB on AWS RDS with local MySQL DB

I have created an RDS database and have used mysqldump to send all my local data to that remote database using the following commands: $ mysqldump -u root fishDB > localDB.sql $ mysql -h ...
1
vote
1answer
197 views

mySQL: Slave not able to connect to Master for replication

On my master, I did: GRANT REPLICATION SLAVE ON *.* TO 'repluser'@'%' IDENTIFIED BY 'mypassword'; On my slave, I see: mysql> show slave status \G; *************************** 1. row ...
2
votes
2answers
404 views

How do I handle mysql replication in EC2 using private IPs?

I am trying to set up a mysql master/slave configuration in two EC2 instances. However, every time I reboot an instance, the IP address (and hostname) changes. I could assign an Elastic IP address, ...
0
votes
1answer
639 views

RDS slave (read replica) not replication

It appears overnight our Master RDS mysql server went offline for 3-4 minutes. When it came back online the replication was broken. On the slave, issuing SHOW SLAVE STATUS\G; "Got fatal error 1236 ...
1
vote
1answer
177 views

Setting up MysqlMM replication with EC2 instances with elastic IPs for both

I just spun up two EC2 instances and got an elastic IP for each. I can't seem to get it to connect. Here is the bulk of my config: auto_increment_offset=2 log-bin=master2-bin binlog-ignore-db=mysql ...
1
vote
2answers
2k views

Scaling a LAMP website hosted on EC2

I'm very new to all this - I've recently managed to launch my website on EC2. As next step, I want to learn how to scale the website. I have a general idea but wanted some input from the experts about ...
0
votes
2answers
2k views

MySQL Master / Master Replication : Load Balancing With EC 2's Elastic Load Balancer

I have a RoR application that I have working on EC 2. I have two MySQL server instances in a master / master replicated environment, and a few read-slaves. Once I established that the masters were ...