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
|
<?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>Replication for Existing Databases in the SQL API</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_53_toc.html" title="Chapter 9. Upgrading Berkeley DB 11.2.5.2 applications to Berkeley DB 11.2.5.3" />
<link rel="prev" href="upgrade_11gr2_53_sql_pragma.html" title="New Berkeley DB SQL API PRAGMAs" />
<link rel="next" href="upgrade_11gr2_53_xa_mvcc.html" title="Berkeley DB X/Open Compliant XA Resource Manager and Transaction Snapshots" />
</head>
<body>
<div xmlns="" class="navheader">
<div class="libver">
<p>Library Version 11.2.5.3</p>
</div>
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center">Replication for Existing Databases in the SQL API</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="upgrade_11gr2_53_sql_pragma.html">Prev</a> </td>
<th width="60%" align="center">Chapter 9.
Upgrading Berkeley DB 11.2.5.2 applications to Berkeley DB 11.2.5.3
</th>
<td width="20%" align="right"> <a accesskey="n" href="upgrade_11gr2_53_xa_mvcc.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_53_sql_rep"></a>Replication for Existing Databases in the SQL API</h2>
</div>
</div>
</div>
<div class="toc">
<dl>
<dt>
<span class="sect2">
<a href="upgrade_11gr2_53_sql_rep.html#idp837896">PRAGMAs With Permanent Effects</a>
</span>
</dt>
<dt>
<span class="sect2">
<a href="upgrade_11gr2_53_sql_rep.html#idp844568">PRAGMAs That Can Now Operate on Existing Databases</a>
</span>
</dt>
</dl>
</div>
<p>
Replication can now be enabled on existing SQL databases, and
replication is now disabled permanently instead of temporarily.
Replication is enabled on an existing database the same way it is
enabled on a new database, with one restriction. The existing
database must configure itself as the initial master of a new
replication group. To disable replication on a
database permanently, use <code class="literal">pragma replication=OFF;</code>.
</p>
<div class="sect2" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h3 class="title"><a id="idp837896"></a>PRAGMAs With Permanent Effects</h3>
</div>
</div>
</div>
<div class="itemizedlist">
<ul type="disc">
<li>
<code class="literal">pragma replication=OFF;</code>
</li>
</ul>
</div>
</div>
<div class="sect2" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h3 class="title"><a id="idp844568"></a>PRAGMAs That Can Now Operate on Existing Databases</h3>
</div>
</div>
</div>
<div class="itemizedlist">
<ul type="disc">
<li>
<code class="literal">pragma replication_local_site="host:port";</code>
</li>
<li>
<code class="literal">pragma replication_initial_master=ON;</code>
</li>
<li>
<code class="literal">pragma replication=ON;</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_53_sql_pragma.html">Prev</a> </td>
<td width="20%" align="center">
<a accesskey="u" href="upgrade_53_toc.html">Up</a>
</td>
<td width="40%" align="right"> <a accesskey="n" href="upgrade_11gr2_53_xa_mvcc.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top">New Berkeley DB SQL API PRAGMAs </td>
<td width="20%" align="center">
<a accesskey="h" href="index.html">Home</a>
</td>
<td width="40%" align="right" valign="top"> Berkeley DB X/Open Compliant XA Resource Manager and Transaction Snapshots </td>
</tr>
</table>
</div>
</body>
</html>
|
