Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC

Merge lp:~hrvojem/percona-xtradb-cluster/kewpietest into lp:~percona-dev/percona-xtradb-cluster/5.5.20

  1. kewpietest
  2. Merge into 5.5.20
Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Vadim Tkachenko
Approved revision: no longer in the source branch.
Merged at revision: 3721
Proposed branch: lp:~hrvojem/percona-xtradb-cluster/kewpietest
Merge into: lp:~percona-dev/percona-xtradb-cluster/5.5.20
Diff against target: 230 lines (+180/-1)
5 files modified
.bzrignore (+1/-1)
doc/Makefile (+130/-0)
doc/source/faq.rst (+13/-0)
doc/source/index.rst (+1/-0)
doc/source/kewpietests.rst (+35/-0)
To merge this branch: bzr merge lp:~hrvojem/percona-xtradb-cluster/kewpietest
Reviewer Review Type Date Requested Status
Vadim Tkachenko Approve
Review via email: mp+93880@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Vadim Tkachenko (vadim-tk) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file '.bzrignore'
--- .bzrignore 2012-02-17 18:41:32 +0000
+++ .bzrignore 2012-02-20 17:18:00 +0000
@@ -103,6 +103,7 @@
103CTestTestfile.cmake103CTestTestfile.cmake
104COPYING104COPYING
105COPYING.LIB105COPYING.LIB
106doc/build/*
106Docs/#manual.texi#107Docs/#manual.texi#
107Docs/INSTALL-BINARY108Docs/INSTALL-BINARY
108Docs/Images/myaccess-odbc.txt109Docs/Images/myaccess-odbc.txt
@@ -156,7 +157,6 @@
156INSTALL-WIN-SOURCE157INSTALL-WIN-SOURCE
157Logs/*158Logs/*
158MIRRORS159MIRRORS
159Makefile
160Makefile.in160Makefile.in
161Makefile.in'161Makefile.in'
162PENDING/*162PENDING/*
163163
=== added file 'doc/Makefile'
--- doc/Makefile 1970-01-01 00:00:00 +0000
+++ doc/Makefile 2012-02-20 17:18:00 +0000
@@ -0,0 +1,130 @@
1# Makefile for Sphinx documentation
2#
3
4# You can set these variables from the command line.
5SPHINXOPTS =
6SPHINXBUILD = sphinx-build
7PAPER =
8BUILDDIR = build
9
10# Internal variables.
11PAPEROPT_a4 = -D latex_paper_size=a4
12PAPEROPT_letter = -D latex_paper_size=letter
13ALLSPHINXOPTS = -d $(BUILDDIR)/doctrees $(PAPEROPT_$(PAPER)) $(SPHINXOPTS) source
14
15.PHONY: help clean html dirhtml singlehtml pickle json htmlhelp qthelp devhelp epub latex latexpdf text man changes linkcheck doctest
16
17help:
18 @echo "Please use \`make <target>' where <target> is one of"
19 @echo " html to make standalone HTML files"
20 @echo " dirhtml to make HTML files named index.html in directories"
21 @echo " singlehtml to make a single large HTML file"
22 @echo " pickle to make pickle files"
23 @echo " json to make JSON files"
24 @echo " htmlhelp to make HTML files and a HTML help project"
25 @echo " qthelp to make HTML files and a qthelp project"
26 @echo " devhelp to make HTML files and a Devhelp project"
27 @echo " epub to make an epub"
28 @echo " latex to make LaTeX files, you can set PAPER=a4 or PAPER=letter"
29 @echo " latexpdf to make LaTeX files and run them through pdflatex"
30 @echo " text to make text files"
31 @echo " man to make manual pages"
32 @echo " changes to make an overview of all changed/added/deprecated items"
33 @echo " linkcheck to check all external links for integrity"
34 @echo " doctest to run all doctests embedded in the documentation (if enabled)"
35
36clean:
37 -rm -rf $(BUILDDIR)/*
38
39html:
40 $(SPHINXBUILD) -b html $(ALLSPHINXOPTS) $(BUILDDIR)/html
41 @echo
42 @echo "Build finished. The HTML pages are in $(BUILDDIR)/html."
43
44dirhtml:
45 $(SPHINXBUILD) -b dirhtml $(ALLSPHINXOPTS) $(BUILDDIR)/dirhtml
46 @echo
47 @echo "Build finished. The HTML pages are in $(BUILDDIR)/dirhtml."
48
49singlehtml:
50 $(SPHINXBUILD) -b singlehtml $(ALLSPHINXOPTS) $(BUILDDIR)/singlehtml
51 @echo
52 @echo "Build finished. The HTML page is in $(BUILDDIR)/singlehtml."
53
54pickle:
55 $(SPHINXBUILD) -b pickle $(ALLSPHINXOPTS) $(BUILDDIR)/pickle
56 @echo
57 @echo "Build finished; now you can process the pickle files."
58
59json:
60 $(SPHINXBUILD) -b json $(ALLSPHINXOPTS) $(BUILDDIR)/json
61 @echo
62 @echo "Build finished; now you can process the JSON files."
63
64htmlhelp:
65 $(SPHINXBUILD) -b htmlhelp $(ALLSPHINXOPTS) $(BUILDDIR)/htmlhelp
66 @echo
67 @echo "Build finished; now you can run HTML Help Workshop with the" \
68 ".hhp project file in $(BUILDDIR)/htmlhelp."
69
70qthelp:
71 $(SPHINXBUILD) -b qthelp $(ALLSPHINXOPTS) $(BUILDDIR)/qthelp
72 @echo
73 @echo "Build finished; now you can run "qcollectiongenerator" with the" \
74 ".qhcp project file in $(BUILDDIR)/qthelp, like this:"
75 @echo "# qcollectiongenerator $(BUILDDIR)/qthelp/PerconaXtraDBCluster.qhcp"
76 @echo "To view the help file:"
77 @echo "# assistant -collectionFile $(BUILDDIR)/qthelp/PerconaXtraDBCluster.qhc"
78
79devhelp:
80 $(SPHINXBUILD) -b devhelp $(ALLSPHINXOPTS) $(BUILDDIR)/devhelp
81 @echo
82 @echo "Build finished."
83 @echo "To view the help file:"
84 @echo "# mkdir -p $$HOME/.local/share/devhelp/PerconaXtraDBCluster"
85 @echo "# ln -s $(BUILDDIR)/devhelp $$HOME/.local/share/devhelp/PerconaXtraDBCluster"
86 @echo "# devhelp"
87
88epub:
89 $(SPHINXBUILD) -b epub $(ALLSPHINXOPTS) $(BUILDDIR)/epub
90 @echo
91 @echo "Build finished. The epub file is in $(BUILDDIR)/epub."
92
93latex:
94 $(SPHINXBUILD) -b latex $(ALLSPHINXOPTS) $(BUILDDIR)/latex
95 @echo
96 @echo "Build finished; the LaTeX files are in $(BUILDDIR)/latex."
97 @echo "Run \`make' in that directory to run these through (pdf)latex" \
98 "(use \`make latexpdf' here to do that automatically)."
99
100latexpdf:
101 $(SPHINXBUILD) -b latex $(ALLSPHINXOPTS) $(BUILDDIR)/latex
102 @echo "Running LaTeX files through pdflatex..."
103 make -C $(BUILDDIR)/latex all-pdf
104 @echo "pdflatex finished; the PDF files are in $(BUILDDIR)/latex."
105
106text:
107 $(SPHINXBUILD) -b text $(ALLSPHINXOPTS) $(BUILDDIR)/text
108 @echo
109 @echo "Build finished. The text files are in $(BUILDDIR)/text."
110
111man:
112 $(SPHINXBUILD) -b man $(ALLSPHINXOPTS) $(BUILDDIR)/man
113 @echo
114 @echo "Build finished. The manual pages are in $(BUILDDIR)/man."
115
116changes:
117 $(SPHINXBUILD) -b changes $(ALLSPHINXOPTS) $(BUILDDIR)/changes
118 @echo
119 @echo "The overview file is in $(BUILDDIR)/changes."
120
121linkcheck:
122 $(SPHINXBUILD) -b linkcheck $(ALLSPHINXOPTS) $(BUILDDIR)/linkcheck
123 @echo
124 @echo "Link check complete; look for any errors in the above output " \
125 "or in $(BUILDDIR)/linkcheck/output.txt."
126
127doctest:
128 $(SPHINXBUILD) -b doctest $(ALLSPHINXOPTS) $(BUILDDIR)/doctest
129 @echo "Testing of doctests in the sources finished, look at the " \
130 "results in $(BUILDDIR)/doctest/output.txt."
0131
=== modified file 'doc/source/faq.rst'
--- doc/source/faq.rst 2012-02-04 01:22:23 +0000
+++ doc/source/faq.rst 2012-02-20 17:18:00 +0000
@@ -14,6 +14,19 @@
14A: When the node crashes, after the restart it will copy whole dataset from another node14A: When the node crashes, after the restart it will copy whole dataset from another node
15(if there were changes to data since crash). 15(if there were changes to data since crash).
1616
17Q: How can I check the Galera node health?
18==========================================
19A: Your check should be simply:
20
21.. code-block:: mysql
22
23 SELECT * FROM someinnodbtable WHERE id=1;
24
253 different results are possible:
26 * You get the row with id=1 (node is healthy)
27 * Unknown error (node is online but Galera is not connected/synced with the cluster)
28 * Connection error (node is not online)
29
17Q: Is there a chance to have different table structure on the nodes? 30Q: Is there a chance to have different table structure on the nodes?
18=====================================================================31=====================================================================
19What I mean is like having 4 nodes, 4 tables like sessions_a, sessions_b, sessions_c and sessions_d and have each only on one of the nodes? 32What I mean is like having 4 nodes, 4 tables like sessions_a, sessions_b, sessions_c and sessions_d and have each only on one of the nodes?
2033
=== modified file 'doc/source/index.rst'
--- doc/source/index.rst 2012-02-04 01:22:23 +0000
+++ doc/source/index.rst 2012-02-20 17:18:00 +0000
@@ -76,6 +76,7 @@
76 76
77 singlebox77 singlebox
78 3nodesec278 3nodesec2
79 kewpietests
79 bugreport80 bugreport
8081
81Percona XtraDB Cluster limitations82Percona XtraDB Cluster limitations
8283
=== added file 'doc/source/kewpietests.rst'
--- doc/source/kewpietests.rst 1970-01-01 00:00:00 +0000
+++ doc/source/kewpietests.rst 2012-02-20 17:18:00 +0000
@@ -0,0 +1,35 @@
1===========================
2How to Execute Kewpie Tests
3===========================
4
5To use kewpie for testing it's recommended to use `this MP <https://code.launchpad.net/~patrick-crews/percona-xtradb-cluster/qp-integrate/+merge/93648>`_. As it removes dbqp and integrates kewpie (and cuts size down to 25MB from 400+).
6To execute tests:
7
8.. code-block:: bash
9
10 cd kewpie ; ./kewpie.py [--force ] [--libeatmydata] [--wsrep-provider-path=...]
11
12The defaults are to run the cluster_basic and cluster_randgen suites against a 3 node cluster. Cluster_basic is used for small atomic tests like ADD/DROP single/multiple columns on a table and ensuring the change is replicated. cluster_randgen is used for high stress transactional loads. There are single and multi-threaded variants. The load is a mix of INSERT/UPDATE/DELETE/SELECT statements. This includes both regular transactions, single queries, ROLLBACK's and SAVEPOINTs, and a mix of good and bad SQL statements.
13
14To view all options, one may look at "./kewpie.py --help". Basic documentation is also available as sphinx docs in kewpie/docs folder. Here are the some of the most used options:
15
16.. option:: --force
17
18 Run all tests despite failures (default is to stop test execution on first failure)
19
20.. option:: --libeatmydata
21
22 Use libeatmydata if installed. This can greatly speed up testing in many cases. Can be used in conjunction with:
23
24.. option:: --libeatmydata-path to specify where the library is located.
25
26.. option:: --wsrep-provider-path
27
28 By default, we expect / look for it in /usr/lib/galera/libgalera_smm.so (where it ends up via 'make install'...at least on Ubuntu). If one has an alternate library/location, specify it with this option.
29
30Any additional suites may be run this way:
31
32.. code-block:: bash
33
34 ./kewpie.py [options] --suite=any/suitedir/from/kewpie/percona_tests
35 ./kewpie.py --suite=crashme

Subscribers

People subscribed via source and target branches