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