一分快三首页

  • <tr id='X11SfW'><strong id='X11SfW'></strong><small id='X11SfW'></small><button id='X11SfW'></button><li id='X11SfW'><noscript id='X11SfW'><big id='X11SfW'></big><dt id='X11SfW'></dt></noscript></li></tr><ol id='X11SfW'><option id='X11SfW'><table id='X11SfW'><blockquote id='X11SfW'><tbody id='X11SfW'></tbody></blockquote></table></option></ol><u id='X11SfW'></u><kbd id='X11SfW'><kbd id='X11SfW'></kbd></kbd>

    <code id='X11SfW'><strong id='X11SfW'></strong></code>

    <fieldset id='X11SfW'></fieldset>
          <span id='X11SfW'></span>

              <ins id='X11SfW'></ins>
              <acronym id='X11SfW'><em id='X11SfW'></em><td id='X11SfW'><div id='X11SfW'></div></td></acronym><address id='X11SfW'><big id='X11SfW'><big id='X11SfW'></big><legend id='X11SfW'></legend></big></address>

              <i id='X11SfW'><div id='X11SfW'><ins id='X11SfW'></ins></div></i>
              <i id='X11SfW'></i>
            1. <dl id='X11SfW'></dl>
              1. <blockquote id='X11SfW'><q id='X11SfW'><noscript id='X11SfW'></noscript><dt id='X11SfW'></dt></q></blockquote><noframes id='X11SfW'><i id='X11SfW'></i>
                Sybase技术

                Sybase RS基本配置

                Sybase RS基本配置

                安装配置
                • RSSD应该足够大,建议 RSSD data:500M RSSD log:500M,且RSSD设置为自⊙动清日志
                • 复制服务器〗配置足够大的partition
                • 安装复制』服务器后,保证@ 稳定运行必须修改的几个参数:
                  • set memory_limit to "256"(默认为1048576)
                  • set sts_cachesize to "2000"(默认为100)
                • 如果与复制服务器连接的数据库服务较多,则需要修改以下配置
                  • set cm_max_connections to "256"(默认为64)
                  • set um_client_connections to "100"(默认为30)
                  • set num_threads to "1024"(默认为50)
                  • set num_mutexes to "2048"
                  • set num_msgqueues to "2048"
                • 将maint登录(syslogins)在主点和〇复制点中的用户(user)删除,改为dbo_alias
                  • >use PDB
                    sp_dropuser dbname_maint
                    sp_addalias dbname_maint ,dbo
                  • >use RDB
                    sp_dropuser dbname_maint
                    sp_addalias dbname_maint,dbo
                • 如果采用WarmStandby,建议修改以下参数:
                  • suspend connection to RDS.RDB
                  • alter connection to RDS.RDB set dsi_xact_group_size to "-1"
                  • resume connection to RDS.RDB
                • 如果在复制系统中,数据库没有新增加表@,表结构也不会改变,建议采用表复制实现WarmStandby
                • 对于复制到复制点的数据不点燃触发器(WarmStandby缺省不点燃触发器,表复制缺省点燃触发器,不管采用何种方式,建议强制指明不点燃触发器)
                  • suspend connection to RDS.RDB
                  • alter connection to RDS.RDB set dsi_keep_triggers to 'off'
                  • resume connection to RDS.RDB