From 072f99a26da5dfba46aa65bbaba96e82333d2f33 Mon Sep 17 00:00:00 2001 From: Thomas Heller Date: Thu, 11 Feb 2016 13:44:50 +0100 Subject: [PATCH] added mysql-replication for red-bmf --- bmas-sgb2-gf-extranet | 1 + .../bmf/db02-red-bmf-de.pixelpark.net.yaml | 34 +++++++++++++++++++ customer/bmf/red-bmf-de.pixelpark.net.yaml | 9 ++++- 3 files changed, 43 insertions(+), 1 deletion(-) create mode 160000 bmas-sgb2-gf-extranet diff --git a/bmas-sgb2-gf-extranet b/bmas-sgb2-gf-extranet new file mode 160000 index 00000000..2bad6a1a --- /dev/null +++ b/bmas-sgb2-gf-extranet @@ -0,0 +1 @@ +Subproject commit 2bad6a1ab04d49dccf7cee252d1b06ff805e7982 diff --git a/customer/bmf/db02-red-bmf-de.pixelpark.net.yaml b/customer/bmf/db02-red-bmf-de.pixelpark.net.yaml index 4c3c2b5e..9aa70d31 100644 --- a/customer/bmf/db02-red-bmf-de.pixelpark.net.yaml +++ b/customer/bmf/db02-red-bmf-de.pixelpark.net.yaml @@ -1,2 +1,36 @@ --- site::role: base +site::additional_classes: + - site::profile::mysql_server + +mysql::server::override_options: + mysqld: + server-id: '2' + auto_increment_increment: '2' + auto_increment_offset: '2' + log-bin: 'log-bin' + binlog-format: 'MIXED' + binlog-ignore-db: 'performance_schema, information_schema' + expire-logs-days: '7' + bind-address: '0.0.0.0' + basedir: '/usr/mysql/5.5' + +mysql::server::root_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAwS6zo6MFyZ2bwUX7jqYK/7bxtEMCjlzPo0qKBTK7BybpZ0bXTP2tHB7lf/tMiZCuIYQXv0jo45IrDIDmjbI3F9l1+pe+9HTUi4Bldm3bgNYJ11hnTj2zvy4OFshQNT+Osgl4xyIeitW2QEicirU2Sxu2j2bPeYCmEcHQQ7+wp5kBTwNOFhFGAPT193utWGRNoM5F6kdyzH30w3ROEUiaHtBJ7guVP/dtOSu/2G6ZTZdbuelY9HIP0HY5Q+wF9ijGX8jcFgH/d5fjF1nC6U0cZ1+kAaATmO0tBhjd6fNNxnS7MwzOcnnjUb+55DCNLfbzGs2QX8jyg3yVMFgLDkvjkDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBKUL10b68L7XHjlvWUyCRggCA+/9M2Vvhr06kb+3DCz+Pa9pE6xzBLP2V7NW4XUlFKKg==] +mysql::server::backup::backuppassword: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAK1sdC25CqwyHe+/hixKmOZnoCbLVd6spYkF+LD1EEK2f4JZDKSs+qtDFfrl/OxixGdlxdA5IH2YCYdSQv1qu2i+uIGRpoSrMGzqIbybhnv26fv57DQnF5gz6GiWL1DuSEs8wOtXGSnFscVqe7zvTP+EwljSfhp2AVVxa5XYfeEeln0/UbBQv93rzoCNhXMWoN0SbPWMzhBuA6OJxiFoXAhwsNe9Uar7+5sJypkhwASxIoqjtdLWIki3jb9lUQ2FqS9FRIEKN4cec04GwWznGf57RGq+rxPK9wQTevNx+3Q7K3J1nj1oejbQrznwsecI9L8ueVZQwChpiNoeZN37JZTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBA11wRusEksu7P8icskSf8bgCDM8YkEhAMJN8Bp+DAElUPJN3kCTE9flIsBsLTs4m4VDQ==] +site::profile::mysql_server::databases: + CMCONTENT: + user: CMCONTENT + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAxF7B0gnNCjykLFCQGOtcyfMaXWzwMXnAOazEeK0PFf7SxgwKY2dqFFWTsExfm/TqXhXazfiuIVN9e6FdqaFNj30lrtOhnVl76tFvAUzL6Pq5CsjVHLDKDDbMqTU6WKWv0VlXdvttLrQSFxLypOWdrAGVpYssKzp9OpvSIp/Zsr5zB4dZerWFeo8sUNtNWttBv7Xvx8sAypWFykm4qapQlwAclHycoB6QAoGOFrVCL5zj+bWUTO8iV60R2Hu1kR0Vv20YZmk8oQBfnDXSj56ecpxZMv/VuYL8sxbKykfkmZnMGleMlnRtIynMRk8Z9YEt8KWLdoGCnXwO8qbhUkIJUzBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBDXv54RMcJWlU44oPuechxjgCD+8MNKTOLGn6UOIkGkNv91T/C3vyujF4XTF6ZwpqnmdA==] + host: '%' + CMTOMCATCONTENT: + user: CMTOMCATCONTENT + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAaG7+kd+SFCj9sIFDJ7nehF+L2Q21CQfAnMrzEBoL6I4kC38XV4/pBuHaGWXd9RR6MVRCT3fgQ20Wec59z+jyJi6vMv7xytNR9B5/6U7VtWgj7xnnjUeHiR5eesL/WFMQfdV664umBNuod8d6ccSN5dhrx16MOn+bFk09+ZBHxVRR6Xtals5Li13pqLiQs0XA3dO+RAXOCAJYyhJ74trttTsKyXL9KvamqnhUO94IL2KlItQU7uu2OMN3gaC6KoGo/r7MSrX9il2prZMf09i0Ev4E0tDxq98x5Hyy1keaaeR37IvOO2omn08lJey71nWopjmW6SGr2gkpMB/0tK/vRTBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBCjO4+uPZZJNxdr8a2PJ51ogCCfxaDWmZSBxKaqc0HECNNFsC2jsvy7zIUPHgs3L+PUVA==] + host: '%' + MAILDISTRIBUTOR: + user: MAILDISTRIBUTOR + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAcP5oogzWRBV8tqm+LDMCvE6QnJ6z5UD4oQTJ+qVEogUgPgETj4xB3qHIvKd1DnS+U3cXYJQunX1PE09tUNMcdiVLKgYf4UN4RF+s3e/F2O2O/3vJTno36bDS0fICn2x5XfDWuMm4gMLFfWufds2gduVwLuX6cw2t688+3w+ISi9ksRobALXZbMIb6A99PfKCSuxTGhpw19SC7xeY64W4091edxTzxF3S7IJokApkdBbd9/ejCMAAAgEyahFOhz77kbo9W+npl8ZoRwTFiKhzMqM/AMVFTlbayz+8Hc5KYOH/QeBQQ2djIfXeqVWNxP1A4dbIN4qjxPD0FKQZB/6y0jBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBC4WZ0UpotryLHtalVBG4B3gCCUWwdC7W73X88UmeB1wmRuXQaXKFweJ3zdyVm0PmEFjQ==] + host: '%' + ADMINPORTAL: + user: ADMINPORTAL + password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAbTtG45jkeFkJryAtue0ZUTX8vP5dIkump0H2KSvm9JAbaiyfiGaVJd3tUAPAWQNDcC2tK32RZqEMWF/4hDlA3f4JEc8NXBfz6dIgtLsCghCDUuTTV67iQ39sBimLHHSkB018JT4FzKnsA6nvroPaGGMvB6MxWciViqUP0sgIzScSJbyYmpFnCmWffEwwaMpHL199PixeMXmPXl+0p9K5CPZ82asnpNs/IhvzA2iszNoQlk/2E2bsX9fJ0Rdn6qGV1yyEivBARuHRigwirXZtoN6ZNWlX8fQ0WOzAyrBzVEW4pW2+8XXxCJSQUtd/fFiF7dTO71ajfxrjJFe0nleXxjBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBAHoOjDRRSrRdkKP4BZWtgbgCB6bcXTs6mbVxguPs00nJhdWsOzidHBw2skcqo7shTBVw==] + host: '%' diff --git a/customer/bmf/red-bmf-de.pixelpark.net.yaml b/customer/bmf/red-bmf-de.pixelpark.net.yaml index 103ecfd3..efcb225b 100644 --- a/customer/bmf/red-bmf-de.pixelpark.net.yaml +++ b/customer/bmf/red-bmf-de.pixelpark.net.yaml @@ -5,7 +5,14 @@ site::additional_classes: mysql::server::override_options: mysqld: - bind-address: 0.0.0.0 + server-id: '1' + auto_increment_increment: '2' + auto_increment_offset: '1' + log-bin: 'log-bin' + binlog-format: 'MIXED' + binlog-ignore-db: 'performance_schema, information_schema' + expire-logs-days: '7' + bind-address: '0.0.0.0' basedir: '/usr/mysql/5.5' mysql::server::root_password: ENC[PKCS7,MIIBiQYJKoZIhvcNAQcDoIIBejCCAXYCAQAxggEhMIIBHQIBADAFMAACAQEwDQYJKoZIhvcNAQEBBQAEggEAwS6zo6MFyZ2bwUX7jqYK/7bxtEMCjlzPo0qKBTK7BybpZ0bXTP2tHB7lf/tMiZCuIYQXv0jo45IrDIDmjbI3F9l1+pe+9HTUi4Bldm3bgNYJ11hnTj2zvy4OFshQNT+Osgl4xyIeitW2QEicirU2Sxu2j2bPeYCmEcHQQ7+wp5kBTwNOFhFGAPT193utWGRNoM5F6kdyzH30w3ROEUiaHtBJ7guVP/dtOSu/2G6ZTZdbuelY9HIP0HY5Q+wF9ijGX8jcFgH/d5fjF1nC6U0cZ1+kAaATmO0tBhjd6fNNxnS7MwzOcnnjUb+55DCNLfbzGs2QX8jyg3yVMFgLDkvjkDBMBgkqhkiG9w0BBwEwHQYJYIZIAWUDBAEqBBBKUL10b68L7XHjlvWUyCRggCA+/9M2Vvhr06kb+3DCz+Pa9pE6xzBLP2V7NW4XUlFKKg==] -- 2.39.5