You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by ra...@apache.org on 2018/11/07 12:58:03 UTC
[cloudstack-documentation] branch master updated: CLOUDSTACK-10399:
Added section regarding MySQL server-id (#17)
This is an automated email from the ASF dual-hosted git repository.
rafael pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/cloudstack-documentation.git
The following commit(s) were added to refs/heads/master by this push:
new a96d7d6 CLOUDSTACK-10399: Added section regarding MySQL server-id (#17)
a96d7d6 is described below
commit a96d7d6db68791d72d0d30b2180ddb616d72a299
Author: James McClune <fa...@users.noreply.github.com>
AuthorDate: Wed Nov 7 07:57:58 2018 -0500
CLOUDSTACK-10399: Added section regarding MySQL server-id (#17)
Fixes CLOUDSTACK-10399: Specify MySQL server-id for later versions of CloudStack
Signed-off-by: James McClune <jm...@mcclunetechnologies.net>
---
source/installguide/management-server/_database.rst | 12 ++++++++++++
source/quickinstallationguide/qig.rst | 14 +++++++++++++-
2 files changed, 25 insertions(+), 1 deletion(-)
diff --git a/source/installguide/management-server/_database.rst b/source/installguide/management-server/_database.rst
index 9ec6600..46a9f13 100644
--- a/source/installguide/management-server/_database.rst
+++ b/source/installguide/management-server/_database.rst
@@ -62,6 +62,18 @@ MySQL. See :ref:`install-database-on-separate-node`.
max_connections=350
log-bin=mysql-bin
binlog-format = 'ROW'
+
+ .. note::
+ For Ubuntu 16.04 and later, make sure you specify a ``server-id`` in your ``.cnf`` file for binary logging. Set the ``server-id`` according to your database setup.
+
+ .. parsed-literal::
+
+ server-id=master-01
+ innodb_rollback_on_timeout=1
+ innodb_lock_wait_timeout=600
+ max_connections=350
+ log-bin=mysql-bin
+ binlog-format = 'ROW'
.. note::
You can also create a file ``/etc/mysql/conf.d/cloudstack.cnf``
diff --git a/source/quickinstallationguide/qig.rst b/source/quickinstallationguide/qig.rst
index 0c52592..66141c3 100644
--- a/source/quickinstallationguide/qig.rst
+++ b/source/quickinstallationguide/qig.rst
@@ -369,7 +369,19 @@ section:
innodb_lock_wait_timeout=600
max_connections=350
log-bin=mysql-bin
- binlog-format = 'ROW'
+ binlog-format = 'ROW'
+
+.. note::
+For Ubuntu 16.04 and later, make sure you specify a ``server-id`` in your ``.cnf`` file for binary logging. Set the ``server-id`` according to your database setup.
+
+::
+
+ server-id=master-01
+ innodb_rollback_on_timeout=1
+ innodb_lock_wait_timeout=600
+ max_connections=350
+ log-bin=mysql-bin
+ binlog-format = 'ROW'
Now that MySQL is properly configured we can start it and configure it to
start on boot as follows: