Charmed MySQL Router

Learn about configurations >

• connection-sharing | boolean

  Enable MySQL Router connection pooling and sharing.

  When enabled, MySQL Router pools server connections and shares them between client connections. This reduces the number of connections to the MySQL server and frees resources bound to idle connections.

  Note: Connection sharing has some limitations - certain SQL features like GET DIAGNOSTICS, LAST_INSERT_ID(), SQL_CALC_FOUND_ROWS, GET_LOCK(), user variables, temporary tables, and prepared statements may not work as expected or will prevent connection pooling until the connection is reset.

  See https://dev.mysql.com/doc/mysql-router/8.4/en/mysql-router-general-features-connection-sharing.html

• pause-after-unit-refresh | string

  Default: first

  Wait for manual confirmation to resume refresh after these units refresh

  Allowed values: "all", "first", "none"

• vip | string

  Virtual IP to use to front mysql router units. Used only in case of external node connection.