title: Session Variables different to global Variables in MariaDB
body: <p>I'm running a Galera Cluster with a HAProxy-LB in front.
  However my users reporting that the session variable <code>wait_timeout</code> is set to 60.</p>
  <p>I checked that with
  <code>SHOW SESSION VARIABLES LIKE &quot;%wait_timeout%&quot;</code>
  and for me the result is <code>wait_timeout  610</code>.</p>
  <p>In my <code>/etc/mysql/my.cnf</code> (on every cluster node) the value &quot;28800&quot; is set (as default)
  I can confirm that this is used by running:
  <code>SHOW GLOBAL VARIABLES LIKE &quot;%wait_timeout%&quot;</code>
  as the result is <code>wait_timeout  28800</code></p>
  <p>Any ideas why this does not apply to new sessions? The HAProxy is afaik just a stupid forwarder on port 3306..</p>
  <p>Edit: Updated all the packages on all cluster nodes. Still the same issue.
  I even tried to check it with the mysql socket connection for root and the new session spawns with a <code>wait_timeout</code> value of 60.
  <a href="https://i.stack.imgur.com/AaTJP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AaTJP.png" alt="New session for user root" /></a></p>