#####################################################################
################# 1. Инсталиране на NODE  ###########################
#####################################################################

groupadd mysql;
useradd -g mysql mysql;

cd /var/tmp/;

wget http://dev.mysql.com/get/Downloads/MySQL-Cluster-7.1/mysql-cluster-gpl-7.1.15-linux-i686-glibc23.tar.gz/from/http://mysql.mirrors.ovh.net/ftp.mysql.com/ -O mysql-cluster-gpl-7.1.15-linux-i686-glibc23.tar.gz;

tar -C /usr/local -xzvf mysql-cluster-gpl-7.1.15-linux-i686-glibc23.tar.gz;

ln -s /usr/local/mysql-cluster-gpl-7.1.15-linux-i686-glibc23/ /usr/local/mysql;
export PATH=$PATH:/usr/local/mysql/bin;
echo "export PATH=\$PATH:/usr/local/mysql/bin" >> /etc/bash.bashrc;

cd /usr/local/mysql;

./scripts/mysql_install_db --user=mysql;

chown -R root .;
chown -R mysql data;
chgrp -R mysql .;

cp support-files/mysql.server /etc/init.d/mysql;
chmod +x /etc/init.d/mysql;
update-rc.d mysql defaults;

########################################################################
################# 2. Инсталиране на MANAGER  ###########################
########################################################################

cd /var/tmp/;

wget http://dev.mysql.com/get/Downloads/MySQL-Cluster-7.1/mysql-cluster-gpl-7.1.15-linux-i686-glibc23.tar.gz/from/http://mysql.mirrors.ovh.net/ftp.mysql.com/ -O mysql-cluster-gpl-7.1.15-linux-i686-glibc23.tar.gz

tar zxvf mysql-cluster-gpl-7.1.15-linux-i686-glibc23.tar.gz;

cp -Rvp /var/tmp/mysql-cluster-gpl-7.1.15-linux-i686-glibc23/bin/ndb_mgm* /usr/local/bin;

chmod +x /usr/local/bin/ndb_mgm*;

##################################№№######################################
################# 3. Конфигуриране на MANAGER  ###########################
####################################№№####################################

mkdir /var/lib/mysql-cluster;
vi /var/lib/mysql-cluster/config.ini;

[ndbd default]

NoOfReplicas=2

DataMemory=80M

IndexMemory=18M

[tcp default]

[ndb_mgmd]

hostname=192.193.194.2 # Hostname or IP address of MGM node

datadir=/var/lib/mysql-cluster # Directory for MGM node log files

[ndbd]

hostname=192.193.194.3 # Hostname or IP address

datadir=/usr/local/mysql/data # Directory for this data node’s data files

[ndbd]

hostname=192.193.194.4 # Hostname or IP address

datadir=/usr/local/mysql/data # Directory for this data node’s data files

[mysqld]

hostname=192.193.194.3 # Hostname or IP address

[mysqld]

hostname=192.193.194.4 # Hostname or IP address

##################################№№######################################
################# 4. Конфигуриране на NODE     ###########################
####################################№№####################################
mkdir /var/run/mysqld/
chown -R mysql.mysql /var/run/mysqld/

vi /etc/my.cnf

[client]

port = 3306

socket = /var/run/mysqld/mysqld.sock

[mysqld]

port = 3306

socket = /var/run/mysqld/mysqld.sock

skip-locking

ndbcluster # run NDB storage engine

ndb-connectstring=192.193.194.2 # location of management server

#general_log_file        = /var/log/mysql.log
#general_log             = 1

[mysql_cluster]

ndb-connectstring=192.193.194.2 # location of management server

touch /var/log/mysql.log;chown -R mysql.adm mysql.log;

#За нова инсталация на mysql
mysqladmin -uroot password mysqlpass

#За стара инсталация на MySQL
#mysqladmin -u root -p'oldpassword' password newpass

##################################№№###########################################
################# 5. Стартиране на MySQL Cluster    ###########################
####################################№№#########################################

5.1. Стартира се на MySQL Manager
ndb_mgmd -f /var/lib/mysql-cluster/config.ini --configdir=/var/lib/mysql-cluster

5.2. Стартира се на всеки MySQL Node
/usr/local/mysql/bin/ndbd;
/etc/init.d/mysql start;

