mirror of
https://github.com/yasuhirokimura/db18
synced 2026-06-08 18:29:23 +00:00
Yasuhiro KIMURA
65 lines
4.4 KiB
HTML
65 lines
4.4 KiB
HTML
<?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 12. 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 18.1.40</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 12. 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#idm140649572339712">PRAGMAs With Permanent Effects</a></span></dt><dt><span class="sect2"><a href="upgrade_11gr2_53_sql_rep.html#idm140649572332416">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="idm140649572339712"></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="idm140649572332416"></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>
|