Configure MySQL to have redundancy, and write a simple Node.js app to test it
$30-250 USD
Closed
Posted over 5 years ago
$30-250 USD
Paid on delivery
There are four parts to this project.
1. Research the different ways to have MySQL redundancy (e.g. group replication, sharding, master slave, etc.) and list the pros and cons of each. Then choose one and tell me why.
My requirements: if one of the database servers goes down, there would be no interruption due to the redundancy. All databases should have the same data.
2. I will create three servers for you (digital ocean droplets) where you will set up MySQL with redundancy.
3. Create a simple node app which can do an insert / update / select from the MySQL servers you just created. You should use [login to view URL] for connecting to the database. If one of the servers goes down, the redundancy you set up in step 2 should kick in.
4. If a database server goes offline for a while, when it comes back online there should be some way for it to get back in sync with the other database servers (i.e. so they all have the exact same data again).
Any questions, please ask.
Greetings,
I think we should go with mysql master-master replication using haproxy. Using haproxy will allow us to do load balancing as well as it will remove the need to hardcode mysql server IP in app config. I have already worked on this kind of config previously and will be definitely able to help you out.
Thanks,
Hello!
Welcome to vibrant webtech and I was glad to see that you're looking for help for project Configure MySQL to have redundancy, and write a simple Node.js app to test it.
Please let me know when you need this project to be completed and your minimum budget.
I've delivered more than 400 projects in the last 3 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly.
I have more than 5 years of experience in Database Administration, Javascript, MySQL, node.js
I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it.
Please find my portfolio link below for your review:
https://www.freelancer.in/u/schoudhary1553
Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon to discuss more details related to project.
"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on similar requirement in past. We have right skills to work on this assignment. . We will complete the work as per requirement
Also my team working on same project"
We have read out every thing about your project
kindly confirm"
Hello,
We understood your requirement and able to complete your job.
We have experience of more than 4+ years with Node js platform and we have faced many challenges to achieve our clients business obstacles. Based upon, we have defined standard approach to follow coding standard and also our development team is following Node js architecture along with that we have internal quality analyst team who always make sure that you get 100% workable product according to your business need and associated flow.
We would like to be your extended arm for long term basis. We can be your end to end service provider for you business needs; as we are team of 14 technocrats which includes Graphics & Web Designers, Developers.
We have also experiences about digital ocean droplet.
Let me know if you want to schedule an interview so you will get an better idea on my skill.