You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Hoang Le Trung <ho...@orenj.com> on 2017/02/02 08:47:28 UTC
RE: Kylin loadbalancer
I have problem when I use Kylin loadbalancer.
I have two kylin
A. 192.168.6.1:7070/kylin ( mode query)
B. 192.168.6.2:7070/kylin ( mode all)
And loadbalancer with roundbin config
LB. 192.168.6.10:7070/kylin
When I access LB on web browser and do query. I can see query log on two of Kylin instance A and B.
But when I use API to call Kylin from the code. I only see query log on Kylin A. It’s mean loadbalancer doesn’t work.
………………
HttpResponseMessage messge = client.PostAsync(connectionString, null).Result;
string description = string.Empty;
if (messge.IsSuccessStatusCode)
{
cookies = cookieContainer.GetCookies(new Uri(connectionString))[0];
return cookies;
}
<add key="ConnectionKylin" value="http:// 192.168.6.10:7070/kylin/api" />
………………………………..
So It’s issue or some false on my configuration.
Thanks!
Best Regards,
From: Hoang Le Trung
Sent: Thursday, January 19, 2017 3:46 PM
To: user
Subject: RE: Kylin loadbalancer
So finally, I decided to use haproxy with keepalived.
https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/html/Load_Balancer_Administration/ch-lvs-overview-VSA.html
Thanks!
Best Regards,
From: ShaoFeng Shi [mailto:shaofengshi@apache.org]
Sent: Wednesday, January 18, 2017 8:08 PM
To: user
Subject: Re: Kylin loadbalancer
Yes you need a LB or proxy between the ASP.net and Kylin; it can be running in a dedicated server or a shared server (together with Kylin), depends on how many resources you have;
2017-01-17 17:28 GMT+08:00 Hoang Le Trung <ho...@orenj.com>>:
HI ShaoFeng Shi,
So that meant I need one more server sit between my ASP.net to install Nginx for loadbalancer.
------Web ASP.net------| Nginx|----------Kylins node
Is it prefer to install in one node running Kylin instance ?
Thanks!
Best Regards,
From: ShaoFeng Shi [mailto:shaofengshi@apache.org<ma...@apache.org>]
Sent: Tuesday, January 17, 2017 4:14 PM
To: user
Subject: Re: Kylin loadbalancer
Hi Hoang,
You can use Nginx as a load balancer (https://nginx.org/en/docs/http/load_balancing.html), and then accessing the Nginx from your applications (whatever it is on Linux or Windows), it will distribute the requests to backend Kylin nodes;
2017-01-17 15:35 GMT+08:00 Hoang Le Trung <ho...@orenj.com>>:
Hi team,
I already deploy Kylin on multimode and now I want to setup load balancer on frontend website.
But my Kylin running on Centos and my front-end running on ASP.net.
--------------------Web ASP.net---------------------
| | |
|Kylin query| |Kylin query| |Kylin query|
For another frontend website using Centos, we can use Haproxy service.
But for windows I do not known How can I routing all to balancer to my ASP.net site.
Any guide for this case.
Thanks!
Best Regards,
________________________________
This e-mail may contain confidential or privileged information. If you received this e-mail by mistake, please don't forward it to anyone else, please erase it from your device and let me know so I don't do it again.
--
Best regards,
Shaofeng Shi 史少锋
________________________________
This e-mail may contain confidential or privileged information. If you received this e-mail by mistake, please don't forward it to anyone else, please erase it from your device and let me know so I don't do it again.
--
Best regards,
Shaofeng Shi 史少锋
________________________________
This e-mail may contain confidential or privileged information. If you received this e-mail by mistake, please don't forward it to anyone else, please erase it from your device and let me know so I don't do it again.
RE: Kylin loadbalancer
Posted by Hoang Le Trung <ho...@orenj.com>.
Yes I checking and it’s True that LB keep cookie on just one server and always forward all request to this server. The request only sent to other node when user authentication again.
So how I prevent it. I want when one client open browser and send request to LB, request will send loadbalance to all node, not keep only in one node.
Thanks!
Best Regards,
From: ShaoFeng Shi [mailto:shaofengshi@apache.org]
Sent: Friday, February 03, 2017 8:36 AM
To: user
Subject: Re: Kylin loadbalancer
Hi Hoang,
Kylin node won't redirect the request, so should be LB's configuration; Seems the LB remembers the session and always forward it to the foregoing node.
2017-02-02 16:47 GMT+08:00 Hoang Le Trung <ho...@orenj.com>>:
I have problem when I use Kylin loadbalancer.
I have two kylin
A. 192.168.6.1:7070/<http://192.168.6.1:7070/>kylin ( mode query)
B. 192.168.6.2:7070/<http://192.168.6.2:7070/>kylin ( mode all)
And loadbalancer with roundbin config
LB. 192.168.6.10:7070/<http://192.168.6.10:7070/>kylin
When I access LB on web browser and do query. I can see query log on two of Kylin instance A and B.
But when I use API to call Kylin from the code. I only see query log on Kylin A. It’s mean loadbalancer doesn’t work.
………………
HttpResponseMessage messge = client.PostAsync(connectionString, null).Result;
string description = string.Empty;
if (messge.IsSuccessStatusCode)
{
cookies = cookieContainer.GetCookies(new Uri(connectionString))[0];
return cookies;
}
<add key="ConnectionKylin" value="http:// 192.168.6.10:7070/<http://192.168.6.10:7070/>kylin/api" />
………………………………..
So It’s issue or some false on my configuration.
Thanks!
Best Regards,
From: Hoang Le Trung
Sent: Thursday, January 19, 2017 3:46 PM
To: user
Subject: RE: Kylin loadbalancer
So finally, I decided to use haproxy with keepalived.
https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/html/Load_Balancer_Administration/ch-lvs-overview-VSA.html
Thanks!
Best Regards,
From: ShaoFeng Shi [mailto:shaofengshi@apache.org]
Sent: Wednesday, January 18, 2017 8:08 PM
To: user
Subject: Re: Kylin loadbalancer
Yes you need a LB or proxy between the ASP.net and Kylin; it can be running in a dedicated server or a shared server (together with Kylin), depends on how many resources you have;
2017-01-17 17:28 GMT+08:00 Hoang Le Trung <ho...@orenj.com>>:
HI ShaoFeng Shi,
So that meant I need one more server sit between my ASP.net to install Nginx for loadbalancer.
------Web ASP.net------| Nginx|----------Kylins node
Is it prefer to install in one node running Kylin instance ?
Thanks!
Best Regards,
From: ShaoFeng Shi [mailto:shaofengshi@apache.org<ma...@apache.org>]
Sent: Tuesday, January 17, 2017 4:14 PM
To: user
Subject: Re: Kylin loadbalancer
Hi Hoang,
You can use Nginx as a load balancer (https://nginx.org/en/docs/http/load_balancing.html), and then accessing the Nginx from your applications (whatever it is on Linux or Windows), it will distribute the requests to backend Kylin nodes;
2017-01-17 15:35 GMT+08:00 Hoang Le Trung <ho...@orenj.com>>:
Hi team,
I already deploy Kylin on multimode and now I want to setup load balancer on frontend website.
But my Kylin running on Centos and my front-end running on ASP.net.
--------------------Web ASP.net---------------------
| | |
|Kylin query| |Kylin query| |Kylin query|
For another frontend website using Centos, we can use Haproxy service.
But for windows I do not known How can I routing all to balancer to my ASP.net site.
Any guide for this case.
Thanks!
Best Regards,
________________________________
This e-mail may contain confidential or privileged information. If you received this e-mail by mistake, please don't forward it to anyone else, please erase it from your device and let me know so I don't do it again.
--
Best regards,
Shaofeng Shi 史少锋
________________________________
This e-mail may contain confidential or privileged information. If you received this e-mail by mistake, please don't forward it to anyone else, please erase it from your device and let me know so I don't do it again.
--
Best regards,
Shaofeng Shi 史少锋
________________________________
This e-mail may contain confidential or privileged information. If you received this e-mail by mistake, please don't forward it to anyone else, please erase it from your device and let me know so I don't do it again.
--
Best regards,
Shaofeng Shi 史少锋
________________________________
This e-mail may contain confidential or privileged information. If you received this e-mail by mistake, please don't forward it to anyone else, please erase it from your device and let me know so I don't do it again.
Re: Kylin loadbalancer
Posted by ShaoFeng Shi <sh...@apache.org>.
Hi Hoang,
Kylin node won't redirect the request, so should be LB's configuration;
Seems the LB remembers the session and always forward it to the foregoing
node.
2017-02-02 16:47 GMT+08:00 Hoang Le Trung <ho...@orenj.com>:
> I have problem when I use Kylin loadbalancer.
>
>
>
> I have two kylin
>
> A. 192.168.6.1:7070/kylin ( mode query)
>
> B. 192.168.6.2:7070/kylin ( mode all)
>
>
>
> And loadbalancer with roundbin config
>
> LB. 192.168.6.10:7070/kylin
>
>
>
> When I access *LB* on web browser and do query. I can see query log on
> two of Kylin instance * A* and *B.*
>
> But when I use API to call Kylin from the code. I only see query log on
> Kylin A. It’s mean loadbalancer doesn’t work.
>
>
>
> ………………
>
> HttpResponseMessage messge = client.PostAsync(connectionString,
> null).Result;
>
> string description = string.Empty;
>
> if (messge.IsSuccessStatusCode)
>
> {
>
> cookies = cookieContainer.GetCookies(new Uri(connectionString))[0];
>
> return cookies;
>
> }
>
> <add key="ConnectionKylin" value="http:// 192.168.6.10:7070/kylin/api" />
>
> ………………………………..
>
>
>
>
>
> So It’s issue or some false on my configuration.
>
>
>
> Thanks!
>
> Best Regards,
>
> *From:* Hoang Le Trung
> *Sent:* Thursday, January 19, 2017 3:46 PM
> *To:* user
> *Subject:* RE: Kylin loadbalancer
>
>
>
> So finally, I decided to use haproxy with keepalived.
>
> https://access.redhat.com/documentation/en-US/Red_Hat_
> Enterprise_Linux/7/html/Load_Balancer_Administration/ch-
> lvs-overview-VSA.html
>
>
>
>
>
> Thanks!
>
> Best Regards,
>
> *From:* ShaoFeng Shi [mailto:shaofengshi@apache.org
> <sh...@apache.org>]
> *Sent:* Wednesday, January 18, 2017 8:08 PM
>
> *To:* user
> *Subject:* Re: Kylin loadbalancer
>
>
>
> Yes you need a LB or proxy between the ASP.net and Kylin; it can be
> running in a dedicated server or a shared server (together with Kylin),
> depends on how many resources you have;
>
>
>
> 2017-01-17 17:28 GMT+08:00 Hoang Le Trung <ho...@orenj.com>:
>
> HI ShaoFeng Shi,
>
>
>
> So that meant I need one more server sit between my ASP.net to install
> Nginx for loadbalancer.
>
> ------Web ASP.net------| Nginx|----------Kylins node
>
> Is it prefer to install in one node running Kylin instance ?
>
>
>
> Thanks!
>
> Best Regards,
>
>
>
> *From:* ShaoFeng Shi [mailto:shaofengshi@apache.org]
> *Sent:* Tuesday, January 17, 2017 4:14 PM
> *To:* user
> *Subject:* Re: Kylin loadbalancer
>
>
>
> Hi Hoang,
>
>
>
> You can use Nginx as a load balancer (https://nginx.org/en/docs/
> http/load_balancing.html), and then accessing the Nginx from your
> applications (whatever it is on Linux or Windows), it will distribute the
> requests to backend Kylin nodes;
>
>
>
> 2017-01-17 15:35 GMT+08:00 Hoang Le Trung <ho...@orenj.com>:
>
> Hi team,
>
> I already deploy Kylin on multimode and now I want to setup load balancer
> on frontend website.
>
> But my Kylin running on Centos and my front-end running on ASP.net.
>
>
>
> --------------------Web ASP.net---------------------
>
> | | |
>
> |Kylin query| |Kylin query| |Kylin query|
>
>
>
> For another frontend website using Centos, we can use Haproxy service.
>
>
>
> But for windows I do not known How can I routing all to balancer to my
> ASP.net site.
>
>
>
> Any guide for this case.
>
>
>
> Thanks!
>
> Best Regards,
>
>
>
>
> ------------------------------
>
> This e-mail may contain confidential or privileged information. If you
> received this e-mail by mistake, please don't forward it to anyone else,
> please erase it from your device and let me know so I don't do it again.
>
>
>
>
>
> --
>
> Best regards,
>
>
>
> Shaofeng Shi 史少锋
>
>
>
>
> ------------------------------
>
> This e-mail may contain confidential or privileged information. If you
> received this e-mail by mistake, please don't forward it to anyone else,
> please erase it from your device and let me know so I don't do it again.
>
>
>
>
>
> --
>
> Best regards,
>
>
>
> Shaofeng Shi 史少锋
>
>
>
> ------------------------------
> This e-mail may contain confidential or privileged information. If you
> received this e-mail by mistake, please don't forward it to anyone else,
> please erase it from your device and let me know so I don't do it again.
>
--
Best regards,
Shaofeng Shi 史少锋