and see these errors in the logs: Could not open required defaults file: /path/to/my.cnf . 40 Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 How do I choose between master vs. replica for queries? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 There seems to be a 10 000 row Is there a list of supported/unsupported queries? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 2 If I have a log of all queries from my app. Is there a way I can try them

and see these errors in the logs: Could not open required defaults file: /path/to/my.cnf . 27 Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 How do I choose between master vs. replica for queries? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 There seems to be a 10 000 row Is there a list of supported/unsupported queries? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 If I have a log of all queries from my app. Is there a way I can try them

. . . . . . 47 Examples of valid queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 Examples of queries not supported in the first implementation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124 Custom metrics & queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 449 1. Gather the queries from your current MySQL database environment . . . . . . . . . . . . . . . . . . . . . . . . 449 2. Filter out specific queries . . . . . . . . . . . . . . . .

. . . . . . 43 Examples of valid queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43 Examples of queries not supported in the first implementation . . . . . . 389 1. Gather the queries from your current MySQL database environment . . . . . . . . . . . . . . . . . . . . . . . . 389 2. Filter out specific queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 389 3. Populate fake values for your queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 390 4. Run the

. . . . . . 44 Examples of valid queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 Examples of queries not supported in the first implementation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113 Custom metrics & queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 182 Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

and see these errors in the logs: Could not open required defaults file: /path/to/my.cnf . 23 Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 How do I choose between master vs. replica for queries? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 There seems to be a 10 000 row Is there a list of supported/unsupported queries? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 If I have a log of all queries from my app. Is there a way I can try them

and see these errors in the logs: Could not open required defaults file: /path/to/my.cnf . 26 Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 How do I choose between master vs. replica for queries? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 There seems to be a 10 000 row Is there a list of supported/unsupported queries? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 If I have a log of all queries from my app. Is there a way I can try them

. . . . . . 54 Examples of valid queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 Examples of queries not supported in the first implementation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148 Custom metrics & queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220 Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

leaks of personally-identifiable information, for example during the extensive logging of executed queries. The redactor was checked for flaws allowing for the exfiltration of unredacted or incompletely redacted it was discovered that personally identifying information is not properly stripped from logged queries. Note that this PII potentially resides in string values of SQL statements This might lead to the strings, certain scenarios where logging such values might be undesirable can be envisioned. Example queries: select * from t where x = 11111111111111111112; select * from t where x = true; It is recommended

14 VITESS.IO Vitess @Slack 15 VITESS.IO Slack Vitess Usage 35% Migrated 500K Peak QPS 10B Queries per day 1ms Added latency 16 VITESS.IO “Our goal is that all MySQL at Slack is run behind