Skip to content

Instantly share code, notes, and snippets.

View phlegx's full-sized avatar
💪
never stop coding

Phlegx Systems phlegx

💪
never stop coding
30 followers · 19 following
View GitHub Profile
@phlegx
phlegx / gist:3033423
Created July 2, 2012 14:10
[1341237536] SERVICE ALERT: hano;Manager SERVICE c1;CRITICAL;SOFT;3;<A HREF="https://hano.example.com:443https://cm.example.com/livetest/c01" target="_blank">HTTP CRITICAL: HTTP/1.1 503 Service Temporarily Unavailable - string 'UP' not found on 'https://hano.example.com:443https://cm.example.com/livetest/c01' - 557 bytes in 0.028 second response time </A>
[1341237536] SERVICE EVENT HANDLER: hano;Manager SERVICE c1;CRITICAL;SOFT;3;nrpe_event_handler!remove_cluster_node
@phlegx
phlegx / gist:3058912
Created July 6, 2012 08:21
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UNKNOWN qlen 1000
link/ether c8:60:00:be:37:6f brd ff:ff:ff:ff:ff:ff
3: eth1: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN qlen 1000
link/ether 68:05:ca:01:b8:97 brd ff:ff:ff:ff:ff:ff
@phlegx
phlegx / gist:3060516
Created July 6, 2012 14:35
## installation:
rpm -ivh MySQL-Cluster-gpl-client-7.1.22-1.el6.x86_64.rpm MySQL-Cluster-gpl-devel-7.1.22-1.el6.x86_64.rpm MySQL-Cluster-gpl-server-7.1.22-1.el6.x86_64.rpm MySQL-Cluster-gpl-storage-7.1.22-1.el6.x86_64.rpm
## error:
Preparing... ########################################### [100%]
file /usr/share/mysql/charsets/Index.xml from install of MySQL-Cluster-gpl-server-7.1.22-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64
file /usr/share/mysql/charsets/armscii8.xml from install of MySQL-Cluster-gpl-server-7.1.22-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64
file /usr/share/mysql/charsets/ascii.xml from install of MySQL-Cluster-gpl-server-7.1.22-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.61-1.el6_2.1.x86_64
@phlegx
phlegx / gist:3060759
Created July 6, 2012 15:09
Removing:
mysql-libs x86_64 5.1.61-1.el6_2.1 @updates 4.0 M
Removing for dependencies:
cronie x86_64 1.4.4-7.el6 @anaconda-CentOS-201112102333.x86_64/6.2 166 k
cronie-anacron x86_64 1.4.4-7.el6 @anaconda-CentOS-201112102333.x86_64/6.2 43 k
crontabs noarch 1.10-33.el6 @anaconda-CentOS-201112102333.x86_64/6.2 2.4 k
postfix x86_64 2:2.6.6-2.2.el6_1 @anaconda-CentOS-201112102333.x86_64/6.2 9.7 M
@phlegx
phlegx / gist:3060971
Created July 6, 2012 15:40
[root@podeu]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.0.1 (mysql-5.1.61 ndb-7.1.22, Nodegroup: 0)
id=3 @192.168.0.2 (mysql-5.1.61 ndb-7.1.22, Nodegroup: 0, Master)
@phlegx
phlegx / gist:3062132
Created July 6, 2012 19:03
Exception Object
(
[message:protected] => Could not connect to host (http://127.0.0.1:18083/)
[string:Exception:private] =>
[code:protected] => 64
[file:protected] => /var/www/default/vbox/lib/vboxconnector.php
[line:protected] => 188
[trace:Exception:private] => Array
(
[0] => Array
@phlegx
phlegx / gist:3076202
Created July 9, 2012 12:28
120709 14:07:50 [Note] /usr/sbin/mysqld: Shutdown complete
120709 14:07:50 mysqld_safe mysqld from pid file /var/lib/mysql/rexler.pid ended
120709 14:07:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120709 14:07:51 [Note] Plugin 'FEDERATED' is disabled.
120709 14:07:51 InnoDB: Initializing buffer pool, size = 8.0M
120709 14:07:51 InnoDB: Completed initialization of buffer pool
120709 14:07:51 InnoDB: Started; log sequence number 0 44233
120709 14:07:52 [Note] NDB: NodeID is 4, management server 'c03-dev:1186'
120709 14:08:22 [Note] NDB[0]: NodeID: 4, no storage nodes connected (timed out)
@phlegx
phlegx / gist:3076208
Created July 9, 2012 12:31
ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.0.1 (mysql-5.1.61 ndb-7.1.22, Nodegroup: 0, Master)
id=3 @192.168.0.2 (mysql-5.1.61 ndb-7.1.22, Nodegroup: 0)
@phlegx
phlegx / gist:3083280
Created July 10, 2012 13:35
mysql> SHOW ENGINE NDB STATUS;
+------------+-----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Type | Name | Status |
+------------+-----------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ndbcluster | connection | cluster_node_id=4, connected_host=c03-dev, connected_port=1186, number_of_data_nodes=2, number_of_ready_data_nodes=2, connect_count=0 |
| ndbcluster | NdbTransaction | created=2, free=2, sizeof=368
@phlegx
phlegx / gist:3083406
Created July 10, 2012 14:01
mysql --user=root --password=xxx -Bse "select CONCAT('ALTER TABLE ', table_schema,'.', table_name,' ENGINE=NDBCLUSTER') from information_schema.tables where table_schema='waree2';" | mysql --user=root --password=xxx
ERROR 1064 (42000) at line 1: 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 'ALTER TABLE waree2.channelproperty ENGINE=NDBCLUSTER
ALTER TABLE switchv2.glob' at line 2