BIND 10 #2142: Design and Creation Script for SQL Lease Database

[BIND 10 Development]

#2142: Design and Creation Script for SQL Lease Database
-------------------------------------+-------------------------------------
                   Reporter:         |                 Owner:  stephen
  stephen                            |                Status:  reviewing
                       Type:  task   |             Milestone:  Sprint-
                   Priority:         |  DHCP-20121018
  medium                             |            Resolution:
                  Component:  dhcp   |             Sensitive:  0
                   Keywords:         |           Sub-Project:  DHCP
            Defect Severity:  N/A    |  Estimated Difficulty:  0
Feature Depending on Ticket:         |           Total Hours:  0
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------
Changes (by tomek):

 * owner:  tomek => stephen


Comment:

 My comments:
 1. There should be a preferred-lifetime field in lease6.
 2. Typo "leasei6" before lease6_types table.
 3. There should be a comment about lack of indices. (That this is a design
 choice, because DHCP database is very dynamic and would require very
 frequent index regeneration, so the overhead is likely to outweigh read
 performance boosts that index provides).
 4. There should be a comment about portability (this was explicitly
 requested). It should be pointed that the schema can be used as is, with
 the exception of engine specification, which is likely MySQL specific.
 5. InnoDB in its default configuration is fully synchronous, which is
 safe, but yields very low performance. There should at least be a
 discussion about
 6. We should consider adding "CREATE database Kea;" at the beginning.
 7. The database installation and setup must be documented somehow. It
 doesn't have to be done as part of this ticket. Probably MySQL backend
 ticket will be more appropriate for that, but this script should at least
 have 2 line instruction, how to use that schema. Something along the
 lines:

 {{{
 To create the schema type mysql -u user -p password < dhcpdb_create.mysql
 }}}

-- 
Ticket URL: <http://bind10.isc.org/ticket/2142#comment:4>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development