<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Galera MySQL is MySQL cluster. Kea
already has mysql support and already does all the work you
mentioned.<br>
Why would you write another API for functionality that is already
implemented?<br>
<br>
On 12/27/2016 08:47 AM, Nandan Adhikari wrote:<br>
</div>
<blockquote
cite="mid:CAHvEBNu5KD7cvri=0mdG9ZtL8GQB3eEK2xuQ0_hnuMbndzafzQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)">Hi,</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br>
</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)">I am
writing a service which assigns IP addresses to newly
provisioned VMs or physical machines from a pre-defined IP
pool. I want to use KEA with Galera MySQL backend. The problem
I am facing is that there is no docs/info regarding the Table
schema details or SQL queries to do common tasks like:</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br>
</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)">1)
lease lookup by mac/ip</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)">2)
reservation lookup by mac/ip</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)">3)
add new lease</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)">4)
delete an existing lease</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br>
</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)">Here
is what I am thinking for above APIs:</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br>
</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)">1)
lease lookup by mac: (SELECT INET_NTOA(address) as address,
HEX(hwaddr) as hwaddr, hostname from lease4 where HEX(hwaddr)=
?", macid)</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br>
</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)">If
you could advice me on how to write such API's to do basic
management.</div>
<div class="gmail_default" style="font-family:"comic sans
ms",sans-serif;font-size:small;color:rgb(51,0,153)"><br>
</div>
-- <br>
<div class="gmail_signature">Thanks & warm wishes,<br>
Nandan Adhikari</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Kea-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Kea-users@lists.isc.org">Kea-users@lists.isc.org</a>
<a class="moz-txt-link-freetext" href="https://lists.isc.org/mailman/listinfo/kea-users">https://lists.isc.org/mailman/listinfo/kea-users</a>
</pre>
</blockquote>
<p><br>
</p>
</body>
</html>