##################################№№###########################################
################# 6. Тестване на MySQL Cluster      ###########################
####################################№№#########################################
mysql -uroot
create database testdb;
use testdb;
CREATE TABLE cluster_test (i INT) ENGINE=NDBCLUSTER;
INSERT INTO cluster_test (i) VALUES (1);
SELECT * FROM cluster_test;

##################################№№###########################################
################# 7. Инсталиране на MySQL Balancer  ###########################
####################################№№#########################################

7.1. На всеки Node
mysql>
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'remoterootamri1proxypass' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Тестване
mysql -uroot -h192.193.194.5 -premoterootamri1proxypass

7.2. На всеки Load balancer
## Вариант -> mysql-proxy

apt-get install mysql-proxy

vim /etc/default/mysql-proxy

ENABLED="true"
OPTIONS="
--proxy-backend-addresses=192.193.194.3:3306 \
--proxy-backend-addresses=192.193.194.4:3306 \
--daemon \
--admin-username=mysqlproxyadmin \
--admin-password=mysqlproxypass1
"

## Вариант -> haproxy
apt-get install haproxy

/etc/haproxy/haproxy.conf

global
log 127.0.0.1 daemon debug
stats socket /tmp/stats
maxconn 4096
pidfile /var/run/haproxy.pid
daemon

defaults
log global
mode tcp
option dontlognull retries 3 option redispatch
maxconn 2000
contimeout 5000
clitimeout 50000
srvtimeout 50000

listen MySQL 192.193.194.2:4040
mode tcp
option httpchk
#stats enable
#stats uri /haproxy-stats
balance roundrobin

#server mysql_master 192.193.194.3:3306
#server mysql_slave 192.193.194.4:3306

server ns1 192.193.194.3:3306 weight 10
server mail 192.193.194.4:3306 weight 10

listen stats 192.193.194.2:8000
mode http
option httpclose
balance roundrobin

stats uri     /haproxy
stats realm   Haproxy\ Statistics
stats auth    user:password

7.3. Тестване на mysql-proxy
mysql -uroot -h127.0.0.1 -P 4040 -premoterootamri1proxypass

mysql -uroot -h192.193.194.2 -P 4040 -premoterootamri1proxypass

mysql -usocial_network -h192.193.194.2 -P 4040 -pmysqlpassword

##################################№№###########################################
################# 8. Грешки при инсталиране         ###########################
####################################№№#########################################

При инсталиране на NODE

# ./scripts/mysql_install_db --user=mysql;

FATAL ERROR: Could not find mysqld

The following directories were searched:

/usr/libexec
/usr/sbin
/usr/bin

If you compiled from source, you need to run 'make install' to
copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top
level of the extracted archive, or pass the --basedir option
pointing to that location.

Решение: rm -fr /etc/mysql

-----------------
/var/lib/mysql-cluster/ndb_1_cluster.log

2011-07-19 12:18:51 [MgmtSrvr] WARNING  --- 1011 Unable to connect with connect string: nodeid=0,localhost:1186
2011-07-19 12:18:51 [MgmtSrvr] ERROR    --- Failed to connect to ourself!

Решение:

Във файл /etc/hosts се добавя следния ред:

127.0.0.1 localhost

---------------------
mysql> create database testdb;
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> show warnings;
+-------+------+---------------------------------------------------------------------------------+
| Level | Code | Message                                                                         |
+-------+------+---------------------------------------------------------------------------------+
| Error | 1296 | Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock |
+-------+------+---------------------------------------------------------------------------------+

ИЛИ

mysql> CREATE TABLE cluster_test (i INT) ENGINE=NDBCLUSTER;
ERROR 157 (HY000): Could not connect to storage engine

Решение: да се рестартират услугите ndbd и mysql и да се изчакат няколко секунди за да се синхронизират услугите
----------------------------------
mysql> select * from a10_articles limit 1;
ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER
mysql> show warnings;
+-------+------+--------------------------------------------------------------------+
| Level | Code | Message                                                            |
+-------+------+--------------------------------------------------------------------+
| Error | 1296 | Got error 4009 'Cluster Failure' from NDB                          |
| Error | 1296 | Got error 157 'Unknown error code' from NDBCLUSTER                 |
| Error | 1033 | Incorrect information in file: './social_network/a10_articles.frm' |
+-------+------+--------------------------------------------------------------------+
3 rows in set (0.00 sec)

