From a4e7f360c91236168a903e74ab3669a3f03bc690 Mon Sep 17 00:00:00 2001
From: "bbaetz%student.usyd.edu.au" <>
Date: Sat, 21 Dec 2002 07:35:14 +0000
Subject: Bug 180870 - Remove old shadowdb manual replication code r, a=myk
---
docs/sgml/administration.sgml | 31 ++++++++++++-------------------
docs/sgml/database.sgml | 5 -----
docs/sgml/installation.sgml | 4 +---
docs/xml/administration.xml | 31 ++++++++++++-------------------
docs/xml/database.xml | 5 -----
docs/xml/installation.xml | 4 +---
6 files changed, 26 insertions(+), 54 deletions(-)
(limited to 'docs')
diff --git a/docs/sgml/administration.sgml b/docs/sgml/administration.sgml
index 1873ee025..847527203 100644
--- a/docs/sgml/administration.sgml
+++ b/docs/sgml/administration.sgml
@@ -69,8 +69,14 @@
write locking. What this means is that if someone needs to make a
change to a bug, they will lock the entire table until the operation
is complete. Locking for write also blocks reads until the write is
- complete. The
- shadowdb
+ complete. Note that more recent versions of mysql support row level
+ locking using different table types. These types are slower than the
+ standard type, and Bugzilla does not yet take advantage of features
+ such as transactions which would justify this speed decrease. The
+ Bugzilla team are, however, happy to hear about any experiences with
+ row level locking and Bugzilla
+
+ The shadowdb
parameter was designed to get around this limitation. While only a
single user is allowed to write to a table at a time, reads can
continue unimpeded on a read-only shadow copy of the database.
@@ -85,23 +91,10 @@
Bugzilla bug changes and comments per day.
The value of the parameter defines the name of the
- shadow bug database.
- Set "shadowdb" to e.g. "bug_shadowdb" if you will be running a
- *very* large installation of Bugzilla.
-
- Enabling "shadowdb" can adversely affect the stability of
- your installation of Bugzilla. You should regularly check that your
- database is in sync. It is often advisable to force a shadow
- database sync nightly via
- cron
.
-
-
-
-
- If you use the "shadowdb" option, it is only natural that you
- should turn the "queryagainstshadowdb" option on as well. Otherwise
- you are replicating data into a shadow database for no reason!
-
+ shadow bug database. You will need to set the host and port settings
+ from the params page, and set up replication in your database server
+ so that updates reach this readonly mirror. Consult your database
+ documentation for more detail.
diff --git a/docs/sgml/database.sgml b/docs/sgml/database.sgml
index ae1918207..d32bb57cc 100644
--- a/docs/sgml/database.sgml
+++ b/docs/sgml/database.sgml
@@ -198,7 +198,6 @@
| products |
| profiles |
| profiles_activity |
-| shadowlog |
| tokens |
| versions |
| votes |
@@ -290,10 +289,6 @@ sshh... don't tell your users!)
profiles_activity: Need to know who did what when to who's profile? This'll
tell you, it's a pretty complete history.
-shadowlog: I could be mistaken here, but I believe this table tells you when
-your shadow database is updated and what commands were used to update it. We
-don't use a shadow database at our site yet, so it's pretty empty for us.
-
versions: Version information for every product
votes: Who voted for what when
diff --git a/docs/sgml/installation.sgml b/docs/sgml/installation.sgml
index 8d1a94ec7..7aec021ce 100644
--- a/docs/sgml/installation.sgml
+++ b/docs/sgml/installation.sgml
@@ -559,9 +559,7 @@ AllowOverride Limit
There are important files and directories that should not be a
served by the HTTP server - most files in the
data
- and
- shadow
- directories and the
+ directory and the
localconfig
file. You should configure your HTTP server to not serve
these files. Failure to do so will expose critical passwords and
diff --git a/docs/xml/administration.xml b/docs/xml/administration.xml
index 1873ee025..847527203 100644
--- a/docs/xml/administration.xml
+++ b/docs/xml/administration.xml
@@ -69,8 +69,14 @@
write locking. What this means is that if someone needs to make a
change to a bug, they will lock the entire table until the operation
is complete. Locking for write also blocks reads until the write is
- complete. The
- shadowdb
+ complete. Note that more recent versions of mysql support row level
+ locking using different table types. These types are slower than the
+ standard type, and Bugzilla does not yet take advantage of features
+ such as transactions which would justify this speed decrease. The
+ Bugzilla team are, however, happy to hear about any experiences with
+ row level locking and Bugzilla
+
+ The shadowdb
parameter was designed to get around this limitation. While only a
single user is allowed to write to a table at a time, reads can
continue unimpeded on a read-only shadow copy of the database.
@@ -85,23 +91,10 @@
Bugzilla bug changes and comments per day.
The value of the parameter defines the name of the
- shadow bug database.
- Set "shadowdb" to e.g. "bug_shadowdb" if you will be running a
- *very* large installation of Bugzilla.
-
- Enabling "shadowdb" can adversely affect the stability of
- your installation of Bugzilla. You should regularly check that your
- database is in sync. It is often advisable to force a shadow
- database sync nightly via
- cron
.
-
-
-
-
- If you use the "shadowdb" option, it is only natural that you
- should turn the "queryagainstshadowdb" option on as well. Otherwise
- you are replicating data into a shadow database for no reason!
-
+ shadow bug database. You will need to set the host and port settings
+ from the params page, and set up replication in your database server
+ so that updates reach this readonly mirror. Consult your database
+ documentation for more detail.
diff --git a/docs/xml/database.xml b/docs/xml/database.xml
index ae1918207..d32bb57cc 100644
--- a/docs/xml/database.xml
+++ b/docs/xml/database.xml
@@ -198,7 +198,6 @@
| products |
| profiles |
| profiles_activity |
-| shadowlog |
| tokens |
| versions |
| votes |
@@ -290,10 +289,6 @@ sshh... don't tell your users!)
profiles_activity: Need to know who did what when to who's profile? This'll
tell you, it's a pretty complete history.
-shadowlog: I could be mistaken here, but I believe this table tells you when
-your shadow database is updated and what commands were used to update it. We
-don't use a shadow database at our site yet, so it's pretty empty for us.
-
versions: Version information for every product
votes: Who voted for what when
diff --git a/docs/xml/installation.xml b/docs/xml/installation.xml
index 8d1a94ec7..7aec021ce 100644
--- a/docs/xml/installation.xml
+++ b/docs/xml/installation.xml
@@ -559,9 +559,7 @@ AllowOverride Limit
There are important files and directories that should not be a
served by the HTTP server - most files in the
data
- and
- shadow
- directories and the
+ directory and the
localconfig
file. You should configure your HTTP server to not serve
these files. Failure to do so will expose critical passwords and
--
cgit v1.2.3-24-g4f1b