-1

I want to run an academic experiment and need to create a distributed database. My plan is to use four devices: two of them running the database, one running a load balancer algorithms and the other sending requests. How do I create this local distributed database system using multiple laptops or virtual machines?

I'm currently using macOS; however, windows works too.

MYSQL or Postgres is favourable. Otherwise, any technology is fine.

Thanks

Palash Sharma
  • 662
  • 1
  • 10
  • 18
  • Please do not repost questions. Edit them. https://stackoverflow.com/q/55394882/3404097 From the posting times it seems like you might have accidentally reposted while editing? PS This question is too broad. [ask] – philipxy Mar 29 '19 at 15:56
  • https://severalnines.com/blog/postgresql-load-balancing-using-haproxy-keepalived –  Apr 01 '19 at 11:01

1 Answers1

0

Try this: https://blog.marceloaltmann.com/proxysql-tutorial-master-and-slave/

ProxySQL is a loadbalancer for MySQL. I've used it in the past and it should serve you well.

rdas
  • 20,604
  • 6
  • 33
  • 46