Проблема е, че е стартиран ndbd без mysql
----------------------------------
ns1:/tmp# mysql -uroot social_network < social_network_filled.sql
ERROR 1005 (HY000) at line 1188: Can't create table 'social_network.a13_articles' (errno: 136)

В ndb_1_cluster.log лога се вижда следното

2011-07-19 13:14:24 [MgmtSrvr] INFO     --- Node 2: index-build table 218 index: 225 processed 0 rows
2011-07-19 13:14:24 [MgmtSrvr] INFO     --- Node 3: index-build table 218 index: 225 processed 0 rows

perror 136
В превод това означава: MySQL error code 136: No more room in index file

-------------------------
mysql> show warnings;
+-------+------+---------------------------------------------------------------------------------+
| Level | Code | Message                                                                         |
+-------+------+---------------------------------------------------------------------------------+
| Error | 1296 | Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock |
| Error | 1296 | Got error 4009 'Cluster Failure' from NDB                                       |
+-------+------+---------------------------------------------------------------------------------+
пуснах с ndbd --initial всичките нодове и се оправи, но се затри всичко!
-------------------
ERROR 1114 (HY000) at line 402: The table 'a10_users' is full

##################################№№###########################################
################# 9. Бележки при използването на клъстера  ####################
####################################№№#########################################
Използване на аргумент --initial
/usr/local/mysql/bin/ndbd --initial ;
Само при първоначалното стартиране е добре да се ползва --initial защото това изтрива всички логове и бази данни от клъсетера

# Добавяне на потребител (На всеки нод)
#!/bin/bash
mysqlpassword="mysqlpassword";
mysql -e "CREATE DATABASE ads_network" -p;
mysql -e "GRANT ALL ON ads_network.* TO ads_network@'%' IDENTIFIED BY '$mysqlpassword' WITH GRANT OPTION;" -p
mysql -e "FLUSH PRIVILEGES;" -p;

# Рестартиране на manager-a
killall -15 ndb_mgmd;ndb_mgmd -f /var/lib/mysql-cluster/config.ini --configdir=/var/lib/mysql-cluster --nodaemon;
При всяка промяна на конфигурационния файл "config.ini" е необходимо при изпълнението на ndb_mgmd да се добави и аргумент "--reload" т.е.

killall -15 ndb_mgmd;ndb_mgmd -f /var/lib/mysql-cluster/config.ini --configdir=/var/lib/mysql-cluster --reload

# Рестартиране на node-a

killall -15 ndbd;/etc/init.d/mysql stop;/usr/local/mysql/bin/ndbd;/etc/init.d/mysql start;

При изпълнение на "ndb_show_tables" дава следната грешка:

Configuration error: Error : Could not alloc node id at 192.193.194.2 port 1186: No free node id found for mysqld(API).
Unable to connect to management server.

NDBT_ProgramExit: 1 -- Failed

Решение: няма достатъчно API Слотове
config.ini
[mysqld]
[mysqld]

Рестартиране , Спиране и Стартиране на node от ndb_mgm
2 restart -- Рестартира node 2
2 start -- Стартира node 2
2 stop -- Спира node 2

------------
ИЗПОЛЗВАНЕ НА DISK METHOD за клъстериране

SELECT * FROM INFORMATION_SCHEMA.FILES \G

select file_name, free_extents, total_extents from information_schema.files where file_type='datafile';

CREATE LOGFILE GROUP lgroup_ads
ADD UNDOFILE 'undo_lgroup_ads.dat'
INITIAL_SIZE 16M
UNDO_BUFFER_SIZE 2M
ENGINE NDB;

CREATE TABLESPACE ts_ads_network
ADD DATAFILE 'data_ads_network.dat'
USE LOGFILE GROUP lgroup
INITIAL_SIZE 32M
ENGINE NDB;

CREATE LOGFILE GROUP lgroup
ADD UNDOFILE 'undo_lgroup_1.dat'
INITIAL_SIZE 2M
ENGINE NDB;

ALTER LOGFILE GROUP lgroup
ADD UNDOFILE 'undo_lgroup_3.dat'
INITIAL_SIZE 4000M
ENGINE NDB;

CREATE TABLESPACE ts_ads_network
ADD DATAFILE 'data_ads_network_1.dat'
USE LOGFILE GROUP lgroup
INITIAL_SIZE 20M
ENGINE NDB;

ALTER TABLESPACE ts_ads_network
ADD DATAFILE 'data_ads_network_3.dat'
INITIAL_SIZE 4000M
ENGINE NDB;

