Hi There,
I’am wodering for wih purpose CLUSTER_USERNAME user must be created in proxysql-admi tool.
As far as i know, where proxysql is used and pxc-cluster is managed by proxysql, the mysql nodes are not awre about the presence of proxysql,
Then, which data concerning proxysl are present in myql nodes ( a part monitor user ) anche which tasks sould be done in mysql nodes by using CLUSTER_USERNAME.
Thanks.
CLUSTER_USERNAME is used by the proxysql-admin tool to create the monitor user, and do other status checks.
You can view the full source of the proxysql-admin tool here:
#!/bin/bash
# This script will assist with configuring ProxySQL
# (currently only Percona XtraDB cluster in combination with ProxySQL is supported)
# Version 2.0
###############################################################################################
# This program is copyright 2016-2020 Percona LLC and/or its affiliates.
#
# THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
# WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
# MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
#
# This program is free software; you can redistribute it and/or modify it under
# the terms of the GNU General Public License as published by the Free Software
# Foundation, version 2 or later
#
# You should have received a copy of the GNU General Public License version 2
# along with this program; if not, write to the Free Software Foundation, Inc.,
# 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
This file has been truncated. show original
Correct.