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>
|