DROP database social_network;create database social_network;use social_network;
ALTER TABLESPACE ts_social_network DROP DATAFILE 'data_social_network.dat' ENGINE NDB;
ALTER TABLESPACE ts_social_network DROP DATAFILE 'data_social_network_2.dat' ENGINE NDB;

DROP TABLESPACE ts_social_network ENGINE NDB;
DROP LOGFILE GROUP lgroup ENGINE NDB;

drop table a10_articles;
ALTER TABLESPACE ts_ads_network DROP DATAFILE 'data_ads_network.dat' ENGINE NDB;
DROP TABLESPACE ts_ads_network ENGINE NDB;
DROP LOGFILE GROUP social_network ENGINE NDB;

-----------------
CREATE TABLE `articles` (
…..
) TABLESPACE ts_ads_network STORAGE DISK ENGINE NDB AUTO_INCREMENT=9573 DEFAULT CHARSET=utf8;

find $PWD -type f -exec sed -i 's/varchar(120)/varchar(200)/g' {} \;

find $PWD -type f -exec sed -i 's/ENGINE=MyISAM/TABLESPACE ts_ads_network STORAGE DISK ENGINE NDB/g' {} \;

##################################№№###########################################
################# 10. Debug при използването на клъстера  №####################
####################################№№#########################################
/usr/local/mysql/bin/ndb_config --configinfo | grep -C 3 Index

/usr/local/mysql/bin/ndb_config --configinfo --config-file=/var/lib/mysql-cluster/config.ini|grep -C3 MaxNoOfTables

/usr/local/mysql/bin/ndb_config  --type ndbd -q Id,MaxNoOfOrderedIndexes,MaxNoOfUniqueHashIndexes -r '\n'

ndb_show_tables | grep -c OrderedIndex

ndb_mgm> ALL REPORT MEMORY
Connected to Management Server at: 192.193.194.2:1186
Node 2: Data usage is 25%(665 32K pages of total 2560)
Node 2: Index usage is 15%(370 8K pages of total 2336)
Node 3: Data usage is 25%(665 32K pages of total 2560)
Node 3: Index usage is 15%(370 8K pages of total 2336)

Стартиране на ndb_mgmd с --nodaemon за да се debugwa всичко което идва към клъстера
ndb_mgmd -f /var/lib/mysql-cluster/config.ini --configdir=/var/lib/mysql-cluster --nodaemon;

ndb_mgm> ALL DUMP 1000;

# Виждат се фазите на стартиране на нода
ndb_mgm> all status;
Node 2: starting (Last completed phase 4) (mysql-5.1.56 ndb-7.1.15)
Node 3: started (mysql-5.1.56 ndb-7.1.15)

##################################№№###########################################
################# 11. Performance при използването на клъстера  ###############
####################################№№#########################################
Чрез ndb_size ще може да се изчисли необходимото пространство за обслужването на базата която ще бъде конвертирана към NDBCluster Engine.

При стартиране на ndb_size.pl дава следната грешка:

perl /usr/local/mysql/bin/ndb_size.pl
Can't locate Class/MethodMaker.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at /usr/local/mysql/bin/ndb_size.pl line 58.
BEGIN failed--compilation aborted at /usr/local/mysql/bin/ndb_size.pl line 58.

Решението е:
apt-get install libclass-methodmaker-perl

Директна статистика в терминала
perl /usr/local/mysql/bin/ndb_size.pl --database=test --socket=/var/run/mysqld/mysqld.sock

Статистика в HTML файл
perl /usr/local/mysql/bin/ndb_size.pl social_network localhost root  > mysql_ndb_size_stat.html

Ръчно въвеждане на дата 20.07.2011:

date +%Y%m%d -s "20110720"

Ръчно въвеждане на час 21:35:00:

date +%T -s "21:35:00"

 

Още по- лесен метод е този:

date -s "07/20/2011 21:35:00"

Друг лесен метод е(най- предпочитаният за мен) (Става ясно кое какво е):

date 072021412011.55

Извеждане стойността на хардуерния часовник:

hwclock --show
Mon 12 Mar 2012 11:43:19 PM EET  -0.969038 seconds

Синхронизация на системния часовник с хардуерния:

hwclock --systohc

Идеята е, че когато искам да кача много файлове на samba ресурс (чрез smbclient) вместо да ги качам по отделно с "put" или с "mput", но да потвърждавам с "y" се използва рекурсивния начин. Защо трябва да се активира ? Защото по подразбиране рекурсивното ъплоадване е деактивирано.

