setGaleraOpts(): execute SET SESSION wsrep_sync_wait directly

[Al2Klimov]

to save extra roundtrips for preparing and closing a statement.

• Idea (c) @glbyers #750

Test

000001F4  1e 00 00 00 03 53 45 54  20 53 45 53 53 49 4f 4e   .....SET  SESSION
00000204  20 77 73 72 65 70 5f 73  79 6e 63 5f 77 61 69 74    wsrep_s ync_wait
00000214  3d 37                                              =7
    00000231  32 00 00 01 ff a9 04 23  48 59 30 30 30 55 6e 6b   2......# HY000Unk
    00000241  6e 6f 77 6e 20 73 79 73  74 65 6d 20 76 61 72 69   nown sys tem vari
    00000251  61 62 6c 65 20 27 77 73  72 65 70 5f 73 79 6e 63   able 'ws rep_sync
    00000261  5f 77 61 69 74 27                                  _wait'
00000216  01 00 00 00 0e                                     .....
    00000267  07 00 00 01 00 00 00 02  00 01 00                  ........ ...
0000021B  3d 00 00 00 03 53 45 4c  45 43 54 20 76 65 72 73   =....SEL ECT vers
0000022B  69 6f 6e 20 46 52 4f 4d  20 69 63 69 6e 67 61 64   ion FROM  icingad
0000023B  62 5f 73 63 68 65 6d 61  20 4f 52 44 45 52 20 42   b_schema  ORDER B
0000024B  59 20 69 64 20 44 45 53  43 20 4c 49 4d 49 54 20   Y id DES C LIMIT 
0000025B  31                                                 1

👍

[LordHepipud]

Hello

Thank you for the issue. We do no longer update the modules on the PowerShell Gallery. The reason behind that decision is that there is no proper way right now to migrate the configuration and cache data from the old versions to the new ones.

In addition, the current JEA implementation will not work on how PowerShell Gallery is installing the modules (different folders for each version).

To properly support this, we would require lots of re-writes on how the JEA profiles are handled and also on how we store cache/config data.