| 操作环境 | 需求细节内容 | 说明 |
| 所有节点 | yum -y install bzip2 yum -y install gdb yum -y install libsss_nss_idmap yum -y install cyrus-sasl yum -y install cyrus-sasl-gssapi yum -y install resource-agents -- for ha |
|
| 所有节点 | [root@mssql01 install]# rpm -ivh mssql-server-14.0.3037.1-2.x86_64.rpm warning: mssql-server-14.0.3037.1-2.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID be1229cf: NOKEY Preparing... ################################# [100%] Updating / installing... 1:mssql-server-14.0.3037.1-2 ################################# [100%] |
|
| 所有节点 | [root@mssql01 install]# /opt/mssql/bin/mssql-conf setup Choose an edition of SQL Server: 1) Evaluation (free, no production use rights, 180-day limit) 2) Developer (free, no production use rights) 3) Express (free) 4) Web (PAID) 5) Standard (PAID) 6) Enterprise (PAID) 7) Enterprise Core (PAID) 8) I bought a license through a retail sales channel and have a product key to enter. ... Enter your edition(1-8): 7 ... Do you accept the license terms? [Yes/No]:yes Enter the SQL Server system administrator password: Confirm the SQL Server system administrator password: Configuring SQL Server... ... Created symlink from /etc/systemd/system// to /usr/lib/systemd/system/. Setup has completed successfully. SQL Server is now starting. |
1. 第6安装产品名为: Microsoft SQL Server Enterprise (64-bit)；第7安装产品名为: Microsoft SQL Server Enterprise: Core-based Licensing (64-bit) 2. Enterprise Per Core license 模式最大计算能力限制为操作系统最大值，而Enterprise Server+CAL license 模式为20核 3. 该步骤会启动mssql服务并将其设置为开机自启动 |
| 所有节点 |
rpm -ivh unixODBC-2.3.1-11.el7.x86_64.rpm [root@mssql01 install]# rpm -ivh msodbcsql17-17.2.0.1-1.x86_64.rpm warning: msodbcsql17-17.2.0.1-1.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID be1229cf: NOKEY Preparing... ################################# [100%] The license terms for this product can be downloaded from /odbc172eula and found in /usr/share/doc/msodbcsql17/ . By entering 'YES', you indicate that you accept the license terms. Do you accept the license terms? (Enter YES or NO) yes Updating / installing... 1:msodbcsql17-17.2.0.1-1 ################################# [100%] |
msodbcsql17 >= 17.2.0.0 is needed by (installed) mssql-tools-17.2.0.1-1.x86_64 msodbcsql17 < 17.3.0.0 is needed by (installed) mssql-tools-17.2.0.1-1.x86_64 如果有安装旧版mssql工具或较旧的 unixODBC包，请先删除 yum remove mssql-tools unixODBC-utf16-devel |
| 所有节点 | [root@mssql01 install]# rpm -ivh mssql-tools-17.2.0.1-1.x86_64.rpm warning: mssql-tools-17.2.0.1-1.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID be1229cf: NOKEY Preparing... ################################# [100%] The license terms for this product can be downloaded from /fwlink/?LinkId=746949 and found in /usr/share/doc/mssql-tools/ . By entering 'YES', you indicate that you accept the license terms. Do you accept the license terms? (Enter YES or NO) yes Updating / installing... 1:mssql-tools-17.2.0.1-1 ################################# [100%] |
sqlcmd与bcp工具 |
| 所有节点 | mkdir -p /data001/prd/mssql/CU10/{data,cnf,log,dump,backup,audit} chown -R /data001 chmod 755 -R /data001 |
|
| 所有节点 | systemctl stop mssql-server /opt/mssql/bin/mssql-conf set-collation Enter the collation: Chinese_PRC_CI_AS /opt/mssql/bin/mssql-conf set false /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/data /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/data /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/dump /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/log/errorlog /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/backup /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/audit systemctl start mssql-server |
改server排序规则（高危操作，非新建必须先备份） /opt/mssql/bin/mssql-conf set-collation Enter the collation: Chinese_PRC_CI_AS 配置客户反馈 /opt/mssql/bin/mssql-conf set false 默认数据目录 /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/data 默认日志目录 /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/data 默认转储目录 /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/dump 默认错误日志目录 /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/log/errorlog 默认备份目录 /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/backup 本地审核目录 /opt/mssql/bin/mssql-conf set /data001/prd/mssql/CU10/audit |
| 所有节点 | 启用 SQL Server 代理 /opt/mssql/bin/mssql-conf set true 重新启动 SQL Server: systemctl restart mssql-server |
从SQL Server 2017 CU4开始，SQL Server Agent是随附mssql server封装，并预设为停用；在之前版本需要额外安装mssql-server-agent，否则会报错 |
| 所有节点 | Root用户 echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc source ~/.bash_profile source ~/.bashrc |
|
| 所有节点 | sqlcmd -S localhost -U SA -P 1> select name from ; 2> GO |
|
| 所有节点 | 新增4个数据文件（最多与CPU数相同），初始5GB，自动增长100MB 日志文件初始100MB，自动增长100MB |
Linux安装sqlserver时无法选择tempdb文件个数，需要自行添加 |