Активиране на mput рекурсивно качване на файлове, чрез smbclient:

smbclient //192.168.1.100/source
Enter machine's password:
Domain=[AMR] OS=[Windows 5.1] Server=[Windows 2000 LAN Manager]
smb: \> recurse
smb: \> prompt
smb: \> mput *
putting file file-1.log as \file-1.log (1682.1 kb/s) (average 1682.1 kb/s)
putting file file.log as \file.log (2303.9 kb/s) (average 1979.9 kb/s)

На Gnome когато изключвам машината ми дрънчи следния прозорец

"
gnome-keyring-daemon
not responding
"

С други думи keyring-a не се shutdown-ва нормално. Ето го и решението:

killall -9 gnome-keyring-daemon
rm -rf ~/.gnome2/keyrings

##############################################################
1. Install  Icinga 1.4.1
##############################################################
apt-get install php5-cli php-pear php5-xmlrpc php5-xsl php5-ldap php5-gd php5-mysql

create mysql user:icinga_web , pass:icingapass
mysql -uroot icinga_web -p < /usr/src/icinga-1.4.1/module/idoutils/db/mysql/mysql.sql

cd /usr/src
wget 'http://sourceforge.net/projects/icinga/files/icinga/1.4.1/icinga-1.4.1.tar.gz/download' -O icinga-1.4.1.tar.gz
tar zxvf icinga-1.4.1.tar.gz
cd icinga-1.4.1
./configure --enable-idoutils
make all
make fullinstall

cd /usr/local/icinga/etc/;
cp idomod.cfg-sample idomod.cfg
cp ido2db.cfg-sample ido2db.cfg

vim ido2db.cfg
Change mysql db/user/pass

vim /usr/local/icinga/etc/icinga.cfg

Uncomment the line:

broker_module=/usr/local/icinga/bin/idomod.o config_file=/usr/local/icinga/etc/idomod.cfg

##############################################################
2. Install Icinga Web
##############################################################
cd /usr/src

wget http://sourceforge.net/projects/icinga/files/icinga-web/1.4.1/icinga-web-1.4.1.tar.gz/download -O icinga-web-1.4.1.tar.gz

wget http://sourceforge.net/projects/icinga/files/icinga-web/1.4.1/icinga-web-1.4.1.tar.gz.md5/download -O icinga-web-1.4.1.tar.gz.md5

md5sum -c icinga-web-1.4.1.tar.gz.md5

tar zxvf icinga-web-1.4.1.tar.gz
cd icinga-web-1.4.1

./configure --prefix=/usr/local/icinga-web --with-icinga-api=/usr/local/icinga/share/icinga-api --with-db-name=icinga_web --with-db-user=icinga_web --with-db-pass=icingapass

make install

make testdeps

make db-initialize

Use the db-user specified in icinga-webs database.xml (Needs create Database/create Table rights)?(n,y)? y

vi /usr/local/icinga-web/app/modules/Web/config/icinga-io.site.xml

<setting name="api.interfaces.data">
<ae:parameter name="api_type">IcingaApi::CONNECTION_IDO</ae:parameter>
<ae:parameter name="config_type">mysql</ae:parameter>
<ae:parameter name="config_host">127.0.0.1</ae:parameter>
<ae:parameter name="config_port">3306</ae:parameter>
<ae:parameter name="config_database">icinga</ae:parameter>
<ae:parameter name="config_user">icinga</ae:parameter>
<ae:parameter name="config_password">password</ae:parameter>
<ae:parameter name="config_table_prefix">icinga_</ae:parameter>
</setting>

/usr/local/icinga-web/bin/clearcache.sh

vi /etc/apache2/conf.d/icinga-web.conf

Alias /icinga-web /usr/local/icinga-web/pub
<directory /usr/local/icinga-web/pub>
AllowOverride All
</directory>

/etc/init.d/apache2 restart

http://172.16.2.2/icinga-web/

##############################################################
3. Install nagios plugins
##############################################################
cd /usr/src
wget http://sourceforge.net/projects/nagiosplug/files/nagiosplug/1.4.15/nagios-plugins-1.4.15.tar.gz/download -O 'nagios-plugins-1.4.15.tar.gz'

