MySQL Database Replica Expert required.
Our database MySQL [url removed, login to view] is hosting on Amazon EC2 instance.
We need to setup Database Replica in such a way that we can scale up.
Help us setup scaling with MySQL Database Replication, so that when traffic or CPU is high new Instance can be added and request can be sent to any of those additional VM (Virtual Machine Linux EC2).
We know how to setup scaling in Amazon, but don't know how to do it along with Database Replica.
The traffic to Database request is to be equally divided into those virtual machine.
One machine can be the primary if necessary to make the process simpler, they need not all be writable, please instruct us on the best practices.
Please remember we do have read and write to the database and no write activity should be lost.
Please do also mention how much time would it take to get a database replicated to new VM. We want to be ready should lots of users load up the system, our main hosting is already setup for scaling, the database is the only part needing help.
only serious bidder.
9 freelancers are bidding on average $12573 for this job
I have done similar projects before so you can check it from my reviews . You can set up zones and load distribution so when there is max traffic its divided onto zones .