Johan Andersson freddielunchbird
freddielunchbird
/ gist:a74d916b0b9d92ed327552caebfefd67
Created
May 16, 2019 14:12
create >1 postgres + postgres_exporter
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sudo pg_createcluster -p 5433 --start 11 CLUSTER | |
| vagrant@n6:~$ sudo pg_lsclusters | |
| Ver Cluster Port Status Owner Data directory Log file | |
| 11 CLUSTER 5433 online postgres /var/lib/postgresql/11/CLUSTER /var/log/postgresql/postgresql-11-CLUSTER.log | |
| 11 main 5432 online postgres /var/lib/postgresql/11/main log/postgresql-%Y-%m-%d_%H%M%S.log | |
| sudo vi /etc/postgresql/11/CLUSTER/pg_hba.conf |
freddielunchbird
/ gist:d4b327f6d3e4fbf0be2fa550d4d4e694
Created
June 12, 2018 12:31
haproxy_patch.txt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| diff --git a/app/webroot/js/mvc/controller/nodes/HAProxy.js b/app/webroot/js/mvc/controller/nodes/HAProxy.js | |
| index 59a767b..e90050b 100644 | |
| --- a/app/webroot/js/mvc/controller/nodes/HAProxy.js | |
| +++ b/app/webroot/js/mvc/controller/nodes/HAProxy.js | |
| @@ -22,7 +22,8 @@ Ext.define('CmonApp.controller.nodes.HAProxy', { | |
| command: 'haproxy', | |
| job_data: { | |
| action: action, | |
| - haproxy_address: view.node.node.hostname, | |
| + hostname: view.node.node.hostname, |
freddielunchbird
/ gist:d0eef43a5dfa6e643b9979e19eda2250
Created
July 27, 2017 08:10
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #include "common/mysql_helper.js" | |
| function main() | |
| { | |
| var hosts = cluster::mySqlNodes(); | |
| var advisorMap = {}; | |
| for (idx = 0; idx < hosts.size(); ++idx) | |
| { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Reading symbols from /ssd/home/johan/Documents/clustercontrol-enterprise-master/src/cmon...done. | |
| Reading symbols from /lib/x86_64-linux-gnu/libssl.so.1.0.0...(no debugging symbols found)...done. | |
| Loaded symbols for /lib/x86_64-linux-gnu/libssl.so.1.0.0 | |
| Reading symbols from /lib/x86_64-linux-gnu/libcrypto.so.1.0.0...(no debugging symbols found)...done. | |
| Loaded symbols for /lib/x86_64-linux-gnu/libcrypto.so.1.0.0 | |
| Reading symbols from /usr/lib/x86_64-linux-gnu/libssh.so.4...Reading symbols from /usr/lib/debug/.build-id/2a/ecde8aa4916c07c31fa30acdfb050214701a38.debug...done. | |
| done. | |
| Loaded symbols for /usr/lib/x86_64-linux-gnu/libssh.so.4 | |
| Reading symbols from /usr/lib/x86_64-linux-gnu/libssh_threads.so.4...Reading symbols from /usr/lib/debug/.build-id/14/c6a509cd99dcbb4b89e4b754fd3c4b88603ae8.debug...done. | |
| done. |
freddielunchbird
/ gist:37c13628578680ac092f485be1b59451
Created
November 25, 2016 11:11
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| diff --git a/tests/common/s9sunittest.cpp b/tests/common/s9sunittest.cpp | |
| index 4992074..3a98031 100644 | |
| --- a/tests/common/s9sunittest.cpp | |
| +++ b/tests/common/s9sunittest.cpp | |
| @@ -11,6 +11,11 @@ | |
| #include <string.h> | |
| #include <getopt.h> | |
| #include <math.h> | |
| +#include <locale.h> | |
| + |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| johan@johan-HP-Z620-Workstation:~/Documents/clustercontrol-enterprise-master$ mysql -uproxytest -pproxytest -h10.10.10.14 -P6033 -e "select @@server_id" | |
| mysql: [Warning] Using a password on the command line interface can be insecure. | |
| +-------------+ | |
| | @@server_id | | |
| +-------------+ | |
| | 4 | | |
| +-------------+ | |
| johan@johan-HP-Z620-Workstation:~/Documents/clustercontrol-enterprise-master$ mysql -uproxytest -pproxytest -h10.10.10.14 -P6033 -e "select @@server_id" | |
| mysql: [Warning] Using a password on the command line interface can be insecure. | |
| +-------------+ |
freddielunchbird
/ gist:500f5d9cec25336994dc391521056a51
Created
October 14, 2016 08:52
mysql servers
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "result": [{ | |
| "data_nodes": [{ | |
| "compression": "0", | |
| "hostgroup_id": "20", | |
| "hostname": "10.10.10.13", | |
| "max_connections": "100", | |
| "max_latency_ms": "0", | |
| "max_replication_lag": "10", | |
| "port": "3306", |
freddielunchbird
/ gist:09f292c2f356a7f8ebb1089440519faf
Created
October 14, 2016 08:51
mysql query rules
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "result": [{ | |
| "errorMessage": "", | |
| "proxysql": { | |
| "hostname": "10.10.10.13", | |
| "port": 6032 | |
| }, | |
| "query_rules": [{ | |
| "active": "1", | |
| "apply": "1", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "result": [{ | |
| "errorMessage": "", | |
| "host_groups": [{ | |
| "reader_hostgroup": "20", | |
| "writer_hostgroup": "10" | |
| }], | |
| "proxysql": { | |
| "hostname": "10.10.10.13", | |
| "port": 6032 |
freddielunchbird
/ gist:10571739497394b78c366c086b7cfbd9
Created
May 11, 2016 07:55
Create cluster: one replica set (no config server, no mongos).
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "operation": "createJob", | |
| "job": { | |
| "command": "create_cluster", | |
| "job_data": { | |
| "type": "mongodb", | |
| "ssh_user": "csjpeter", | |
| "ssh_keyfile": "/home/csjpeter/.ssh/id_rsa", | |
| "api_id": 1, | |
| "user_id": 1, |
NewerOlder