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 <falcon78...@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 <jmccl...@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: