← Back to branch summary

~akopytov/percona-xtrabackup/xtrabackup-1.6-copy-diagnostics

« back to all changes in this revision

Viewing changes to doc/source/intro.rst

  • Committer: Hrvoje Matijakovic
  • Date: 2012-02-16 17:05:16 UTC
  • Revision ID: hrvoje.matijakovic@percona.com-20120216170516-s3b0nk7x6av63b7t
imported the sphinx docs from the current trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/source/intro.rst
 
1
==========================
 
2
 About Percona Xtrabackup
 
3
==========================
 
4
 
 
5
 
 
6
*Percona XtraBackup* is the world's only open-source, free |MySQL| hot backup software that performs non-blocking backups for |InnoDB| and |XtraDB| databases. With *Percona XtraBackup*, you can achieve the following benefits:
 
7
 
 
8
* Backups that complete quickly and reliably
 
9
 
 
10
* Uninterrupted transaction processing during backups
 
11
 
 
12
* Savings on disk space and network bandwidth
 
13
 
 
14
* Automatic backup verification
 
15
 
 
16
* Higher uptime due to faster restore time
 
17
 
 
18
|XtraBackup| makes |MySQL| hot backups for all versions of |Percona Server|, |MySQL|, |MariaDB|, and |Drizzle|. It performs streaming, compressed, and incremental |MySQL| backups.
 
19
 
 
20
|Percona| |XtraBackup| works with |MySQL|, |MariaDB|, *OurDelta*, |Percona Server|, and |Drizzle| databases (support for |Drizzle| is beta). It supports completely non-blocking backups of |InnoDB|, |XtraDB|, and *HailDB* storage engines. In addition, it can back up the following storage engines by briefly pausing writes at the end of the backup: |MyISAM|, :term:`Merge <.MRG>`, and :term:`Archive <.ARM>`, including partitioned tables, triggers, and database options.
 
21
 
 
22
|Percona|'s enterprise-grade commercial `MySQL Support <http://www.percona.com/mysql-support/>`_ contracts include support for XtraBackup. We recommend support for critical production deployments.
 
23
 
 
24
MySQL Backup Tool Feature Comparison
 
25
====================================
 
26
 
 
27
.. raw:: html
 
28
 
 
29
   <table class="datatable" style="text-align: center;">
 
30
   <tbody style="text-align: center;"><tr><th class="label">Feature</th><th>Percona XtraBackup</th><th>MySQL Enterprise Backup<br>(InnoDB Hot Backup)</th></tr>
 
31
   <tr><td class="label">License</td><td style="text-align: center;">GPL</td><td style="text-align: center;">Proprietary</td></tr>
 
32
   <tr><td class="label">Price</td><td style="text-align: center;">Free</td><td style="text-align: center;"><a href="http://www.mysql.com/products/">$5000 per server</a></td></tr>
 
33
   <tr><td class="label">Open source</td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td></td></tr>
 
34
   <tr><td class="label">Non-blocking</td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td></tr>
 
35
   <tr><td class="label">InnoDB backups</td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td></tr>
 
36
   <tr><td class="label">MyISAM backups <sup><a href="#note-1">1</a></sup></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td></tr>
 
37
   <tr><td class="label">Compressed backups</td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td></tr>
 
38
   <tr><td class="label">Partial backups</td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td></tr>
 
39
   <tr><td class="label">Throttling <sup><a href="#note-2">2</a></sup></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td></tr>
 
40
   <tr><td class="label">Point-in-time recovery support</td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td></tr>
 
41
   <tr><td class="label">Incremental backups</td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td></tr>
 
42
   <tr><td class="label">Parallel backups</sup></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td></td></tr>
 
43
   <tr><td class="label">Streaming backups</td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td></td></tr>
 
44
   <tr><td class="label">OS buffer optimizations <sup><a href="#note-3">3</a></sup></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td></td></tr>
 
45
   <tr><td class="label">Export individual tables</td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td></td></tr>
 
46
   <tr><td class="label">Restore tables to a different server</td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td></td></tr>
 
47
   <tr><td class="label">Analyze data &amp; index files</td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td></td></tr>
 
48
   <tr><td class="label">Familiar command-line behavior <sup><a href="#note-4">4</a></sup></td><td style="text-align: center;"><img width="24" height="24" alt="Yes" src="http://s0.percona.com/check-yes.png"></td><td></td></tr>
 
49
   </tbody></table>
 
50
 
 
51
 
 
52
.. .. tabularcolumns:: |l|c|c|
 
53
 
 
54
 
 
55
.. .. list-table:: MySQL Backup Tool Feature Comparison
 
