达梦数据库创建多实例

<h1>达梦数据库创建多实例</h1> <h2>Linux</h2> <h3>1.原先实例保持不变，初始化一个新实例 DMENG01</h3> <pre><code>./dminit path=/risen/soft/database/dmdba/data db_name=DMENG01 instance_name=DMSERVER01 CHARSET=1 CASE_SENSITIVE=0 LENGTH_IN_CHAR=1 EXTENT_SIZE=32 PAGE_SIZE=32 port_num=5237</code></pre> <h3>2.初始化后检查参数</h3> <pre><code> CHARSET=1 表示使用utf8 select SF_GET_UNICODE_FLAG();</code></pre> <pre><code> CASE_SENSITIVE=1 SELECT SF_GET_CASE_SENSITIVE_FLAG();1为大小写敏感，0为大小写不敏感</code></pre> <pre><code> LENGTH_IN_CHAR=1 达梦数据库之间备份dmp文件并还原，大小写敏感和 LENGTH_IN_CHAR这个参数需要一致 SELECT SF_GET_LENGTH_IN_CHAR();</code></pre> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/dce7ebdadc08644cf0972868fbe3269a" alt="" /></p> <h3>3.注册新的服务</h3> <pre><code>./dm_service_installer.sh -t dmserver -dm_ini /risen/soft/database/dmdba/data/DMENG01/dm.ini -p DMSERVER01</code></pre> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/c7569c0b6e6f74961c0ba22ef8fafdfc" alt="" /></p> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/71c70c5cef8c1e18765677ccadd2ce98" alt="" /></p> <h2>windows</h2> <h3>1.打开DM数据库配置助手</h3> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/a7d9f037fb831701a3db6c2d9e7cada9" alt="" /></p> <h3>2.创建数据库实例</h3> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/16338985367861e2c1acf711db184ad1" alt="" /></p> <h3>3.选择一般用户</h3> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/ccc58223c71668050543b01adc66e553" alt="" /></p> <h3>4.选择新实例的安装路径</h3> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/f69e5274ade1fb9c80c6732115793704" alt="" /></p> <h3>5.指定新实例的端口何名称</h3> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/39f92ef092feee4e102cf1e018b7667d" alt="" /></p> <h3>6.下一步</h3> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/20f1b25fc897cf08885a87f78d015a11" alt="" /></p> <h3>7.设置簇大小(32)、页大小(32)、大小写不敏感、字符集UTF-8、varchar类型为字符集</h3> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/366ccec39a9f60509fdd0160943fee09" alt="" /></p> <h3>8.设置账户密码</h3> <p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/5972277b4f322c5094829beceef1d01c" alt="" /></p> <p>下面直接下一步，完成就好，新实例就创建完毕了</p>