commit e911096ff65ca487b117c4eb4dd3696a3da44d12
parent e47a28cdec6cb7c26ea75bd7679762f47e6a79cf
Author: Martin Schanzenbach <schanzen@gnunet.org>
Date: Sun, 24 Sep 2023 11:14:31 +0200
phase out mysql
Diffstat:
1 file changed, 1 insertion(+), 136 deletions(-)
diff --git a/users/configuration.rst b/users/configuration.rst
@@ -610,144 +610,9 @@ are willing to dedicate to GNUnet.
In addition to specifying the maximum space GNUnet is allowed to use for
the datastore, you need to specify which database GNUnet should use to
-do so. Currently, you have the choice between sqLite, MySQL and
+do so. Currently, you have the choice between sqlite and
Postgres.
-.. _Configuring-the-MySQL-database:
-
-Configuring the MySQL database
-~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-
-This section describes how to setup the MySQL database for GNUnet.
-
-Note that the mysql plugin does NOT work with mysql before 4.1 since we
-need prepared statements. We are generally testing the code against
-MySQL 5.1 at this point.
-
-.. _Reasons-for-using-MySQL:
-
-Reasons for using MySQL
-~~~~~~~~~~~~~~~~~~~~~~~
-
-- On up-to-date hardware where mysql can be used comfortably, this
- module will have better performance than the other database choices
- (according to our tests).
-
-- Its often possible to recover the mysql database from internal
- inconsistencies. Some of the other databases do not support repair.
-
-.. _Reasons-for-not-using-MySQL:
-
-Reasons for not using MySQL
-~~~~~~~~~~~~~~~~~~~~~~~~~~~
-
-- Memory usage (likely not an issue if you have more than 1 GB)
-
-- Complex manual setup
-
-.. _Setup-Instructions:
-
-Setup Instructions
-~~~~~~~~~~~~~~~~~~
-
-- In ``gnunet.conf`` set in section ``DATASTORE`` the value for
- ``DATABASE`` to ``mysql``.
-
-- Access mysql as root:
-
- .. code-block:: shell
-
- $ mysql -u root -p
-
- and issue the following commands, replacing ``$USER`` with the username
- that will be running ``gnunet-arm`` (so typically \"gnunet\"):
-
- .. code-block:: mysql
-
- CREATE DATABASE gnunet;
- GRANT select,insert,update,delete,create,alter,drop,create temporary tables ON gnunet.* TO $USER@localhost;
- SET PASSWORD FOR $USER@localhost=PASSWORD('$the_password_you_like');
- FLUSH PRIVILEGES;
-
-- In the $HOME directory of $USER, create a ``.my.cnf`` file with the
- following lines
-
- .. code-block:: text
-
- [client]
- user=$USER
- password=$the_password_you_like
-
-That's it. Note that ``.my.cnf`` file is a slight security risk unless
-its on a safe partition. The ``$HOME/.my.cnf`` can of course be a
-symbolic link. Luckily $USER has only privileges to mess up GNUnet's
-tables, which should be pretty harmless.
-
-.. _Testing:
-
-Testing
-~~~~~~~
-
-You should briefly try if the database connection works. First, login as
-$USER. Then use:
-
-.. code-block:: text
-
- $ mysql -u $USER
- mysql> use gnunet;
-
-If you get the message
-
-.. code-block:: text
-
- Database changed
-
-it probably works.
-
-If you get
-
-.. code-block:: none
-
- ERROR 2002: Can't connect to local MySQL server
- through socket '/tmp/mysql.sock' (2)
-
-it may be resolvable by
-
-.. code-block:: text
-
- ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock
-
-so there may be some additional trouble depending on your mysql setup.
-
-.. _Performance-Tuning:
-
-Performance Tuning
-~~~~~~~~~~~~~~~~~~
-
-For GNUnet, you probably want to set the option
-
-.. todo:: Code block not C, set appropriate language
-
-.. code-block:: text
-
- innodb_flush_log_at_trx_commit = 0
-
-for a rather dramatic boost in MySQL performance. However, this reduces
-the \"safety\" of your database as with this options you may loose
-transactions during a power outage. While this is totally harmless for
-GNUnet, the option applies to all applications using MySQL. So you
-should set it if (and only if) GNUnet is the only application on your
-system using MySQL.
-
-.. _Setup-for-running-Testcases:
-
-Setup for running Testcases
-~~~~~~~~~~~~~~~~~~~~~~~~~~~
-
-If you want to run the testcases, you must create a second database
-\"gnunetcheck\" with the same username and password. This database will
-then be used for testing (``make check``).
-
.. _Configuring-the-Postgres-database:
Configuring the Postgres database