56
..    :header-rows: 1
 
57
 
 
58
..    * - Feature       
 
59
..      - Percona XtraBackup
 
60
..      - MySQL Enterprise Backup (InnoDB Hot Backup)
 
61
..    * - License
 
62
..      - GPL
 
63
..      - Proprietary
 
64
..    * - Price
 
65
..      - Free
 
66
..      - $5000 per server 
 
67
..    * - Open source
 
68
..      - |yes|
 
69
..      - 
 
70
..    * - Non-blocking
 
71
..      - |yes|
 
72
..      - |yes|
 
73
..    * - InnoDB backups
 
74
..      - |yes|
 
75
..      - |yes|
 
76
..    * - MyISAM backups [#f1]_
 
77
..      - |yes|
 
78
..      - |yes|
 
79
..    * - Compressed backups
 
80
..      - |yes|
 
81
..      - |yes|
 
82
..    * - Partial backups
 
83
..      - |yes|
 
84
..      - |yes|
 
85
..    * - Throttling [#f2]_
 
86
..      - |yes|
 
87
..      - |yes|
 
88
..    * - Point-in-time recovery support
 
89
..      - |yes|
 
90
..      - |yes|
 
91
..    * - Incremental backups
 
92
..      - |yes|
 
93
..      - |yes|
 
94
..    * - Parallel backups [#f3]_
 
95
..      -  |yes|
 
96
..      -
 
97
..    * - Streaming backups
 
98
..      - |yes| 
 
99
..      -
 
100
..    * - OS buffer optimizations [#f4]_
 
101
..      - |yes| 
 
102
..      -
 
103
..    * - Export individual tables
 
104
..      - |yes| 
 
105
..      -
 
106
..    * - Restore tables to a different server
 
107
..      - |yes|
 
108
..      -       
 
109
..    * - Analyze data & index files
 
110
..      - |yes|
 
111
..      -       
 
112
..    * - Familiar command-line behavior [#f5]_
 
113
..      - |yes| 
 
114
..      -
 
115
 
 
116
.. .. |yes| image:: check-yes.png
 
117
 
 
118
..  License                                   GPL                        Proprietary
 
119
..  Price                                             Free                  $5000 per server 
 
120
..  Open source                               Yes       
 
121
..  Non-blocking                                      Yes                        Yes
 
122
..  InnoDB backups                                    Yes                        Yes
 
123
..  MyISAM backups [#f1]_                             Yes                        Yes
 
124
..  Compressed backups                        Yes                        Yes
 
125
..  Partial backups                              Yes                     Yes
 
126
..  Throttling [#f2]_                            Yes                     Yes
 
127
..  Point-in-time recovery support                    Yes                        Yes
 
128
..  Incremental backups                       Yes                        Yes
 
129
..  Parallel backups [#f3]_                   Yes       
 
130
..  Streaming backups                         Yes       
 
131
..  OS buffer optimizations [#f4]_               Yes    
 
132
..  Export individual tables                     Yes    
 
133
..  Restore tables to a different server         Yes    
 
134
..  Analyze data & index files                   Yes    
 
135
..  Familiar command-line behavior [#f5]_        Yes    
 
136
.. ========================================   ===================   =========================
 
137
 
 
138
The above comparison is based on XtraBackup version 1.4 and MySQL Enterprise Backup version 3.5 on December 7, 2010. 
 
139
 
 
140
 
 
141
What are the features of Percona XtraBackup?
 
142
============================================
 
143
 
 
144
Here is a short list of |XtraBackup| features. See the documentation for more.
 
145
 
 
146
* Ceate hot |InnoDB| backups without pausing your database
 
147
* Make incremental backups of |MySQL|
 
148
* Stream compressed |MySQL| backups to another server
 
149
* Move tables between |MySQL| servers online
 
150
* Create new |MySQL| replication slaves easily
 
151
* Backup |MySQL| without adding load to the server
 
152
 
 
153
 
 
154
 
 
155
.. rubric:: Footnotes
 
156
 
 
157
.. [#note-1] |MyISAM| backups require a table lock.
 
158
 
 
159
.. [#note-2] |XtraBackup| performs throttling based on the number of IO operations per second. *MySQL Enterprise Backup* supports a configurable sleep time between operations.
 
160
 
 
161
.. [#note-3] |XtraBackup| tunes the operating system buffers to avoid swapping. See the documentation.
 
162
 
 
163
.. [#note-4] |XtraBackup| is linked against the |MySQL| client libraries, so it behaves the same as standard |MySQL| command-line programs. *MySQL Enterprise Backup* has its own command-line and configuration-file behaviors.
 
164
 
 
165