Load Balancing(NGINX) Help Needed.

Question

Hi, I am working on Load Balancing for my websites…I got this:upstream backend {ny1 192.241.143.207;ny2 162.243.27.154;sf1 162.243.133.133;}The servers host like 7 sites each(all the same files)…What do I put in here:ny1 {location / {proxy_pass http://backend ; <-- here}}

theguycalledsam · Answer

Yes, updated some of them, and some still doing. :)
I managed to fix the pdo thing, I didn’t have mysql installed so I had to run:
sudo apt-get install php5-mysql
to get the drivers.

pablo · Answer

Did you update your websites with the new location of the MySQL server?

theguycalledsam · Answer

That broke database connections,
http://stackoverflow.com/questions/19213973/pdo-cannot-connect-to-remote-mysql

theguycalledsam · Answer

You’re very fast. IT’S OVAR 9000/10 from me. =]

Kamal Nasser · Answer

Take a look at https://www.digitalocean.com/community/articles/how-to-migrate-a-mysql-database-between-two-servers

theguycalledsam · Answer

Another thing now… how do I move ALL MySQL database records from my server1 to load-balancer(just so it’s all organised how I love it) and remove it from server1,2,3? Thanks for the help so far!

Kamal Nasser · Answer

Sweet! :]

theguycalledsam · Answer

I have 4 servers in total. And I sussed it out!
upstream backend {
server 192.241.143.207;
server 162.243.27.154;
server 162.243.133.133;
}

server {
location / {
proxy_set_header Host $host;
proxy_pass http://backend ;
}
}

Kamal Nasser · Answer

Try this config instead: https://p.kk7.me/geruxucohu.nginx

Also, it’s worth mentioning that this config should be on a separate nginx load balancer so you will have 4 servers in total.

theguycalledsam · Answer

Nope:
upstream backend {
ny1 192.241.143.207;
ny2 162.243.27.154;
sf1 162.243.133.133;
}

server {
location / {
proxy_set_header Host $host;
proxy_pass http://backend ;
}
}

You able to correct me? :/
New to NGINX kinda. :D I like experimenting.

Question

Load Balancing(NGINX) Help Needed.