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
[email protected]
https://lists.isc.org/mailman/listinfo/kea-users


_______________________________________________
Kea-users mailing list
[email protected]
https://lists.isc.org/mailman/listinfo/kea-users

Reply via email to