comparison Sphinx/source/users/backup.rst @ 154:365427cebb64

mysql
author Sebastien Jodogne <s.jodogne@gmail.com>
date Tue, 10 Jul 2018 14:45:40 +0200
parents 669ea65ba7fb
children e3751a4caa2f
comparison
equal deleted inserted replaced
153:008091376e7a 154:365427cebb64
36 command-line tool is used to force the `WAL replay 36 command-line tool is used to force the `WAL replay
37 <http://www.sqlite.org/wal.html>`__. This manual replay should not be 37 <http://www.sqlite.org/wal.html>`__. This manual replay should not be
38 necessary for Orthanc >= 0.7.3. 38 necessary for Orthanc >= 0.7.3.
39 39
40 40
41 PostgreSQL 41 PostgreSQL and MySQL
42 ---------- 42 --------------------
43 43
44 The default SQLite engine is well adapted for DICOM routing or for 44 The default SQLite engine is well adapted for DICOM routing or for
45 image buffering tasks, but not for enterprise scenarios. In such 45 image buffering tasks, but not for enterprise scenarios. In such
46 cases, you are highly recommended to use the `PostgreSQL back-end 46 cases, you are highly recommended to use the `PostgreSQL back-end
47 <http://www.orthanc-server.com/static.php?page=postgresql>`__. 47 <http://www.orthanc-server.com/static.php?page=postgresql>`__ or the
48 `MySQL/MariaDB back-end
49 <http://www.orthanc-server.com/static.php?page=mysql>`__.
48 50
49 If using PostgreSQL, you can do hot backups (i.e. while Orthanc is 51 If using PostgreSQL, you can do hot backups (i.e. while Orthanc is
50 running), and you benefit from all the flexibility of PostgreSQL 52 running), and you benefit from all the flexibility of PostgreSQL
51 backup. These procedures are out of the scope of this manual. Please 53 backup. These procedures are out of the scope of this manual. Please
52 check the `official backup and restore manual 54 check the `official backup and restore manual
53 <https://www.postgresql.org/docs/devel/static/backup.html>`__. 55 <https://www.postgresql.org/docs/devel/static/backup.html>`__.
56
57 Similar backup procedures are available for MySQL and MariaDB as
58 well. Please check the official manual about `database backup methods
59 <https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html>`__.