全文検索:
- 51 MySQLベンチマーク(mysqlslap) @01_linux:11_データベース:01_mysql
- generated tables. --auto-generate-sql-load-type=name Specify test load type: mi... on in server/client protocol. -c, --concurrency=name Number of clients to simulate for query to run. --create=name File or string to use create tables. --create-schema=name Schema to run tests in.
- fio @01_linux:09_ベンチマーク
- ンチマーク ===== ==== シーケンシャルwrite ==== # fio -filename=/tmp/fio2g -direct=1 -rw=write -bs=4k -size=2G -numjobs=64 -runtime=10 -group_reporting -name=fio ==== ランダムwrite ==== # fio -filename=/tmp/fio2g -direct=1 -rw=randwrite -bs=4k -size=2G -numjobs=64 -runtime=10 -group_reporting -name=fio ==== シーケンシャルread ==== # fio -filename=/tm
- 41 CentOS7 NIC名変更 @01_linux:01_net
- それをethに変更してみます。 ===== grub変更 ===== grubに「biosdevname=0 net.ifnames=0」を追加 <code> # cp -p /etc/default/g... ntos/root rd.lvm.lv=centos/swap rhgb quiet biosdevname=0 net.ifnames=0" GRUB_DISABLE_RECOVERY="true" </c... ACTION=="add",ATTR{address}=="xx:xx:xx:xx:xx:xx",NAME="eth0" SUBSYSTEM=="net", ACTION=="add",ATTR{address}=="xx:xx:xx:xx:xx:xx",NAME="eth1" SUBSYSTEM=="net", ACTION=="add",ATTR{addre
- 04 Postfix+MySQL+Postfix AdminでバーチャルSMTPサーバの構築 @01_linux:03_mail
- = <code> # vi /etc/postfix/main.cf 70 myhostname = test.flateight.com 92 myorigin = $myhostname 107 #inet_interfaces = all 109 inet_interfaces = $myhostname, localhost 155 #mydestination = $myhostname, localhost.$mydomain, localhost 158 mydestination =
- 01 PostgreSQL streaming replica @01_linux:11_データベース:02_postgresql
- で高可用性と読取に対するスケールアウトを実現するストリーミングレプリケーションを作成 ^hostname^IP^ |pg1001|172.16.0.51| |pg1002|172.16.0.52| |pg... List of databases Name | Owner | Encoding | Collate | Ctype | Ac... esql.auto.conf primary_conninfo = へ追加 application_name=postgresql ## Secondaryは下記をコメントアウト # grep synchr... 51 -U postgres testdb -c "UPDATE actor set first_name='BBB' where actor_id=1" UPDATE 1 $ psql -h 172.
- 19 HPE Insight Management Agents Trap Alarm @01_linux:12_ツール
- ead/Write Authorized Management Station IP or DNS name (Blank to skip): Enter Read Only Authorized Management Station IP or DNS name (Blank to skip): Enter default SNMP trap communi... to skip): Enter SNMP trap destination IP or DNS name (One word; Blank to skip): The system contact is... -c -f <(echo -e "${EXCLUDE}")) -le 0 ] ;then NAME=${HOST}${HOSTNAME} if [ "${TO}" = "ZABBIX" ]
- 29 Ceph Dashboard @01_linux:13_storage
- c-user-create admin adminxxxx administrator {"username": "admin", "lastUpdate": 1592953680, "name": null, "roles": ["administrator"], "password": "$2b$12$iOz4... metheus: image: prom/prometheus container_name: prometheus environment: TZ: Asia/Tokyo... a: image: grafana/grafana:7.3.0 container_name: grafana environment: - TZ=Asia/Tokyo
- 01 ネットワーク設定nmcli @01_linux:21_centos7
- うになったので、いまさらメモ ===== 状態確認 ===== <code> # nmcli c NAME UUID TYPE ... up eth0 ===== ホスト名 ===== # nmcli general hostname proxy1001 ===== DNS ===== # nmcli c m eth0 ip... など # nmcli con mod "eth3" connection.interface-name eth3 新規コネクション追加 # nmcli con add type ethernet ifname eth3 con-name eth3 <color #ed1c24>※SoftEtherの場合、
- 29 screenに外からコマンド @01_linux:99_その他
- $THREAD ] do N=`printf "%02d" "${i}"` SCREEN_NAME=${ZONE}-${N} LOG="${LOGDIR}/${ZONE}_${N}.log" ... pr $i + 1` if [ -n "`screen -ls | grep ${SCREEN_NAME}`" ]; then echo "already have session_name. ${SCREEN_NAME}" continue 2 fi screen -R ${SCREEN_NAME} sleep 1 screen -d ${SCREEN_NAME}
- 13 CentOS6メール設定 @01_linux:03_mail
- h = private/auth smtpd_sasl_local_domain = $myhostname ## 証明書 smtpd_use_tls = yes smtpd_tls_cert_file =... - n - - smtpd -o syslog_name=postfix/submission -o smtpd_tls_security_level=... asl_authenticated,reject -o milter_macro_daemon_name=ORIGINATING smtps inet n - n - - smtpd -o syslog_name=postfix/smtps -o smtpd_tls_wrappermode=yes -o
- 22 Ceph create-volume でエラー @01_linux:13_storage
- y Running command: /usr/bin/ceph --cluster ceph --name client.bootstrap-osd --keyring /var/lib/ceph/boot... k Running command: /usr/bin/ceph --cluster ceph --name client.bootstrap-osd --keyring /var/lib/ceph/boot... ar/lib/ceph/osd/ceph-0/keyring --create-keyring --name osd.0 --add-key AQAgZk9fqxUgKRAA8gJEbwtnuVb91YJHV... borted) ** stderr: in thread 7f600913da80 thread_name:ceph-osd stderr: 2020-09-02 18:30:10.567 7f60091
- 05 ゲストCentOS5をVirtio化 @01_linux:08_仮想化:kvm
- 意しておく <code> root# cd /boot root# cp -p initrd-$(uname -r).img initrd-$(uname -r)_ide.img root# mkinitrd -v -f --with=virtio_pci --with=virtio_blk initrd-$(uname -r).img $(uname -r) </code> ===== 2.起動ファイル修正 ===== # virsh edit [VM] ===== Disk ===== target de
- 01 Galera構築 @01_linux:11_データベース:01_mysql
- tions #wsrep_provider_options= # Logical cluster name. Should be the same for all nodes. wsrep_cluster_name="onapp_db_cluster" # Group communication system ... er_address="gcomm://:4567" # Human-readable node name (non-unique). Hostname by default. #wsrep_node_name= # Base replication <address|hostname>[:port] of t
- 14 MariaDB @01_linux:11_データベース:01_mysql
- '; +------------------------+--------+ | Variable_name | Value | +------------------------+---... le'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+------... --------------------------+----------+ | Variable_name | Value | +-----------------------... -------------------------+-----------+ | Variable_name | Value | +------------------------
- 60 CentOS OpenVPN @01_linux:01_net
- rt KEY_CN=changeme ← 行頭に#を追加してコメントアウト #export KEY_NAME=changeme ← 行頭に#を追加してコメントアウト #export KEY_OU=change... IENT LIST Updated,Mon Mar 10 16:16:53 2014 Common Name,Real Address,Bytes Received,Bytes Sent,Connected ... 4:03:54 2014 ROUTING TABLE Virtual Address,Common Name,Real Address,Last Ref 10.8.0.6,client1,210.172.14... 0 END kill client1 ← client1強制切断 SUCCESS: common name 'client1' found, 1 client(s) killed status ← VPN