blob: 1762cc9c4d9164032eac9fd149422c7d4b762aba (
plain)
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
|
<?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 11. 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 12.1.6.1</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 11. 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#idp1192472">PRAGMAs With Permanent Effects</a></span></dt><dt><span class="sect2"><a href="upgrade_11gr2_53_sql_rep.html#idp1199416">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="idp1192472"></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="idp1199416"></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>
|
