[Kea-users] Need help in MySQL queries - KEA

[Igor Smitran]

Galera MySQL is MySQL cluster. Kea already has mysql support and already 
does all the work you mentioned.
Why would you write another API for functionality that is already 
implemented?

On 12/27/2016 08:47 AM, Nandan Adhikari wrote:
> Hi,
>
> 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:
>
> 1) lease lookup by mac/ip
> 2) reservation lookup by mac/ip
> 3) add new lease
> 4) delete an existing lease
>
> Here is what I am thinking for above APIs:
>
> 1) lease lookup by mac: (SELECT INET_NTOA(address) as address, 
> HEX(hwaddr) as hwaddr, hostname from lease4 where HEX(hwaddr)= ?", macid)
>
> If you could advice me on how to write such API's to do basic management.
>
> -- 
> Thanks & warm wishes,
> Nandan Adhikari
>
>
> _______________________________________________
> Kea-users mailing list
> Kea-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/kea-users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20161227/4adba59c/attachment.htm>