Deploying a two-node clustered file server

Deploying a two-node clustered file server
部署雙節點叢集檔案伺服器 
https://docs.microsoft.com/zh-tw/windows-server/failover-clustering/deploy-two-node-clustered-file-server

英文版Windows安裝注音輸入法

原來只要把繁體中文版Windows位於C:\Windows\IME\底下的IMETC資料夾複製貼上到英文版Windows一樣路徑(需重開機)就有注音輸入法了

備註一:字型檔路徑是C:\Windows\Fonts
備註二:Language Pack沒有IME，只有中文UI

參考:
https://www.youtube.com/watch?v=lvon3n16vEM

locate: 無法執行 stat()「/var/lib/mlocate/mlocate.db」: 沒有此一檔案或目錄

需要先執行updatedb


[root@db ~]# locate postgresql.conf
locate: 無法執行 stat()「/var/lib/mlocate/mlocate.db」: 沒有此一檔案或目錄
[root@db ~]# updatedb
[root@db ~]# locate postgresql.conf
/etc/postgresql-setup/upgrade/postgresql.conf
/usr/lib/tmpfiles.d/postgresql.conf
/usr/share/pgsql/postgresql.conf.sample
/var/lib/pcp/pmdas/postgresql/pmdapostgresql.conf
/var/lib/pgsql/data/postgresql.conf
[root@db ~]#
[root@db ~]# locate pg_hba.conf
/usr/share/pgsql/pg_hba.conf.sample
/var/lib/pgsql/data/pg_hba.conf
[root@db ~]#

 
LAB環境: CentOS-8.2.2004

IPv6遠端桌面的port

TCP 45001

luci-app-ddns

https://www.opencli.com/internet/openwrt-setup-ddns

https://openwrt.org/docs/guide-user/services/ddns/client
https://openwrt.org/docs/guide-user/base-system/ddns

OpenWrt安裝fwknopd

root@myrouter:~# opkg install fwknopd
Installing fwknopd (2.6.10-3) to root...
Downloading http://downloads.openwrt.org/releases/19.07.3/packages/arm_cortex-a9/packages/fwknopd_2.6.10-3_arm_cortex-a9.ipk
Installing libfko (2.6.10-3) to root...
Downloading http://downloads.openwrt.org/releases/19.07.3/packages/arm_cortex-a9/packages/libfko_2.6.10-3_arm_cortex-a9.ipk
Installing libpcap1 (1.9.1-2.1) to root...
Downloading http://downloads.openwrt.org/releases/19.07.3/packages/arm_cortex-a9/base/libpcap1_1.9.1-2.1_arm_cortex-a9.ipk
Configuring libfko.
Configuring libpcap1.
Configuring fwknopd.


安裝完後再安裝luci-app-fwknopd
https://openwrt.org/docs/guide-user/services/fwknop


ref:
https://newtoypia.blogspot.com/2018/02/spa.html

Differences between global Azure, Azure Stack Hub, and Azure Stack HCI

https://docs.microsoft.com/zh-tw/azure-stack/operator/compare-azure-azure-stack?view=azs-2002

https://www.facebook.com/groups/AzureTWUG/permalink/2689088474653853/

• HPE 推出 Edgeline EL8000 較小型一體機規格支援 Azure Stack Hub
• HPE ProLiant for Microsoft Azure Stack Hub 與 Dell EMC Integrated System for Azure Stack Hub 針對 GPU 機型支援進入技術預覽階段

Dell EMC Solutions for Microsoft Azure Stack HC

https://www.delltechnologies.com/zh-tw/solutions/software-defined/microsoft-wssd.htm

HPE EDGELINE 系統

https://buy.hpe.com/tw/zh/servers/edgeline-systems/c/1008663980

HPE推電訊級實時處理平台 Edgeline EL8000
http://itpromag.com/2019/03/01/hpeedgeline-el8000/

HPE Solutions for Microsoft Azure Stack HCI

https://www.hpe.com/us/en/alliance/microsoft/azurestackhci.html 

修改Docker組態檔開放外部透過TCP 2375操作Docker

修改Docker組態檔開放TCP 2375 (有資安風險，請僅用於開發環境！)
vi /usr/lib/systemd/system/docker.service
加入以下組態
[Service]
ExecStart=
ExecStart=/usr/bin/dockerd -H tcp://0.0.0.0:2375 -H unix://var/run/docker.sock

