自动创建grafana的dashboard和metrics.

  grafana的官方文档写的太简单，要自动化创建一个metrics，经过反复测试，下面一个例子就可以了。

1. {
   
2.   "Dashboard": {
   
3.     "title": "gorouter",
   
4.     "editable": true,
   
5.     "rows": [
   
6.       {
   
7.         "editable": true,
   
8.         "height": "250px",
   
9.         "panels": [
   
10.           {
    
11.             "id": 1,
    
12.             "title": "your-metrics-name",
    
13.             "datasource": "prod-opentsdb",
    
14.             "lines": true,
    
15.             "targets": [
    
16.               {
    
17.                 "aggregator": "sum",
    
18.                 "downsampleAggregator": "avg",
    
19.                 "downsampleInterval": "5m",
    
20.                 "metric": "opentsdb.nozzle.gorouter.latency.uaa",
    
21.                 "tags": {
    
22.                   "deployment": "cf-cfapps-io2",
    
23.                   "job": "router_z1"
    
24.                 }
    
25.               }
    
26.             ],
    
27.             "type": "graph",
    
28.             "y_formats": [
    
29.               "short",
    
30.               "short"
    
31.             ]
    
32.           }
    
33.         ]
    
34.       }
    
35.     ]
    
36.   },
    
37.   "overwrite": true
    
38. }

    现在自动来实现创建metrics，无非是自动创建上述json.
#metrics/test.csv 格式如下
opentsdb.nozzle.gorouter.memoryStats.lastGCPauseTimeNS,ns, router_z1|router_z2

1. require 'rest-client'
2. require 'json'
3. require 'pp'
5. $deployments = {
6. gorouter: 'cf-cfapps-io2',
7. uaa: 'cf-cfapps-io2',
8. routing_api: 'cf-cfapps-io2-routing',
9. tcp_emitter: 'cf-cfapps-io2-routing',
10. syslog_drain_binder: 'cf-cfapps-io2',
11. loggregatortrafficcontroller: 'cf-cfapps-io2',
12. cc: 'cf-cfapps-io2',
13. etcd: 'cf-cfapps-io2',
14. dopplerserver: 'cf-cfapps-io2'
15. }
17. def delete_dashboard(slug)
18. url = "http://grafanaxxx.com/api/dashboards/db/#{slug}"
20. begin
21. r = RestClient.delete(url, {
22. :content_type => 'application/json',
23. :Authorization => 'Bearer xxxxxxxx'
24. })
25. rescue Exception => e
26. puts "error: #{e.response}"
27. end
29. puts "deleted: #{r}"
30. end
32. def create_dashboard(data)
33. url = 'http://grafanaxxx.com/api/dashboards/db'
35. begin
36. r = RestClient.post url, data.to_json, {
37. :content_type => 'application/json',
38. :Authorization => 'Bearer xxxxxxxx'
39. }
40. rescue Exception => e
41. puts "error:#{e.response}"
42. end
44. puts r
45. end
47. def build_json(name, data)
48. template = {
49. Dashboard: {
50. title: '',
51. editable: true,
52. rows: []
53. },
54. overwrite: true
55. }
57. template[:Dashboard][:title] = name
58. template[:Dashboard][:rows].clear
60. data.each_with_index do |row, index|
61. row.chop!
62. rows_content = {
63. editable: true,
64. height: '250px',
65. panels: []
67. }
69. row_data = row.split(',', 3)
71. targets = []
72. if row_data[2] == 'none'
73. targets << {
74. aggregator: 'sum',
75. downsampleAggregator: 'avg',
76. downsampleInterval: '5m',
77. metric: row_data[0],
78. tags: {deployment: $deployments.fetch(name.downcase.to_sym, 'cf-cfapps-io2-diego')}
79. }
80. else
81. jobs = row_data[2].split('|')
82. jobs.each do |job|
83. targets << {
84. aggregator: 'sum',
85. downsampleAggregator: 'avg',
86. downsampleInterval: '5m',
87. metric: row_data[0],
88. tags: {deployment: $deployments.fetch(name.downcase.to_sym, 'cf-cfapps-io2-diego'), job: job}
89. }
90. end
91. end
93. rows_content[:panels] << {
94. id: index + 1,
95. title: row_data[0].downcase,
96. datasource: 'prod-opentsdb',
97. lines: true,
98. targets: targets,
99. type: 'graph',
100. y_formats: [row_data[1], 'short'],
101. timeFrom: '48h',
102. timeShift: '0h',
103. }
105. template[:Dashboard][:rows] << rows_content
106. end
108. template
109. end
111. def load_metrics
112. files = Dir.glob('metrics/*.csv')
113. files.each do |file|
114. dashboard_name = File.basename(file, '.csv')
115. delete_dashboard dashboard_name
117. rows = File.readlines file
118. data = build_json(dashboard_name, rows)
119. create_dashboard data
120. end
121. end
123. load_metrics