<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>