Opened 3 years ago

Last modified 3 years ago

#4543 new enhancement

Update docs and mySQL scripts for use with HA

Reported by: sar Owned by:
Priority: medium Milestone: Outstanding Tasks
Component: database-all Version: git
Keywords: Cc:
CVSS Scoring: Parent Tickets:
Sensitive: no Defect Severity: N/A
Sub-Project: DHCP Feature Depending on Ticket:
Estimated Difficulty: 0 Add Hours to Ticket: 0
Total Hours: 0 Internal?: no

Description

The current script for creating mySQL tables src/share/database/scripts/mysql/dhcpdb_create.mysql sets the engine to INNODB in a number of places
ENGINE = INNODB;

If the admin chooses to use a cluster as they might for HA purposes this needs to be
ENGINE = NDBCLUSTER;

Either the script should be updated to allow for this or the documentation should be updated to indicate that a cluster user might need to modify things in some fashion (update the script, update the tables after the script is run, possibly remove the offending line and set it in other ways).

More work may be added to this ticket as we determine if any other changes are required.

Subtickets

Change History (3)

comment:1 Changed 3 years ago by hschempf

  • Milestone changed from Kea-proposed to Kea1.2

Per July 14 team meeting, accept in 1.2. No estimate.

comment:2 Changed 3 years ago by tomek

  • Milestone changed from Kea1.2 to Kea1.2-final

Moving non-coding related tickets to post beta (1.2-final)

comment:3 Changed 3 years ago by tomek

  • Milestone changed from Kea1.2-final to Outstanding Tasks

As discussed on 2017-04-13 Kea call.

Note: See TracTickets for help on using tickets.