安装后,两种方式存储:XML,sqlserver
建立缓存集
New-CacheCluster -Provider System.Data.SqlClient -ConnectionString "Data Source=[ServerName];Initial Catalog=[DBName];Integrated Security=True" -Size Small
Register-CacheHost -Provider System.Data.SqlClient -ConnectionString "Data Source=[ServerName];Initial Catalog=[DBName];Integrated Security=True" -Account "NT Authority\Network Service" -CachePort 22233 -ClusterPort 22234 -ArbitrationPort 22235 -ReplicationPort
22236 -HostName [CacheHostName]
Add-CacheHost -Provider System.Data.SqlClient -ConnectionString "Data Source=[ServerName];Initial Catalog=[DBName];Integrated Security=True" -Account "NT Authority\Network Service"
Add-CacheAdmin -Provider System.Data.SqlClient -ConnectionString "Data Source=[ServerName];Initial Catalog=[DBName];Integrated Security=True"
添加防火墙in/out端口配置
Use-CacheCluster
Get-CacheHost
Start-CacheCluster
Start-CacheHost hostname:22233
Stop-CacheCluster
Stop-CacheHost hostname:22233
Get-CacheAllowedClientAccounts
Grant-CacheAllowedClientAccount NetworkService
Get-CacheStatistics default
Get-CacheConnectionString
本文提供了一套详细的步骤指南,用于在 SQL Server 中设置缓存集群,包括初始化缓存集群、配置缓存主机、添加主机、设置防火墙规则、使用集群以及获取统计数据等关键操作。
4178

被折叠的 条评论
为什么被折叠?



