change storage path for prometheus

Follow

Preimann

• March 24, 2022 07:24

Hi,

ClusterControl uses the standard storage path for prometheus which is /var/lib/prometheus/data.
In my case /var/log is a mounted path where we want to store the prometheus data because of /var/lib isn't large enough. 
prometheus uses --storage.tsdb.path for it.

Where can I configure the start options of prometheus in ClusterControl? Should I add it to the prometheus config yml?

Thanks for your help

Peter

0

• 

  Duncan Kabue Mwangi

  • March 28, 2022 11:40

  Hi Peter,

  You can configure this path using this s9s-tools command:

  s9s cluster --cluster-id=[cluster_id] --deploy-agents --nodes=[ip_address]?datadir=/var/customdatadir --log

  Customize the command as per your environment variables.

  Regards,

  Duncan.

   

   

   

  0

  Comment actions Permalink
• 

  Preimann

  • March 29, 2022 08:35
  • Edited

  Hi Duncan,
  
  when I execute the command it logs MySQL errors for each data node:

  Alter user processed: ALTER USER 'cmonexporter'@'localhost' IDENTIFIED BY 'xxx xx'
  Grant processed: GRANT PROCESS,REPLICATION CLIENT,SELECT ON *.* TO 'cmonexporter'@'localhost'
  Grant command 'GRANT SLAVE MONITOR ON *.* TO 'cmonexporter'@'localhost'' failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MONITOR ON *.* TO 'cmonexporter'@'localhost'' at line 1 (errno: 1064)
  Grant command 'GRANT REPLICA MONITOR ON *.* TO 'cmonexporter'@'localhost'' failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MONITOR ON *.* TO 'cmonexporter'@'localhost'' at line 1 (errno: 1064)
  Alter user processed: ALTER USER 'cmonexporter'@'127.0.0.1' IDENTIFIED BY 'xxx xx'
  Grant processed: GRANT PROCESS,REPLICATION CLIENT,SELECT ON *.* TO 'cmonexporter'@'127.0.0.1'
  Grant command 'GRANT SLAVE MONITOR ON *.* TO 'cmonexporter'@'127.0.0.1'' failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MONITOR ON *.* TO 'cmonexporter'@'127.0.0.1'' at line 1 (errno: 1064)
  Grant command 'GRANT REPLICA MONITOR ON *.* TO 'cmonexporter'@'127.0.0.1'' failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MONITOR ON *.* TO 'cmonexporter'@'127.0.0.1'' at line 1 (errno: 1064)
  Alter user processed: ALTER USER 'cmonexporter'@'::1' IDENTIFIED BY 'xxx xx'
  Grant processed: GRANT PROCESS,REPLICATION CLIENT,SELECT ON *.* TO 'cmonexporter'@'::1'
  Grant command 'GRANT SLAVE MONITOR ON *.* TO 'cmonexporter'@'::1'' failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MONITOR ON *.* TO 'cmonexporter'@'::1'' at line 1 (errno: 1064)
  Grant command 'GRANT REPLICA MONITOR ON *.* TO 'cmonexporter'@'::1'' failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MONITOR ON *.* TO 'cmonexporter'@'::1'' at line 1 (errno: 1064)

  I use a 8.0.25 MySQL Community on CentOS 7.
  Nevertheless the command itself seems to work.

   

  0

  Comment actions Permalink
• 

  Duncan Kabue Mwangi

  • March 29, 2022 09:38

  Hi Peter,

  I am happy the command worked. For the logging of MySQL errors, the resolution of this is being worked on.

  Regards,

  Duncan

  0

  Comment actions Permalink

Please sign in to leave a comment.