You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi @colinmollenhour ,
I started to try using your galera image. I was succeeded to build galera stack along with your swarm instruction on bare metals. Now thinking about the routing because Docker ingress network must get round robin. Some instructions suggest it's better to write into only one node. I think this haproxy image could be that when use with your haproxy cfg in here. But I couldn't get it clearly, so I have a favor to ask you.
That haproxy tpl seems to bind 3306 for write and 3307 for read. I'm wondering how my mysql clients can split the request to both ports. Do you use maxscale before this haproxy? Are you using this haproxy with docker network connect to the galera cluster's network?
I'm sorry I'm still too beginner but I'll be able to help growing these images in the future!
The text was updated successfully, but these errors were encountered:
My HAProxy example assumes that your application can already split read/write connections. If it doesn't support splitting on it's own and it is hard to implement then you're probably better off using a more robust proxy like MySQL Proxy or MaxScale.
Hi @colinmollenhour ,
I started to try using your galera image. I was succeeded to build galera stack along with your swarm instruction on bare metals. Now thinking about the routing because Docker ingress network must get round robin. Some instructions suggest it's better to write into only one node. I think this haproxy image could be that when use with your haproxy cfg in here. But I couldn't get it clearly, so I have a favor to ask you.
That haproxy tpl seems to bind 3306 for write and 3307 for read. I'm wondering how my mysql clients can split the request to both ports. Do you use maxscale before this haproxy? Are you using this haproxy with
docker network connect
to the galera cluster's network?I'm sorry I'm still too beginner but I'll be able to help growing these images in the future!
The text was updated successfully, but these errors were encountered: