docs/installation/upgrade_11gr2_52_rep_sql.html


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>Enabling Replication in the SQL Layer</title>
    <link rel="stylesheet" href="gettingStarted.css" type="text/css" />
    <meta name="generator" content="DocBook XSL Stylesheets V1.73.2" />
    <link rel="start" href="index.html" title="Berkeley DB Installation and Build Guide" />
    <link rel="up" href="upgrade_52_toc.html" title="Chapter 12.  Upgrading Berkeley DB 11.2.5.1 applications to Berkeley DB 11.2.5.2" />
    <link rel="prev" href="upgrade_11gr2_52_rep_2site_strict.html" title="2SITE_STRICT Enabled by Default in Replication" />
    <link rel="next" href="upgrade_11gr2_52_repmgr_channels.html" title="Repmgr Message Channels" />
  </head>
  <body>
    <div xmlns="" class="navheader">
      <div class="libver">
        <p>Library Version 12.1.6.1</p>
      </div>
      <table width="100%" summary="Navigation header">
        <tr>
          <th colspan="3" align="center">Enabling Replication in the SQL Layer </th>
        </tr>
        <tr>
          <td width="20%" align="left"><a accesskey="p" href="upgrade_11gr2_52_rep_2site_strict.html">Prev</a> </td>
          <th width="60%" align="center">Chapter 12.  Upgrading Berkeley DB 11.2.5.1 applications to Berkeley DB 11.2.5.2 </th>
          <td width="20%" align="right"> <a accesskey="n" href="upgrade_11gr2_52_repmgr_channels.html">Next</a></td>
        </tr>
      </table>
      <hr />
    </div>
    <div class="sect1" lang="en" xml:lang="en">
      <div class="titlepage">
        <div>
          <div>
            <h2 class="title" style="clear: both"><a id="upgrade_11gr2_52_rep_sql"></a>Enabling Replication in the SQL Layer </h2>
          </div>
        </div>
      </div>
      <div class="toc">
        <dl>
          <dt>
            <span class="sect2">
              <a href="upgrade_11gr2_52_rep_sql.html#idp1303192">New Pragmas</a>
            </span>
          </dt>
        </dl>
      </div>
      <p> 
        Replication can now be enabled and configured in the SQL
        layer using pragmas. The pragmas
        <code class="literal">replication_local_site</code>,
        <code class="literal">replication_initial_master</code>, and
        <code class="literal">replication_remote_site</code> can be used to
        configure the replication group. Note that when the BDB SQL
        replicated application is initially started, a specific master
        site must be explicitly designated. After configuring the
        replication group, start replication using <code class="literal">PRAGMA
        replication=ON</code>.
    </p>
      <p>
        To display replication statistics in the dbsql shell, use:
    </p>
      <pre class="programlisting">dbsql&gt; .stat :rep</pre>
      <div class="sect2" lang="en" xml:lang="en">
        <div class="titlepage">
          <div>
            <div>
              <h3 class="title"><a id="idp1303192"></a>New Pragmas</h3>
            </div>
          </div>
        </div>
        <p> 
            For more details on the replication pragmas see
            <a href="../bdb-sql/reppragma.html" class="olink">Replication PRAGMAs</a> in the <em class="citetitle">Berkeley DB Getting Started with the SQL APIs</em>
            guide.
            
        </p>
        <div class="itemizedlist">
          <ul type="disc">
            <li>
              <code class="literal">PRAGMA replication=ON|OFF</code>
            </li>
            <li>
              <code class="literal">PRAGMA
                    replication_initial_master=ON|OFF</code>
            </li>
            <li>
              <code class="literal">PRAGMA
                    replication_local_site="hostname:port"</code>
            </li>
            <li>
              <code class="literal">PRAGMA
                    replication_remote_site="hostname:port"</code>
            </li>
            <li>
              <code class="literal">PRAGMA
                    replication_remove_site="host:port"</code>
            </li>
            <li>
              <code class="literal">PRAGMA
                    replication_verbose_output=ON|OFF</code>
            </li>
            <li>
              <code class="literal">PRAGMA
                    replication_verbose_file=filename</code>
            </li>
          </ul>
        </div>
      </div>
    </div>
    <div class="navfooter">
      <hr />
      <table width="100%" summary="Navigation footer">
        <tr>
          <td width="40%" align="left"><a accesskey="p" href="upgrade_11gr2_52_rep_2site_strict.html">Prev</a> </td>
          <td width="20%" align="center">
            <a accesskey="u" href="upgrade_52_toc.html">Up</a>
          </td>
          <td width="40%" align="right"> <a accesskey="n" href="upgrade_11gr2_52_repmgr_channels.html">Next</a></td>
        </tr>
        <tr>
          <td width="40%" align="left" valign="top">2SITE_STRICT Enabled by Default in Replication </td>
          <td width="20%" align="center">
            <a accesskey="h" href="index.html">Home</a>
          </td>
          <td width="40%" align="right" valign="top"> Repmgr Message Channels </td>
        </tr>
      </table>
    </div>
  </body>
</html>