Re: MySQL layer7 balancing

Thanks to everyone Le 11 juin 2017 1:13 PM, "Andrew Smalley" a écrit : > HI Louis > > You asked about loadbalancing MySQL. > > What we suggest is two separate VIP's in TCP Mode on port 3306 > > One will be your Write VIP and the other will be your Read VIP > > Below

Re: MySQL layer7 balancing

HI Louis You asked about loadbalancing MySQL. What we suggest is two separate VIP's in TCP Mode on port 3306 One will be your Write VIP and the other will be your Read VIP Below is an example configuration with a ReadWriteMaster Server along with read and write only servers in each VIP - You

Re: MySQL layer7 balancing

Hi, 2017-06-11 17:37 GMT+02:00 Luis Daniel Lucio Quiroz < luis.daniel.lu...@gmail.com>: > Hi > > I'm new on the ML but not to haproxy. After googling I don't find what I'm > looking for. Maybe one of you knows it. > > I would like to force a specific MySQL server for writing operations first >

Re: MySQL layer7 balancing

Hi, i say this doese not work. Normaly this has to be setup in your application which uses mysql. -- Grüsse Daniel Von: Luis Daniel Lucio Quiroz <luis.daniel.lu...@gmail.com> Datum: Sonntag, 11. Juni 2017 um 17:37 An: "haproxy@formilux.org" <haproxy@formilux.org>

MySQL layer7 balancing

Hi I'm new on the ML but not to haproxy. After googling I don't find what I'm looking for. Maybe one of you knows it. I would like to force a specific MySQL server for writing operations first policy (aka insert,update, delete) and let use round robin policy for reading operations. Is this