diff options
Diffstat (limited to '')
-rw-r--r-- | src/go/collectors/go.d.plugin/modules/proxysql/proxysql.go | 113 |
1 files changed, 113 insertions, 0 deletions
diff --git a/src/go/collectors/go.d.plugin/modules/proxysql/proxysql.go b/src/go/collectors/go.d.plugin/modules/proxysql/proxysql.go new file mode 100644 index 000000000..ed6baffef --- /dev/null +++ b/src/go/collectors/go.d.plugin/modules/proxysql/proxysql.go @@ -0,0 +1,113 @@ +// SPDX-License-Identifier: GPL-3.0-or-later + +package proxysql + +import ( + "database/sql" + _ "embed" + "errors" + _ "github.com/go-sql-driver/mysql" + "sync" + "time" + + "github.com/netdata/netdata/go/go.d.plugin/agent/module" + "github.com/netdata/netdata/go/go.d.plugin/pkg/web" +) + +//go:embed "config_schema.json" +var configSchema string + +func init() { + module.Register("proxysql", module.Creator{ + JobConfigSchema: configSchema, + Create: func() module.Module { return New() }, + }) +} + +func New() *ProxySQL { + return &ProxySQL{ + Config: Config{ + DSN: "stats:stats@tcp(127.0.0.1:6032)/", + Timeout: web.Duration(time.Second), + }, + + charts: baseCharts.Copy(), + once: &sync.Once{}, + cache: &cache{ + commands: make(map[string]*commandCache), + users: make(map[string]*userCache), + backends: make(map[string]*backendCache), + }, + } +} + +type Config struct { + UpdateEvery int `yaml:"update_every" json:"update_every"` + DSN string `yaml:"dsn" json:"dsn"` + Timeout web.Duration `yaml:"timeout" json:"timeout"` +} + +type ProxySQL struct { + module.Base + Config `yaml:",inline" json:""` + + charts *module.Charts + + db *sql.DB + + once *sync.Once + cache *cache +} + +func (p *ProxySQL) Configuration() any { + return p.Config +} + +func (p *ProxySQL) Init() error { + if p.DSN == "" { + p.Error("dsn not set") + return errors.New("dsn not set") + } + + p.Debugf("using DSN [%s]", p.DSN) + + return nil +} + +func (p *ProxySQL) Check() error { + mx, err := p.collect() + if err != nil { + p.Error(err) + return err + } + if len(mx) == 0 { + return errors.New("no metrics collected") + } + return nil +} + +func (p *ProxySQL) Charts() *module.Charts { + return p.charts +} + +func (p *ProxySQL) Collect() map[string]int64 { + mx, err := p.collect() + if err != nil { + p.Error(err) + } + + if len(mx) == 0 { + return nil + } + return mx +} + +func (p *ProxySQL) Cleanup() { + if p.db == nil { + return + } + if err := p.db.Close(); err != nil { + p.Errorf("cleanup: error on closing the ProxySQL instance [%s]: %v", p.DSN, err) + } + p.db = nil +} |