重啟Docker服務
systemctl daemon-reload
systemctl restart docker

開通防火牆
firewall-cmd --zone=public --add-port=2375/tcp --permanent
firewall-cmd --reload


環境:CentOS

參考
https://www.cnblogs.com/hongdada/p/11512901.html

SQL Server 2016 標準版SP1之後下放的企業版功能

SQL Server 2016 標準版SP1之後下放的企業版功能，居然連免費的Express版也支援(驚)

https://docs.microsoft.com/zh-tw/archive/blogs/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released

各版本比較

https://docs.microsoft.com/zh-tw/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-ver15

AD server和DB透過DNS SRV達成高可用性

※本文章只是網路找到的解決方案，尚未實測或導入 ※

https://serverfault.com/questions/374154/how-to-make-ad-highly-available-for-applications-that-use-it-as-an-ldap-service

The correct way to do this is to use the DNS SRV records to look up the domain controller names and ports, as well as ascertain which servers to use in what order. Unfortunately, not many LDAP applications seem to support SRV record lookups.

The SRV record for Active Directory domain controllers is _ldap._tcp.domain.tld. This will return a list of hosts and ports, as well as a priority and weight for each (these values can be set using Group Policy) that together indicate which server to use.

也意外發現資料庫也開始支援DNS SRV的方式達成高可用性
MySQL 8.0.19
https://mp.weixin.qq.com/s/G3dW_GPDd1l1MJ86c7iFTA
我还在想这事儿就应该由 MySQL Connector 来实现访问链路的 Failover 和 Loadbalance， 现在有了 DNS SRV 的支持，router 不必和应用端绑定部署，也可以省了 VIP 和负载均衡，MySQL InnoDB Cluster 方案更加完善，配合 consul 等服务发现组件，更容易适配 service mesh 架构。

PostgreSQL 12.0
https://mp.weixin.qq.com/s/hGeGiqm3D52aQJsS61QoGg

開啟效能魔力窗 T-SQL 視窗函數的實務技巧

使用Window Function改善效能
比如:累計彙總(cumulative aggregates)、移動平均值(moving averages)
https://channel9.msdn.com/Events/TechDays/TechDays-Taiwan-2014/DBI307

許致學老師在channel9的影片
https://channel9.msdn.com/Events/Speakers/lancelot-hsu

sendStringParametersAsUnicode

JDBC預設是true，會自動把字元資料轉成Unicode格式送到伺服器
但是資料庫column不是開nchar之類的Unicode UCS-2欄位
因為SQL Server需要做型別轉換，會需要用到平行處理，會很耗cpu
從執行計畫可以看到"type conversion in expression"的警告訊息
解法一:column改成nvarvhar nchar這類的欄位
解法二:sendStringParametersAsUnicode設定成false，使用非Unicode格式送到伺服器(比如ASCII/MBCS)
今天上許致學老師的課才知道有這參數

https://sqlwizard.blog/2018/07/29/performance-impact-of-jdbc-connectionstring-property-sendstringparametersasunicode/

https://community.jaspersoft.com/wiki/microsoft-sqlserver-jdbc-connection-sending-string-values-unicode-even-if-they-are-just-simple

https://docs.microsoft.com/zh-tw/sql/connect/jdbc/reference/setsendstringparametersasunicode-method-sqlserverdatasource?view=sql-server-ver15

"type conversion in expression" sql server

https://www.google.com/search?ei=9aYAX7bPJYLm0QT675_IBg&q=%22type+conversion+in+expression%22+sql+server&oq=%22type+conversion+in+expression%22+sql+server&gs_lcp=CgZwc3ktYWIQAzIICAAQBxAKEB4yBAgAEB4yBggAEAgQHjIGCAAQCBAeOggIABAHEB4QEzoKCAAQBxAKEB4QEzoECAAQEzoKCAAQBxAFEB4QEzoKCAAQCBAHEB4QEzoICAAQCBAKEB5Q22FY2K0BYNWvAWgAcAB4AIABQogBoAKSAQE1mAEAoAEBqgEHZ3dzLXdpeg&sclient=psy-ab&ved=0ahUKEwj2neWc-7PqAhUCc5QKHfr3B2kQ4dUDCAw&uact=5