Skip to content

Instantly share code, notes, and snippets.

View CaptTofu's full-sized avatar

Patrick Galbraith CaptTofu

View GitHub Profile
Patricks-MacBook-Pro:mysql-galera patg$ kubectl get pods
NAME READY STATUS RESTARTS AGE
pxc-node1-sg8eq 1/1 Running 0 5m
pxc-node2-z0m4k 1/1 Running 0 5m
pxc-node3-rr95e 0/1 ContainerCreating 0 2m
Patricks-MacBook-Pro:mysql-galera patg$ kubectl exec pxc-node2-z0m4k -i -t -- mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.6.24-72.2-56-log Percona XtraDB Cluster (GPL), Release rel72.2, Revision 43abf03, WSREP version 25.11, wsrep_25.11
SQL> SELECT name, type_desc, is_unique, is_primary_key FROM sys.indexes WHERE [object_id] = OBJECT_ID('dbo.reguser');
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------+----------+---------------+
| name | type_desc | is_unique| is_primary_key|
+-----------------------------------------------------------------------------------------
mysql> desc session;
+-------------+--------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+-------------------+-----------------------------+
| remote_addr | varchar(16) | NO | | | |
| SessionID | varchar(32) | NO | PRI | | |
| memberID | int(11) | NO | UNI | 0 | |
| affiliateID | int(11) | NO | | NULL | |
| doing | varchar(255) | NO | | NULL | |
| tstamp | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
atlsmiswrl02-c:kubernetes-roles patg$ traceroute 8.8.8.8
traceroute to 8.8.8.8 (8.8.8.8), 64 hops max, 52 byte packets
1 10.10.10.10 (10.10.10.10) 21.409 ms 20.828 ms 20.245 ms
2 burl-lnk-70-109-168-167.ngn.east.myfairpoint.net (70.109.168.167) 20.152 ms
burl-lnk-70-109-168-169.ngn.east.myfairpoint.net (70.109.168.169) 20.760 ms 21.369 ms
3 burl-lnk-70-109-168-136.ngn.east.myfairpoint.net (70.109.168.136) 19.401 ms 16.341 ms
burl-lnk-70-109-168-134.ngn.east.myfairpoint.net (70.109.168.134) 19.713 ms
4 xe-2-0-0.mpr3.bos2.us.above.net (208.184.223.237) 26.536 ms 27.061 ms 25.296 ms
5 ae7.cr1.lga5.us.zip.zayo.com (64.125.21.226) 30.531 ms 32.523 ms 29.897 ms
6 ae1.cr2.lga5.us.zip.zayo.com (64.125.29.38) 30.034 ms 28.195 ms 30.002 ms
Patricks-MacBook-Pro:flannel patg$ ls -l
total 8
lrwxr-xr-x 1 patg staff 26 May 13 18:58 options.env -> ../../etc/flannel_opts.env
Patricks-MacBook-Pro:flannel patg$ ls -l ../../etc/flannel_opts.env
ls: ../../etc/flannel_opts.env: No such file or directory
Patricks-MacBook-Pro:flannel patg$
[Unit]
Description=Kubernetes Kubelet
Documentation=https://github.com/GoogleCloudPlatform/kubernetes
Requires=flanneld.service
After=flanneld.service
[Service]
EnvironmentFile=/etc/environment
ExecStart=/opt/bin/kubelet \
--address=0.0.0.0 \
--port=10250 \
Deprecated: Function ereg() is deprecated in /opt/app/public/includes/classes/Main.php on line 252
Deprecated: Function eregi_replace() is deprecated in /opt/app/public/includes/boolean_functions.inc.php on line 190
Deprecated: Function eregi_replace() is deprecated in /opt/app/public/includes/boolean_functions.inc.php on line 191
Deprecated: Function eregi_replace() is deprecated in /opt/app/public/includes/boolean_functions.inc.php on line 192
Deprecated: Function ereg_replace() is deprecated in /opt/app/public/includes/boolean_functions.inc.php on line 208
mongos> db.locks.find( { _id : "balancer" } ).pretty()
{
"_id" : "balancer",
"state" : 0,
"who" : "ip-172-31-28-205:27018:1461037929:1804289383:Balancer:846930886",
"ts" : ObjectId("5716450a5895fd10a3e9905e"),
"process" : "ip-172-31-28-205:27018:1461037929:1804289383",
"when" : ISODate("2016-04-19T14:47:38.286Z"),
"why" : "doing balance round"
}
mongos> db.testData.getShardDistribution()
Shard west1 at west1/ec2-52-53-243-185.us-west-1.compute.amazonaws.com:27017,ec2-54-153-95-198.us-west-1.compute.amazonaws.com:27017,ip-172-31-28-205:27017
data : 9.42MiB docs : 205846 chunks : 3
estimated data per chunk : 3.14MiB
estimated docs per chunk : 68615
Totals
data : 9.42MiB docs : 205846 chunks : 3
Shard west1 contains 100% data, 100% docs in cluster, avg obj size on shard : 48B
-- Sharding Status ---
sharding version: {
"_id" : 1,
"minCompatibleVersion" : 5,
"currentVersion" : 6,
"clusterId" : ObjectId("5713c23c28b7146220118d0a")
}
shards:
{ "_id" : "west1", "host" : "west1/ec2-52-53-243-185.us-west-1.compute.amazonaws.com:27017,ec2-54-153-95-198.us-west-1.compute.amazonaws.com:27017,ip-172-31-28-205:27017" }
{ "_id" : "west2", "host" : "west2/ec2-54-186-125-103.us-west-2.compute.amazonaws.com:27017,ec2-54-200-15-235.us-west-2.compute.amazonaws.com:27017,ip-172-31-17-143:27017" }