[prev in list] [next in list] [prev in thread] [next in thread] 

List:       cassandra-user
Subject:    =?UTF-8?B?UmU6IOWbnuWkje+8miBkYXRhIGxvc3MgaW4gZGlmZmVyZW50IERD?=
From:       Reynald Bourtembourg <reynald.bourtembourg () esrf ! fr>
Date:       2017-09-28 16:51:55
Message-ID: 9084988f-ae34-ed0f-fce6-71f55c36af7b () esrf ! fr
[Download RAW message or body]

Do you mean how often we should run repairs in this situation (write at 
CL=EACH_QUORUM and CL=LOCAL_QUORUM)?

I don't consider myself as an expert in this domain, so I will let the 
real experts answer to this question...
You can also refer to this mailing list history (many threads on this 
snbject) and to the recommendations in the documentation:
http://cassandra.apache.org/doc/latest/operating/repair.html#usage-and-best-practices

Kind regards
Reynald


On 28/09/2017 14:49, Jacob Shadix wrote:
> How often are you running repairs?
>
> -- Jacob Shadix
>
> On Thu, Sep 28, 2017 at 7:53 AM, Reynald Bourtembourg 
> <reynald.bourtembourg@esrf.fr <mailto:reynald.bourtembourg@esrf.fr>> 
> wrote:
>
>     Hi,
>
>     You can write with CL=EACH_QUORUM and read with CL=LOCAL_QUORUM to
>     get strong consistency.
>
>     Kind regards,
>     Reynald
>
>
>     On 28/09/2017 13:46, Peng Xiao wrote:
>>     even with CL=QUORUM,there is no guarantee to be sure to read the
>>     same data in DC2,right?
>>     then multi DCs looks make no sense?
>>
>>
>>     ------------------ 原始邮件 ------------------
>>     *发件人:* "DuyHai Doan";<doanduyhai@gmail.com>
>>     <mailto:doanduyhai@gmail.com>;
>>     *发送时间:* 2017年9月28日(星期四) 下午5:45
>>     *收件人:* "user"<user@cassandra.apache.org>
>>     <mailto:user@cassandra.apache.org>;
>>     *主题:* Re: data loss in different DC
>>
>>     If you're writing into DC1 with CL = LOCAL_xxx, there is no
>>     guarantee to be sure to read the same data in DC2. Only repair
>>     will help you
>>
>>     On Thu, Sep 28, 2017 at 11:41 AM, Peng Xiao <2535053@qq.com
>>     <mailto:2535053@qq.com>> wrote:
>>
>>         Dear All,
>>
>>         We have a cluster with one DC1:RF=3,another DC DC2:RF=1 only
>>         for ETL,but we found that sometimes we can query records in
>>         DC1,while not able not find the same record in DC2 with
>>         local_quorum.How it happens?
>>         Could anyone please advise?
>>         looks we can only run repair to fix it.
>>
>>         Thanks,
>>         Peng Xiao
>>
>>
>
>