tar zxvf nagios-plugins-1.4.15.tar.gz
cd nagios-plugins-1.4.15
./configure --prefix=/usr/local/icinga --with-icinga-user=icinga
make
make install

##############################################################
4. Възникнали грешки
##############################################################

При използване на "Commands":

IcingaApiCommandSendPipeException: checkConfig(): Pipe "/usr/local/icinga/var/rw/icinga.cmd" is missing or not writable!

Решение:

chmod -R 777 /usr/local/icinga/var/rw/

Архивиране от локална в локална директория

$ rsync -vur --delete --exclude='cache' --exclude='2011-06' 1/ 2/

Архивиране от локална в отдалечена директория

$ rsync -r -a -v -e "ssh -l ssh_user" --delete  /local/webroot server.in:/webroot/

Архивиране от отдалечена в локална директория

$ rsync -r -a -v -e "ssh -l ssh_user" --delete server.in:/webroot  /local/webroot

Arris CMTS Cadant C3:

Извеждане на power нивата на всеки upstream

sh conf | include power

Резултат:

DS/US     Prim Online    Timing Rec   CPE   IP address      MAC address    DOC
Interface SID  state     offset power
C1/0/U0.0 1    online      1445 9.8   1/2   30.1.36.123     0114.f8bd.2c5e D1.1
C1/0/U0.0 2    online      2225 10.2  0/2   30.1.30.85      003f.21cf.16f3 D1.1
C1/0/U2.0 3    online(d)   2206 9.8   0/2   30.1.30.194     050f.21cf.07de D1.1
C1/0/U0.0 4    online      2233 10.2  1/2   30.1.37.55      009f.21d5.8d08 D1.1

Извеждане на клиенти на конкретен Upstream. В случая Upstream 2

show cable modem | include U2

Резултат

C1/0/U2.0 3    online(d)   2206 9.8   0/2   30.1.30.194     280f.21cf.07de D1.1
C1/0/U2.0 19   online      1602 10.0  0/2   30.1.31.6       1300.cac9.0e7d D1.1
C1/0/U2.0 22   online      1433 10.2  0/2   30.1.35.210     1511.e621.fbf7 D1.1
C1/0/U2.0 31   online      1458 10.0  1/2   30.1.31.21      181e.6b25.ad5e D1.1
C1/0/U2.0 55   offline     1441 10.2  0/1   30.1.37.120     1922.3aff.ec3d D1.0
C1/0/U2.0 63   online      1425 7.0   1/2   30.1.35.215     2214.f8d2.b5d6 D1.1

Arris Cornerstone CMTS 1500

Първо трябва да се влезе в "Management subsystem" -> man

cable-level
upstream-list
show

Резултат

Upstream list

Channel  Status   Speed      In Octets   Mod Profile  Frequency  Power  Window
-------  -------  ---------  ----------  -----------  ---------  -----  ------
4        up       5120000    1327319160  1            30000000   0      120
5        up       5120000    2758304477  1            30500000   0      60
6        up       5120000    3025350475  1            31000000   0      60
7        up       5120000    0           1            31500000   0      120
8        up       5120000    3080412538  1            32000000   0      60
9        up       5120000    715961397   1            32500000   0      60
10       up       5120000    952901802   1            33000000   0      60
11       up       5120000    3043657984  1            33500000   0      60

Извеждане на подробна информация за модемите (може и без да се влиза в man mode само се изпълнява "modem")

man
cable-level
modem-list

Резултат:

Modems list

Modem  Mac Address        Ip Address       DnCh  UpCh  RxPwr  Status
-----  -----------------  ---------------  ----  ----  -----  ---------------
1      13:0a:73:f6:00:57  30.1.37.73       3     6     -1     regstr-complete
2      22:1e:6b:f7:b6:1d  30.1.36.168      3     4     -1     regstr-complete
3      13:0f:21:d5:8d:ad  30.1.33.20       3     4     1      regstr-complete
4      91:24:d1:a2:3c:04  30.1.35.198      3     6     0      regstr-complete
5      81:0f:21:cf:2a:1c  30.1.37.189      3     11    1      rng-aborted

Извеждане на обща статистика за ползваемостта на всичките upstream-и

modem total

Резултат

Channel    Active CMs   Registered CMs
-------    ----------   --------------
1           52             52
2            0              0
3           30             29
4            0              0
5           56             56
6           12             12
7           12             12
8           80             78
-------    ----------   --------------
TOTAL          242            239