MySQL Cluster (NDB) provides an active/active HA and scale-out DB that can be used for OpenStack. Ironic requires changes to Alembic DB upgrade and migrations to support MySQL Cluster (NDB). The primary enhancements are:
1. Implementation of an oslo.db configuration parameter to specify the MySQL storage engine (mysql_storage_engine).
2. Replacement of hardcoded SQL statements that set the engine to "InnoDB" to the above configuration value.
3. Logic to handle SQL differences between MySQL InnoDB and MySQL Cluster (NDB). This includes column lengths, constraints, foreign keys, and indexes.
I have a change-set patch for this. Awaiting CLA before submitting.
MySQL Cluster (NDB) provides an active/active HA and scale-out DB that can be used for OpenStack. Ironic requires changes to Alembic DB upgrade and migrations to support MySQL Cluster (NDB). The primary enhancements are:
1. Implementation of an oslo.db configuration parameter to specify the MySQL storage engine (mysql_ storage_ engine) .
2. Replacement of hardcoded SQL statements that set the engine to "InnoDB" to the above configuration value.
3. Logic to handle SQL differences between MySQL InnoDB and MySQL Cluster (NDB). This includes column lengths, constraints, foreign keys, and indexes.
I have a change-set patch for this. Awaiting CLA before submitting.