[Attachment #3 (text/html)]

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    Do you mean how often we should run repairs in this situation (write
    at CL=EACH_QUORUM and CL=LOCAL_QUORUM)?<br>
    <br>
    I don't consider myself as an expert in this domain, so I will let
    the real experts answer to this question...<br>
    You can also refer to this mailing list history (many threads on
    this snbject) and to the recommendations in the documentation:<br>
<a class="moz-txt-link-freetext" \
href="http://cassandra.apache.org/doc/latest/operating/repair.html#usage-and-best-prac \
tices">http://cassandra.apache.org/doc/latest/operating/repair.html#usage-and-best-practices</a><br>
  <br>
    Kind regards<br>
    Reynald<br>
    <br>
    <br>
    <div class="moz-cite-prefix">On 28/09/2017 14:49, Jacob Shadix
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CA+u9BE7mPfo=PKQXGB7VbJCNhJ=Fp5wCXg6wf1by05iz+dd6rw@mail.gmail.com">
      <div dir="ltr">How often are you running repairs?</div>
      <div class="gmail_extra"><br clear="all">
        <div>
          <div class="gmail_signature" data-smartmail="gmail_signature">
            <div dir="ltr">
              <div>
                <div dir="ltr">
                  <div dir="ltr"><span
                      style="font-size:12.8000001907349px">-- Jacob
                      Shadix </span><br>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
        <br>
        <div class="gmail_quote">On Thu, Sep 28, 2017 at 7:53 AM,
          Reynald Bourtembourg <span dir="ltr">&lt;<a
              href="mailto:reynald.bourtembourg@esrf.fr" target="_blank"
              moz-do-not-send="true">reynald.bourtembourg@esrf.fr</a>&gt;</span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div text="#000000" bgcolor="#FFFFFF"> Hi,<br>
              <br>
              You can write with CL=EACH_QUORUM and read with
              CL=LOCAL_QUORUM to get strong consistency.<br>
              <br>
              Kind regards,<br>
              Reynald
              <div>
                <div class="h5"><br>
                  <br>
                  <div class="m_-6166422026026731157moz-cite-prefix">On
                    28/09/2017 13:46, Peng Xiao wrote:<br>
                  </div>
                  <blockquote type="cite">
                    <div>even with CL=QUORUM,there is no guarantee to be
                      sure to read the same data in DC2,right?</div>
                    <div>then multi DCs looks make no sense?</div>
                    <div>
                      <div><br>
                      </div>
                      <div><br>
                      </div>
                      <div style="font-size:12px;font-family:Arial
                        Narrow;padding:2px 0 2px 0">------------------ 原始邮件 \
------<wbr>------------</div>  <div
                        style="font-size:12px;background:#efefef;padding:8px">
                        <div><b>发件人:</b> "DuyHai Doan";<a
                            class="m_-6166422026026731157moz-txt-link-rfc2396E"
                            href="mailto:doanduyhai@gmail.com"
                            target="_blank" \
moz-do-not-send="true">&lt;doanduyhai@gmail.com&gt;</a>;</div>  <div><b>发送时间:</b> \
2017年9月28日(星期四) 下午5:45</div>  <div><b>收件人:</b> "user"<a
                            class="m_-6166422026026731157moz-txt-link-rfc2396E"
                            href="mailto:user@cassandra.apache.org"
                            target="_blank" \
                moz-do-not-send="true">&lt;user@cassandra.<wbr>apache.org&gt;</a>;</div>
                
                        <div><b>主题:</b> Re: data loss in different DC</div>
                      </div>
                      <div><br>
                      </div>
                      <div dir="ltr">If you're writing into DC1 with CL
                        = LOCAL_xxx, there is no guarantee to be sure to
                        read the same data in DC2. Only repair will help
                        you</div>
                      <div class="gmail_extra"><br>
                        <div class="gmail_quote">On Thu, Sep 28, 2017 at
                          11:41 AM, Peng Xiao <span dir="ltr">&lt;<a
                              href="mailto:2535053@qq.com"
                              target="_blank" \
moz-do-not-send="true">2535053@qq.com</a>&gt;</span>  wrote:<br>
                          <blockquote class="gmail_quote"
                            style="margin:0 0 0 .8ex;border-left:1px
                            #ccc solid;padding-left:1ex">
                            <div>Dear All,</div>
                            <div><br>
                            </div>
                            <div>We have a cluster with one
                              DC1:RF=3,another DC DC2:RF=1 only for
                              ETL,but we found that sometimes we can
                              query records in DC1,while not able not
                              find the same record in DC2 with
                              local_quorum.How it happens?</div>
                            <div>Could anyone please advise?</div>
                            <div>looks we can only run repair to fix it.</div>
                            <div><br>
                            </div>
                            <div>Thanks,</div>
                            <div>Peng Xiao</div>
                          </blockquote>
                        </div>
                        <br>
                      </div>
                    </div>
                  </blockquote>
                  <br>
                </div>
              </div>
            </div>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
  </body>
</html>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic