8.6 Mandatory Guidelines for User and Grant Operations

This section provides the following mandatory guidelines for user and grant operations:

  • NFs must create schema only from ndbappmysqld pods, whereas using ndbmysqld pods is not permitted.
  • Use ndbappmysqld pods to run all user and privilege operations (for example, CREATE USER, ALTER USER, and GRANT).
  • To prevent CREATE USER, ALTER USER, or GRANT statements from being written to the binlog (and therefore replicated), surround them with the following commands:
    • SET sql_log_bin = OFF; (before)
    • SET sql_log_bin = ON; (after)
  • Do not use ndbmysqld pods for any schema, user, or grant tasks.