earl86 发表于 2024-11-15 17:05:55

GreatSQL-8.0.32-26 单机多实例场景 vip 功能不能切换问题

本帖最后由 earl86 于 2024-11-19 13:55 编辑

集群,节点1,2,3 代表3台物理服务器.

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABpkAAACPCAIAAACOBCQoAAAgAElEQVR4Ae2dX5q7rg7GZ11dUNfT1XQz3v8uzxbmPAmiEMI/C0749p2bKmISPgmpZKz+/C/527btF38TCPz3338TpELk2gQQFWv7b471iIo5XH8BdhJYiAWBpQkgMyztPhgPAiBgkADyqkGnwKRFCRRm009SyvsfanmT3FxwwySNEGufAKLCvo/utxBRMYk5wE4CC7EgsDQBZIal3QfjQQAEDBJAXjXoFJi0KIHCbEIt7z6fFtxwnxHQZIwAosKYQ0yYg6iY5AaAnQQWYkFgaQLIDEu7D8aDAAgYJIC8atApMGlRAoXZhFrefT4tuOE+I6DJGAFEhTGHmDAHUTHJDQA7CSzEgsDSBJAZlnYfjAcBEDBIAHnVoFNg0qIECrPJdi3v/Xw83/vT+96v1/uzJ/n5Hw9v77cX6hy6vZ6HmoqL38/nKz65ckJwuOAG6mVvsIHt2JxFoBIVs9QuJff9uj7rlhroYWwlKv46V/hUetgrN8x6rAL29/fXfRtEz4ylpmtpf3s9HhdPlUixDwIgMI8AMsM8tpAMAiDwnQSQV7/T7xj1DAKF2WS6lvd+/vycxbxf2v15vuuEtvfrmf49fn5+Hi9eo4VLYa6iRXoKCtiEwKRC1/RQwQ2pEQYGm44ALeMJlKNivL6JEntL7WIa5i3bJ0NUX8n3/heOlKOCeARZ6A9yBdWoXC71tLd3+A+R95MM3I9t7w//C+N1DPgsgyUF2+tBXzNRsBHhZzzeNltImADVdiJ6gQAI3EkAmeFO2tAFAiDwDQSQV7/ByxjjPQQKs8lwLU9ZBtEKUa6oaKGYYnRlBRLhV5Thtl+vufM0qanEc5WnH6sXMgpuYIPE0DSzbhysOko0DidQiorhyqYKpIB9pDX0bMvjwRWpBpu4lOIrQw391+9SigobiTHxSdQQJS86IpLb7qHq/X3DPVkC65QpeOnfSOEAmovQWl53WuS94cMHCoEgAAIdBJAZOmChKwiAAAg0EEBebYCELiDQRKAwm+zW8ngBWC8N0N12R71O0gjrd+G2u/liX53xwkyeqe2TRT8Zi/imP3Ezh5RRcIO9wUrjsT+JQBwV27bRDU6yYD1JdyKW1b8uqo9nWCI7aWjvT9PD1+RDMf9uQSSOinDMfHtyQ810emIU9S2y6/RRdDC9ic8PiEIgk1HjEvBD3gboJfR+xmDVO7hdLo/0u7Lz3sRkC986kUmc2SNZtONEnLiiU9x/jfIHZWfsgwAIfEzAeGbY3nvWoIvQ4Kbsj8cNASAAAiAwi4DtvEpp1V/Q4Wkos2IAckcRiGdTJNVqLY/rZmI5077290MMz3Dbx40g22uvvNFPw7i/fs+bF8VLaGGQP0aik59l+YPnZ9YN9gZ7Gp1uudGGt6mkfdDSTCCMiu3lrteb4Y71hf9aa1YfD9LNsLittNfenwsiSc3HfQVfNLZkmIFjYVRE5hjKFXsu9Sn1ci2voXDNAdDQL0Kl7iRgk/upKSxlUEWlSVVurrHrTHou33O/tsx81+T0oB0EQOATApYzA+W/8z/FG38JyBz1ydhxLgiAAAjMIGA4r7pLvf13fdt7X8bPgACZIDCEQDKbTqk2a3l8rZLciqOs/f068hyQe3a5vxGCfsXnawBn9d0f5c/H3oEPZxdQhSUZmZUs/kKD/HbGDfYG6w3WP3m8TQPWz0drREBGhft+UX42Hp2174z3RZf62CQ6VUwguudVlmCONqV/LPDYc0uZY/cLNmRU7EP++1wh72TzaZNvGzlyLdejfOKl29AyC8/WaCuk385gyIANpGg2XQ/ALss3ei3T2xX0xUwKDMQmCIDAcAJ2M4OSffiLAClieBBAIAiAwFACtvNqfGFKaTVuGYoCwkDgQwKF2WSwlud+kcUrqnM16MpuQWXON6hTz1dCwmpBuP3rOmirNg01WUSmaK8y5IuqtumvucHeYDUAaJtHQEZFa1BOsugD9X6GvV++fOe/Gs8Wel2z/3mi718fCZ3zXQsXGRXEyEquiO5kO3Y2etG47sr8e8Jbo62rIqYbsbdqYOMTGLMYCb2W13+pxL1re1csJypfFu81jDgOApMJmM0MajrwX62ToUA8CIAACHxAwGxedUuRaO3OqTZq+WDgOBUEhhMozCZrtTxa9vGqiWaVWL5rTcdSUoUWLqS0s5VfUyVy6HePzhCuQkQTnR9hErUkpwcNiRvsDTawFpv3EJBRQXHaHFLjTfxA/TnD9if+BSW4zRdDAvln/9owAkFpV64Upc1rt8io+DWUK8KboduXlJv6iqLGYA8T+WeOTcB2igsH33KqZnn5S+t4k26LePQBARAYQsBsZqDvyeR2kfbEOwQOhIAACIDABQJm8+rvL/0OIvoXLadaUXa4MGScAgKTCBRmU0str3f5cnkUdGuHn1q85q/cl8cPrSzMvKhYEO04E1nHrlEf5LGCPk/wFUb3LOKeqkvsBnuDbfZbkgKbz0THhEAcFdFbWZK+SsNoX4RzQlFXagpnGP2Q9hm9/HN7UUk87BNus1z5+83jt/D86gGRDPzB/afzhTRQstnqsTgqjOWK93GT2h4tWcd5J7lnwKU+2s+vekGriFVPUjvEYF0XyvKNf/tPiv23VKqCLA0jNXprhlNSfX0zUfFfM6kGtIAACIwnYDgz0E/v45SDFDE+ACARBEBgOAHDeTUZa/GmgaQ3GkDgbgLabNptqNTyKLbpX4Lv/SVavBw/t6PrC3p25L6wpuXM6xUu4PbV3uNx3HR0vJcrfaIW2UYXK2LtpzTpJI+lZfi4PHqrgBN4Lt34/528wNrXaJG89AqKzOIfkvGlVO/tU3k3KCNTmiLjjp2PB+vGQn72gPYfQjrXnz7mjuTBoONhBqEhkvSKtd/Dt/TeX3EVGpyBzd/fXxkVRJkqxOTXfTopM6Tmizc5g31BfsnLoZl2viDv8XzTA2B7CtSBD8mmc8qmX4tscyA87u8E6bcs8SP2viqOZFScmBVqStPZP9z6OFfsTuKyLG2fNbbQcWRPWwy19jz1hMO5sp0BG5rPYtPwpWayN4hxxQD9vLAjjeWcJuERv13X4nviEwRAYAyBFTKDH2lr3vT98QkCIAACf0FglbxK6yBlpfUXyKATBDIEMrOJeldqefvqZQ9xvoIIt4+76Fz15+EfKOdeCfPk53jvS3B+qvf7tT9bku93oyO8bNHWfXRArHiUJi5FnNWmYPy77FMEq/Rd3SePJxhDcHph09U+Kssx7fy8G5SRKU0TB0vaBG5+LaXnFQ1HN41uWCb3Uh33KOC5QND8G0n85h0ZFUT38aKfmh8zh5yTYZjxxe/mqu9U0POC/KSMYLPjg3nLZb+MruhEZSeyhQVLq6nQcQqP+ivyzqb4vLP9392SUXGOVKGmNE3MFa6Ex4nVPcHvtG3fej9PJycHowayvKXv9FpeZBXt6DU5slfkSXGmfl7YqT6WupZQHrZBAAQ+J5BPubFsfYbX56x+Xii7nhlc79asGcrGNgiAAAjcT8B+XuXc7e5ZUhe89zODRhDQCRRmU1Mtz6+2omuI+MIj3tvvYDgLaYdd3O/1DI8kt0RwZ9YV/liJyhLy3RfcFJYHDj15C4Iu0XiC9szmtm1HHU+b8/pATmF5N/z9YBMU78hH5yDKYOl61UfLfg5JLi9/I+FftyOjgnkJYArWgG44mQJ86UmJkxXfJH0CiZVNOtXb4l4gEFdqWDTd1rl3CvuXRe9D0SZd+cRlj8qoOAfiKMY/Cb07MZI/yIlB0Y4c7o3yrwb3+3vqVv5rwoNR2s/huq3k60V2aN7Pg41F+CHGrWSvD9/4iN/Tz/NH6bM+lrqWUB62QQAEPiewQmagUWb+gfI5AEgAARAAgcEElsmr++K+4XJ0MCGIA4FWAoXZNKiWl67JqMUv7AM791V50JLZTM/f3v5OpcwpcTMviM71pasExvNUWP1+i7cXRgLdTKfqfbBEDTfph4zFH5Tm3WBgsIzrdFihlKf9/NmT0layQrLvik9HQEaFCErXKTtt0sg5uKa+kKI1z8g+h7j6RmAL/Sj2Le663dvILJcZgv4V4W4oNAMf7uf7//zvbWVUnIBSavcnxj20jhea7AX+vYrPd/SSwcdGNqiyB87x8la9/iVOyO7mwcanpLOHjpO92tfaea5+3nkctbyQBbZBwAqBFTIDCnlWogV2gAAItBBYIq/6gdDlm7gZxR/CJwj8PYHCbBpUy+MVCj1Xb791JrvmaV+UbW9xn5tbJen35qRlOOrtiwbsATLp+T6eGMVVOCq/+dIcPwcuM42POt5Z7Eq8Wl/EFdxgYbDBANx7CpIh7g2OpHo0kHEep8YM2LPT127JqCC6Ca0swi5fSNGaVNmnwy+nLUcl+JR2hhS18QjP/jUlYVidzxE8fj1cO33B4zIqgiFYyBXuTUGHm8m6M7MfJbxjI+vpMz6CASqbp3DlYFdTAWwkJwy58wDHbuFLYP8e9N8p4b96ju3zkbGn3HirriXujz0QAIFPCdjPDLgj71Mf43wQAIF7CdjPqyEPbU0UHsc2CPwlgcJsGlbL40fsH+++yL7yoLgoiwttx+LHb1AJwG9Hn2kZ7viJ37nuOteTRzmwYSXJv6qldwhspdvRyLn64i90e+wGe4M90ljw07nQfr99kvQtx6cGgVemSXXqOOXbN+KocLf+JLQO10haXb6Q8a5JlX2kwsK+t2V/Pwz33N/ASg+rPG56pX50c5PvXxC5H0rC6izonWLrYhbqEUeFvVxBKN8v/t8IvWXl9d7OzH6U8I6NrKfpQBLsiptO4crBrqYYbP7UJOS4qw/d3vPC/rrksEddS9gb2yAAAp8TMJ4Z6P/J/+iX3ee+gwQQAAGbBAzn1W2T7wdv+OWFTcqw6jsIFGbTqFreedtNGWl1UXYU2gI59Nu6175YpEKB1ifoTo9xoqueeAUZ73F3asquJN36+XXeHagIiJVWfn2VvLH091cbyJ8M1g3E1XborQnxb5HDYdaflycvOIlb+XdpQv537crJqQal84wSLoWgTGsGUrTmGdmnwxnOFvrFpzgp/C0mH3K/lnf9RV91Nx0KdXN3y8pwUwUs1yijwlKu4Jfc7A8vPdPjmdmPEt6xkfU0Hcj8g0b+t6ack5odnILVTw1Cjt9nTg9LbfmNLV0dKvNUV5JpZSr/ZlxnRoxmEPhrAqYzg7sqjBGF/zOLj2APBEAABEwQMJtX+TJLFgDoug+rVROBAyMUAoXZNLCWR2uy1+tNa5n8auZc8Sl2ak3by78V9Tj1fb7jUzvj/dqLCfEKMt7jE6kps0RUhqAICNUHi7+wOdguuGHv9UeDPWzkRFb9QWwBhAIByfHAq27IqNCCkhjqgdrli0Q0NYgvrrwq1fqwMWeLMpf4tFz/UKbbVsJq75STncpYq0VGRWr9H+UKns5827WoWB3p+XxMXlstTw/seMD5AIj71ffqYJ2MWON5H2huIrqzzv/znlt0RDzSMLpNNbVZmZZpJ7SAAAgMJGA4M6i35CX/IRvIAqJAAARAYAQBs3mVL7PE1Sdf3uLfqCP8DhkzCBRm06haHq1W+EUTD/rjR9XRDRfyDp3gqUoNA+Xl6nGL2LlY5Dty6k/LimsF8R5rpyYxlwtWKQLC3vHiLzzitwtu4Lvdno/nXw+2KZUVQPD5p2coKPBvDu9//VNGBQel+1W3O4FuSM2GacUX8QRk0UeIsfTd4a4uwxUL94N1+tWkbm++tWCLelJ7f7IyHooq8B9qlFERD+1PE2OmfHqm56OEd2xkPa1EZDzSfY8Xs90BqYkqgz3P0EKObo4pvt0ofIAgv9j3/P4TN9Zkiez3PXPWHDLgc0jYAgEQyBKwmhlcjnzHfy+6L/q7vhKzjsMBEAABswSs5tX9uVjBQ/55taoULcyihWFfR6Awmyq1PF7q7++QULf3Upj2j0OuQfjLjePkvcwXv5ci8Qg9pk7efXcuFrk7rWf51RWv3K+a+CLofMJeevHTupJ05glx0W/Ank96xWbl4irnBkuDLf1WmgDIP+/f3YNuBXy8KoTKuXHtKPH01zfIqNj/3b6HN/HW6gcVXwTTzRerlSYf1zyRdkVcgqDba/sLCc757Q5t79/es1277Z4yKry1lnKFt8l9nun5KOHxA/XoKEWryBTuJL5BrT/SYs1dezmwUsiFkDsJsDCeoueoadfPRTpOCsJ93yYyrOwi7cQ+CIDACAJWM4P2Ve+SxJlcRowfMkAABEBgNAGreZXHGf7g4qfyn9rRYCAPBLoJFGZTpZbXqEqsYvxZmWZ/WP+k2aU+E09bXVHVyBWYzpvBDrHxCjLe405yeXWcqW4oAsJ+mnnh8V/leXl0N6PNwcaWN+/VITSL+paOhcm5GIJW5wffn42VilbJiwErmKtEhe1cEeTS4BkL7Gp3o7aRhacCVnVDb8i9+QGC0T8uAiSkgiSG8U77eoVTNQiNIAACEwkgM0yEC9EgAAJfSQB59SvdjkFPIVCYTWNqebRqEbcPuZ9X9i3g6KWX+fuB3i/tBiUGpv/sSzykKEVLd4VEq6+0S9BS0E+9irazmNgNtgcbjLtns3cF3CP7H+0bR8XKg+z7IWRP756+KxM8bY+jYoFcUTCR38DYnmdPCDO2YrB5DfRPlvYbBv0XYCwv/Mmt+4aIJGo3s8cCsAcCIHATAWSGm0BDDQiAwNcQQF79GldjoNMJFGbTmFqee7q3v0WOfwDwUG6Umz5Q2woKbrBteJt1fJ/J/gux8P6TtrO/ttc/HhVf69fPBo6o+Ixf9myAzaLBARD4YgLIDF/sfAwdBEBgCgHk1SlYIfQrCRRm07Ba3leC7Rt0wQ19gtD7HyKAqPiHnDlsKIiKYShjQQAb88AeCIAAEUBmQByAAAiAwFgCyKtjeULaNxMozKYferhR8vcf/kAABEAABEAABEAABEAABEAABEAABEAABEAABIwRwH159xV5CyXV+4yAJmMEEBXGHGLCHETFJDcA7CSwEAsCSxNAZljafTAeBEDAIAHkVYNOgUmLEijMJtTy7vNpwQ33GQFNxgggKow5xIQ5iIpJbgDYSWAhFgSWJoDMsLT7YDwIgIBBAsirBp0CkxYlUJhNqOXd59OCG+4zApqMEUBUGHOICXMQFZPcALCTwEIsCCxNAJlhaffBeBAAAYMEkFcNOgUmLUqgMJtQy7vPpwU33GcENBkjgKgw5hAT5iAqJrkBYCeBhVgQWJoAMsPS7oPxIAACBgkgrxp0CkxalEBhNqGWd59PC264zwhoMkYAUWHMISbMQVRMcgPATgILsSCwNAFkhqXdB+NBAAQMEkBeNegUmLQogcJsQi3vPp8W3HCfEdBkjACiwphDTJiDqJjkBoCdBBZiQWBpAsgMS7sPxoMACBgkgLxq0CkwaVEChdmEWt59Pi244T4joMkYAUSFMYeYMAdRMckNADsJLMSCwNIEkBmWdh+MBwEQMEgAedWgU2DSogQKswm1vPt8WnDDfUZAkzECiApjDjFhDqJikhsAdhJYiAWBpQkgMyztPhgPAiBgkADyqkGnwKRFCRRm0+K1vO31eL5X8UrBDb+lgWzv5+Px4/4ez9d70wZMnfY+P4/HU++knai3lez5/f3d3q9D3eP5Si0Kbb7BHn0QorWKaHsdCD3Kn5+fyQEWR8W2bdv7qREVg5mzy+pfivqTneruTmvK0dWiq6UPx6kP0xFmd47yk+5xVHwi6W/PJT/5SZXLXS19/CjKkVPPS78lsCXhTUaeUflzQ9K7LwkPHFenqPczm4Crw/cxg08QaCCAzNAASXbpnM7y9HC/U5SaGahR+3sol6ihbmyDAAjMIYC8eoFrZzIsaegUpebVfSnlr+RHXNyWTMaxLIHCbFqzlre9ns/nvkicXGrJQu0/oLihPhCuLz18AW97U7kpGbKbf76itvEVzaXLl7o9NKvJBm/S9qLLp9gi7vB8bbtBzuh59jR5ogXR+/l4vZM/j7VJTX+nMCq2vUJ6iVW/anmGr7tI9aHDObguFtBboqtFV0sfEaefmC0x3bEfRsUd+qboID/5PEFlNroUiDOFSya1PtSrIeGHYUFnKNp+tVpeXXgkeR+JHMhvS4Zpwly3RwS3Oli2eUQSHjau325E/EWWhAxBjDyS83UTbXQCASagpNz6TIziEJmBrgsvXS/1Jhk9MzhvPOOLuNfz4uUK5gUIgMDHBJBXexH2JsOC/F5Rel51l1sjLiYLpuJQCwFlNvnTemp52+t12z1wZV3bRhUXV/hI1lR+aOY+FTfUBuIWZBH1tMnN12i4PCUvkKnZ8+vXY6c2VhVdwSn27Ku486zGrQZ7miQpJimI3s8LyJr0FzrJqCD/RjgL5044lKrngAstInLhfrMVdW+26Grpc672z5XFZbObxzewo4yKgaJvE5UCv9ZCzqwnfJIdTl/aV8JUAVsTzgEXit5LSVGTVL9nysikRvI1e25NwgPH1SuKPagWZKUk7nkpJTW6BN3+fQLIDH0+lpPwg4zXK4rnu5IZ6J+x5xe+G47W1jdQ9AYBELhMAHm1D11vMixI7xWVz6vxtTWpVGQXLMGhQQSU2eQl99Ty7ix1NOlSFll+XBY/827IDURvp1kUXLOonUSfThyqSJaRP3Ko0Ce53nqcVN5o0FoUoJ6fImoKuqKiCwdlVJCtgXcvSPzolES9wk5p6tGZP105kjQlDVplRW1Tzuwx+9a+MipuVT5IGU2wOJTZA1Fwt/Q5zcl7MH/kPJu38mBzIvR2kT3UTqKPsKS2q4rkk/JHDpmkOqo18hG99ThJ2VBVXRtXpyi6Sfil3lypClJsRxMIdBBAZoj+Z1wjp87Cv80MW/p0kO0Vfd3UBoXjIAACYwkgr66eV/XLRr11bOxAmiSQn02/HbW891NZHUhVg/bbdKmXE4MsmCAm74bcQPRLI9Gbd+M1s6uaX7+KERpOFtkDZxe+HzdV/X5KE4NTapstaksy2hApl4IloYOOyaggW1N8g5TVxUj1KnqKy+vJQBVJlqkHhK6WPo2i6jD+roeMir+z5APNdINZdJuE4ryWPocJyvnuWPbAcarfyIPNyfjqJMxQZD7SiXjCuc8uUVzJ2/ifvzLR5PyU04t2EGghgMwQ5eoasq7pXBbWJaqQGVItuCkvZYIWELiTAPLq6nmV8nO6JP1oRX9nAP5TuvKzqbmW557Blv6nfwanZl2LXdXn3ZAbiL5o4t7h3KIfoMX5Iiew0V3Z03WDhNTEPndHbmixOKO2m7WnduJxvAURanl7ESzwlObLvegW9Dow8wtYtANHj1ydzbcnJ8cWxHteatKaNHBPvdULMfWZzxWmzOw0htJH7Tuk1IcdqAloyktsbB5sTrguO4mllgzThStnDxe4kmkiRSf2XU3CA8fVLGpfr7t/ScmI0f0hx499EOgjgMzQx+u3eTrX5TaLKmYGqaf0LiPZF/sgAAIzCCCvdlJtToZ1uc2iynl12MVk3WL0KBPIz6aGWh77MX03lLai8o/up59WZV6lGr5UhTo9n+Ez+Dp00Yi5u2ZIGcdfHc27ITcQvZ0WM0qdPBgWnVdd7QX95aauN6jhkBv9S20UT/P5Pz90hGqM1PsjN+XskXZ37CuIuJZXGVmHhsauMiq8YcFrGvV3sIZTSb4ilE6ml8MQ9XNWVuU8nm96Q0EQOkw+2HeD4la5xvbPy6nEZn7atuhq6eMzQ7PZjZ66s5uMijt1z9HFE0t5Q3KordaHva9kkiMq6rM3D7YoPFH6fUnYO4o4JVPLH+z71EUFS3CmHLPv8HWfMej93QSQGT71vz6dL0nVRZUzg1TU9uMeeRb2QQAEBhJAXv0Upp4ML0nVRdXzKp1HVYdRK/pLxuMk9d19Hkv7b2zJm/FVtZfhPt2/y/39Ye69keJBtC6Qzi7qiw1JWk3XrpkDrGRTbOFf7/UnNe03RnzrU7Fe4jDHN+r1jT0HltvpKUZUFXIKcjdRRpUmEQd9xvjSzEhHq4io4ki15Z2cG8GgVWt+yDIqnGmv0xD1NcD7DXC7ramp25t7UEHPj0h9B/Lu0UhOuFLPlCyUNTaP8KP78lp0tfTxRcXUdTmz8975qyMyKv7KjhF6Ocb43w9+aqVSW/pUq8AteSkPlk3QkowSNd+YhJ3TiFI6sVKHNrToooLrSvW+PHZT23dQgw3oAgI7AWSGz0JBn86XZOqiapkhVrW9HoPyVCwXeyAAAh0EkFc7YCld9WSodKw36aIa8+rQFX3dVvRQCeRnU8N9eV4ixYG20nHHab0jjqaBk/6jLPOFW9blLfr378vbV68/z6PWQhcodOtUfj2VQXpAa9kg/tKddB6vapMj1BpfNtG0Z5uPm8vi4y02hH1y9oR9OrYziLZ3dJPojBqiYqScnDxWAV8SlvskNmlLGni+RI5QuFJT0IeEhPv7ALhZzHdlbHqTopU7tuhq6eMDNRjGCLP1wUxqlVExSc2NYre04Jxor/UpRk5DXvot/V8rJxxJ+PRTJnOeHdq3dFHRdaVay+MM0ObrdmPQEwTyKReZoR4d+nSun6f00EXVM0Mkinx29QIlEoQdEACBDwggr34Aj9Zs6TrmmkBdVFteHb2ivzYCnPWbn02janl0gZ18cyaN/P3qb+ja/SIfj87NjV/E+Wssk07Pu6E4kPM3kj/uR5KZegaNWZ+u3TRy9mQ0U3OQcORDMfeCfhIf7Wbl7GmXcPbsQjRS8WlCtCWjglQGMF3fmHC856XJE6lXzFz20EYn+nCXxBxuFcK9GfVPTS2d1aKrpU+jqLqhf9hDRsUfmjJStR65sYZCn1zk0CnppEnL2xdreRxQz/OZAnSbcUYlDaUrw8RjD/c+G+z4JDxqXAVE4royX8tLMpLq65AmtkGgTCCfcnMzkeXh8mxYxiOemeTZkhlC91J6ji9+wqPYBgEQuIkA8upl0JlkeEVeRlRbXp1wMXllDDindD2BqaAAACAASURBVC/CoFoeX+ykz9RLF1j0Oz/3w+vjp3+ag0hewzdx8RpLk/u3bReTmjSaR50uZrKXQfL8hv0c2IzqqDvtpNYVFugf2NNwatwlk9HiTsFeNLKgfeCmjAqVX4QvY5RsTi9npehI6j4k0YeFJu7UW1uh8NnK9Nalxq3xnteYtCYN3FNv9UJMfcqoMGXcB8ZoISfF5fuwA5sjxxWHRfc82JxwaR7vZ0OpN8Oo0k8Vwno6kFEdmU87yaz9qN41bly55fo+MvUyghp3FC3Dz0PFERDIEEBmuPZYFjOZIfBr/isk6IRNEACB6QSQVxfPq+MvJqfH3L+rID+bRtbylGVHDin/9JJqevrT+Hm50iAuWr7kdNlpz7uhayB0neIXNufg3E2w5/5HW1l79GukqDt1UXynn9loZaSg8Zy0WwURXZPK9e8YxakpQYuMClIpzYhX4TmUoj11hBQtTmCjZB+VAJ2oOTkYVmFTFUn91QNCV0ufRlEFE//8kIyKPzfoigFbetN14r6WPofu5Gx/RItkPZ7yYLPCvZLwU0TlfqiSYUIB9e2sPQ2DpS4Dk/DAcfWJ0jA3DL8OFz1AQBBAZrjwWOO+6SyIx7t9orTMcMjLps6jBzZAAARuIYC8unheHXwxeUvQ/bNK8rNpUC2Paw3K2iEiyq8JjVroBafqmoO+i2vicgv2WIOlvbwbytcecVlfvYg5XikdjHd7ha8IDg7UN7P28IF6pUnxHZmdnFi3xPXI2tMqgB+hllTqfkNEzFVG3UdWtxkno4LGmoCK7aC9FLGElPaSouUZZLDsw1NbaNPOaxss98qfTibXdLX08U/MiyHl9XYYf1NXGRU3qR2phnHLUBbea+kT2JT1IB+ozBonJw82K5xP/OIkPPDLpVeUCBfnCfVxsdQzCYAgdLAJAmUCyAzda87e6VxwQK8oLTMc4osHj17YAAEQmE4AeXXxvErZNF5Jcczgimv61FEU5GfT9VpeWAbZ74BILqXjPr/vZ9KDKgVpo7wvT8g5RlhefR3drGzk3ZAfCB8JZhLvS2L8pgk5yrh06uTIE+U5fj9vj1baEZNanfqij7sFS3O9NyH6zNvTOq46IpIk+UirI6MG7cioaLFDsytpo4Y4BSeimV7cJxHjXBWSSbscKD56j62vzld0sdGVPo2iDrvNbcioMGdg3aDET0qFtaVPoEmJV3+UglKEuxqnebB54XwkEK5ZTd9u8Uwiy/6BJNwwLj/bkvzpnbN/tokKT1K8qkTR3hTmhFAItkGggQAyw/n/CpfxKhOqYTo3yeHpW02ewoN6ZnCdWrUKkdgFARAYTgB5dfW8Srk2ubZVr66HBw8ECgL52dRRy+Mqjv92395P4Vy3vnkeb7bgJ+PFBWn++nXvN3UGch8vMrI5DJRU197VfWUfL3mNBFjcybqhMJDosoRvY5Szino8Xu/470VPag88tGuoLbaawDo3vo5X66Y3RFBFJ/AzuVncNDHKnjY5TYi4IE1vCd4zr7M6hDgnpmRUsLGPCF9K2E1G/3rjX4Wwe258EAL7gltMN3aml+N++r7/9t1z8Av1nQzHoBBygGFpwtXHQb+x+8wr9c37Jx+t6Grp02O2MMHCrowKCzZ12+CyuA+kPUjjkNy/Vcp9vOJy5NTzEsnJgi0Id4f2oP+qJEwjr365+KmWPh7XO44+W0XF53CFNr6MoA5tvg5FYRsEygSQGQ4+ey4sXS42TecGOaMzA43BXYbkLlKOUWIDBEBgOgHk1QNxQz60mVfrK/pjjNiYSiA7m357ann73Xf0GGr9MXdcCvCPrla60Bu/ns+ne/kF91M6eRA+7FVd7svaq3Ki0gt+L8rKp+KGloEkL0qLx3OAinDQTrhqdr2qlzct9vxS6eh8q2NQdQoMo4ef+Bc/kgv9Yt13GWVPk5w2RGRazWxv/sBPGRX7rTyR1yU9Vk+2ep9LwoEfvc+VJjeKUxO5kp4a+Hy93kLlqawwZ+kqWlZtQ1KBCYfhyrRt0dXSZ/enU1U0OzTSxraMChtWdVsRZoqfsEAdSGrp0xY5oaSMMq2W1yL8nCTqF1JbhmlKVn4p6mcIf/pJnMGWGSxNkmyK2BfR5cp727jGiuIxporDbzOe2dXvoAAWNkGgRkBJucgMWWjpBPUJK5yoTRmvTZS3JO0dKuRe6r9b/Pn4BAEQuJEA8uoJu54P0/RmJK/WLibPQWJrIgFlNnltP/9L/rbtvCfUd8PnAAIFNwyQDhFrEkBUrOm3uVYjKibxBdhJYCEWBJYmgMywtPtgPAiAgEECyKsGnQKTFiVQmE2o5d3n04Ib7jMCmowRQFQYc4gJcxAVk9wAsJPAQiwILE0AmWFp98F4EAABgwSQVw06BSYtSqAwm1DLu8+nBTfcZwQ0GSOAqDDmEBPmIComuQFgJ4GFWBBYmgAyw9Lug/EgAAIGCSCvGnQKTFqUQGE2oZZ3n08LbrjPCGgyRgBRYcwhJsxBVExyA8BOAguxILA0AWSGpd0H40EABAwSQF416BSYtCiBwmz62bS///AHAiAAAiAAAiAAAiAAAiAAAiAAAiAAAiAAAiBgjADuy7uvPlsoqd5nBDQZI4CoMOYQE+YgKia5AWAngYVYEFiaADLD0u6D8SAAAgYJIK8adApMWpRAYTahlnefTwtuuM8IaDJGAFFhzCEmzEFUTHIDwE4CC7EgsDQBZIal3QfjQQAEDBJAXjXoFJi0KIHCbEIt7z6fFtxwnxHQZIwAosKYQ0yYg6iY5AaAnQQWYkFgaQLIDEu7D8aDAAgYJIC8atApMGlRAoXZhFrefT4tuOE+I6DJGAFEhTGHmDAHUTHJDQA7CSzEgsDSBJAZlnYfjAcBEDBIAHnVoFNg0qIECrMJtbz7fFpww31GQJMxAogKYw4xYQ6iYpIbAHYSWIgFgaUJIDMs7T4YDwIgYJAA8qpBp8CkRQkUZhNqeff5tOCG+4yAJmMEEBXGHGLCHETFJDcA7CSwEAsCSxNAZljafTAeBEDAIAHkVYNOgUmLEijMJtTy7vNpwQ33GQFNxgggKow5xIQ5iIpJbgDYSWAhFgSWJoDMsLT7YDwIgIBBAsirBp0CkxYlUJhNqOXd59OCG+4zApqMEUBUGHOICXMQFZPcALCTwEIsCCxNAJlhaffBeBAAAYMEkFcNOgUmLUqgMJtWreVt7+fjZ/97PJ7vbQHXFNzwu70ez3dmDDRWP9jH86WPdTCQkj2/v7/b+3XwfzxfKf3Q5p8BDqrYkyEXN7chqg4tFvrxXhwV27Zt76dG9GNFLQJY/UtRf7JT3d0iO+hT9maLrpY+h8KyuqObpY04KixZ1mcL+amWu1r6/J4O/ynkk/rkLYEtxclAI5sJluy5NQm3wW8aV6eo9/PnJ/PFWPd1k0HoBAJMAJnhQiB0TueShk5RamagRu3voVyilmzBMRAAgTEEkFcvcOxMhiUNnaLUvMpXm+eVfOEKvGQJjn1OoDCblqzluXDzBaSNv8AX+LZW3LC9ns/nPkf0Jcv2evz8PHwBb3vTbtJzGJC6PTSrQ5O2F10+xRZxh+dr2z3kjL7koCZ7miZIG6Lq0Jp0dXUKo2LbK6SXWHVpVTv7uotUH1Lh2ZavO6tyfWOLN1t0tfThOK1NLm+Yvc8wKuxZ12gR+UmkLpEpXDKp9fkdOHkVsPWwDAOO/5HxTUm4DX5TSPSKov7yy8UpijyifQc12YNOIHAQQGY4UDRu9E7ngtheUXpmcFnh+XqHf6/nxcuVgrk4BAIg0EYAebWN09mrNxmeZyZbvaL0vOqW/ENW9ImFaOgioMwmf35PLW97vXK3jnlxwz4Lulx4Rpo4AuN6UnTcxo7ihm2jqw5XwdHs54uT+EDaNBBIzZ7f331dfRJl9lH1R7EnOes8v7jVYE/xfH9QMYntjtHKXtwlGpqXN/BTRgX5d7bOgvmpeg640CLCEu4XpMWH6t5s0dXSh/XW1cXmWdqTUWHJtlZb0ji53hJPVE4noixIssNetK+EqQK2FicccKHo/d8ZUZNUv2fKyKRGcDV7bk3CA8fVK4o9qNbypCTueSklNboE3f59AsgMfT6Wk/CDjNcriue7khnezzQJaG19A0VvEACBywSQV/vQ9SbDgvReUfm8Gl9bk0pFdsESHBpEQJlNXnJPLe/9jFYvXsSUz7wuZWXlAiv9Gp9i2XWheTeoY/J3wCXQaRYFg1VPFn06jVZFsoz8kUOFPsn11uOk8kaD1qIA9XyJSO1UFDvkoIwKMiPw7hAdHUIS9QoWpalDw/5PHu3fAorgpClp0CoroTnKCeFhm9syKmxaWbaKJlgcyuyKKLgb+qj+uzx582BVPd+ehFUoEn45DPzRTlF0k/BLuem7Nt29OnyCQBcBZAbtKzmLsHM6Z+XkMmw+yWQzw5Y+HWR7RV83JStwDARAYDwB5NXV8yql4qQKgWLe+KnSIDE/m347annvp+LQBu1XuhR08TVEvET8Z2t5+vWMuIqaAERoOD2YPXB24VJNegH1fkqfBafUNlvUlmS0IPpUR0l/6ZicnGRHiq8kYegxqV7FQnF5PRmoImkQ6gGhq6VPDEQ9I+5ib09GhT0LGyyiG8z8kxC4u+KKeh8+SU4JkRkVwRn78mBzMoSqXa7o3WJkxqJcs9BwdsseOLsMS8IDx9Ulitfrm3b/pZ4lgqFjEwSuEEBmiHJ1DWHXdC4L6xJVyAypFtyUlzJBCwjcSQB5dfW8Svk5XZJ+tKK/MwD/KV352dRcy3MPpUuLszM41XTR71Lj6cEXA/cY98GA827I2V9YRoZzaziQnD28tgo1qzT4bNHrs4mftUfVrzXWEemsNVlj22RU0FgFvLEKy9KEes2Xe9FNM5LfSKMdCJXmvNmiq6VPqCtXIRR9zO3KqDBn4CWDaI7V0rTSZ+TkzYPNhaWeGJJArBvZiSxnz81JeOC4mkXt63X3PzoZMbo/OuGiOwgIAsgMAkhtt3k61wTRI0gbL+mLmUHqqbw7SHbHPgiAwHACyKudSJuTYV1us6hyXk0udt1vbGsLvbp96NFLID+bGmp57Mf03VDaksw/up9+WpV5t2z4UhXq9HyGz+Dr0BUyoNMWiKu8G3jcClG9nRYz5fF+CkTXG9RwyI3n6ylFZXXv9/NDMUBFV+qtjC50YXk7Z0/5rOJRiYhVUBBVhlYUeuWgjApvWPCaRv3VseFUkq83ppPpnSpE/ZyVVTmP55terhLMpQNLNDRulWts/7ycSmzu0aHEQ4uulj6RqXl1oputXRkVtqy7Yg3PK+UNyaGslj7Un6IgCFJ3q1bb5M2D5dDKhWXS/n1J2DtKwvftFz51UcESnCnH7NlNbb6+YBFO+VoCyAyful6fzpek6qLKmUEqKvy4R3bFPgiAwBwCyKufctWT4SWpuqh6XqXzqOowakV/yXic9Pubn00NtTwPkLwZX1X7I+7T/bvcl3Xc6y7Fm+BdIJ1dOD40mTVdkWYnNb5RL+pgZSfvBhqCCldZy/CtT8V6yedAcvZwOz3FiKpCjnjuJsqo0iTioNshOXu6BfkTUkQdQ/NCxnzKqHCmvajI7Qm79wZHEb7fAHd0efLbjs8u25t7UEHPC1LfgbwPO5ITlkkyJQslLpnGR/fltehq6SP8wkPUsozoZ2pXRoUp4zqNYQfwvx986k8FtPTxZ1HfsJK3l2vb8lIebDZOlGD/xiTs8KfwvVu6P3VRwXWlel8eu6nN190W4YQvJoDM8Jnz9el8SaYuqpYZYlXb6xF/ScSHsQcCIHAHAeTVzyjryfCSTF1UY14duqK/ZD5OuqWWR+sdsV5OAyf9R1nmC5dOFdJyfsxIyHX/y/YLSc3dcfLzPGotdIFCt06JxWwwrBFAiL/mAF7VJkeoNb5somnPNh83l8XHA3ObNnP2NJ2cdtIQtQ4tlfZhi4wKHquALwnLfTIhaUsaktuZXHTFE43UB84iIeH+Plhujk9sx5DzZouulj7Ckpw60c3WrowKW9ZdsWZz1wJBbKVSmvooazSOioa89Fv6LszHCR/5+iRM7tIyZ+rGphZdVHRdqdbyOnzdZAc6gQATyKdcZIZ6iOjTuX6e0kMXVc8MkSjy2dULlEgQdkAABD4ggLz6ATwLV1xk/ugV/SdIvvrc/GwadV8eXWAn35xJI3+/+hu6do/Ix6Nzc+sXsf6tb9XXeTfkLxZ5/UQ3XfGf+5Ekr2b0NfEgIDl7MpqpObBHPhtvL+gn8dHup5w97RLOnhlEbUM7xQzbklFBYw1gOj0x4XjPWyJPpF4xc9lDwyr6cJfEHG4Vwr0Z9U9NLZ3Voqulj7Agp050s7Uro8KWdZet0SM3Flfq8/nkzYMtxsn5Q/Wfb03C8y8rSUOcsSgWRJ7hpiQjpf/KiIMKeyBQIYDMUAGUP5xJy/kT8kcyoloyQyiUskScSsKj2AYBELiJAPLqZdCZZHhFXkZUW14dv6K/MgScU7wXYVAtj5dBe70p/hAX3fQ7P/fD6+Onf5qHSF71mzgTnZo8G20Xk5o0nmELrtxnHJDcsjajOupOO6l1pQW6HGC6HylID7e35BG1DK1dT0dPGRUqvwhfhoZsTi9npehI6m6y6MNCE3fqra2D5rOV6a1LjVvjPa9Rbw1GVM8mXpSRTxkVRsz62Awt5KTQXJ8hkzcPloNICUtpHu9nIy5vpCqn0JizJ6M66k47yaz9qN41blz5miAPIb5+CPZ217QMv0AVh0BAJ4DMcD6iQyekt5rJDIF5ua+QoAs2QQAEbiCAvLp4Xh1/MXlD1P2rKvKzaWQtr3UZxHdsvty7E/Sn8fMdOmVx7p7PtRyWdwOvT8oDPodK1ylpbWIokKw9+jVS1J26KEPRzzxHVdyKFBR7lg6WEekGjtFcskpGBWlMluGRcdFOIFq0027sCClanMCiZB8VAJ0oZAd21DZVkXSSekDoaukTG6CeEXextyejwp6FDRZt6U3XiTNa+pCqUZM3DzYxrTRCEZV717KRJXnKsaw92rQVk4e6xHOfFehnKrpF08Bx9YnSMOuDyNISQ8EuCOgEkBkuPNa4bzrr4PfWPlFaZjjEIxkcKLABAn9LAHl18bxKqXbgxeTfRuPq2vOzaVAtj//jr7g7Are9krcY8osTlPPou1hpPsQdb1A+WmgtE74RNzhgZjPvhvK1R1zWVy9iBgPJ2sMH6pUmxXf6CqzRN1l7Gs+nbjVEDUPr0NbeVUYF2VEmnJltElKagqVoeQYZLfuwMjEZtfPaB6yX7Ph8JbYTXS19ImMSCdFRozsyKoyaWTKLuctQFt5r6UM6xk3ePNhynHxxEq7BLwWBONYrSoQLS2M/VTKkUItdEKgSQGboXnP2TueCD3pFaZnhEF88ePTCBgiAwHQCyKuL51XKpqNX9NOj7l9VkJ9N12t5celMv76O+9CCLIlq+Uts5wISF0RPKic4uDtNqRRac2feDfllJB8JWKig+U0TcrQxECcn5S/Pcvt5e7TSDs31QLI69UUfV88Jz9IN2Vvz9rSOqwFRw9CKRl48KKOCRhTQZKmSntynTkkbNcTzJBGtcE3EOFeFFqVdjqF/9B5bf2deRRcbXelzGORlxiDCwza3ZVTYtLJoVeKnPUjDoGzpw5W81H9xfmuevHmwymTYx8dHArM1q+nbrWakkxOGbglg3p6GwaaTX0kRTfY0jMtPsiRvieG1iQpPomEE4PdDSmshJ4XysA0COQLIDOf/K0ZlhiY57n81teQp3KbkgKNHq9bjBGyAAAhMIoC8unpepVybpGdccU2aL2Wx+dnUUcuLigXb+ymcy9+f9JPZPXD5yXhx6Y6/ft37TZ293Edd2oSBEusiPY/XO/570dshhEFlJH9xNOsGd+1xvCgxtC26LOHbGOU4m4DsGmqLrV1zwR6/Hn+8jlfrxpU8EkEVncDP5Oao2rf/IEx9Q2o4eL+dt6dtXNSrKWZchJaG5k0a9ymjgo19RPhSwm4y+tcb/yqEXXEvnhOOw/nN4p3p5fBbh/l5lvHTLJny7nGOQXXOemnC1QkplkbTNTLEd2vR1dLHy9urxjl1RzdjGzIqjJnXZo7L4t7Pe5DGIbl/qxT6kLMHTt4s2EJYukN70H9VEm6Fv8Mrfb+0igpDa3txLS++jKAOf5GoQ8Ow/e8RQGY4fDpqOjfIOX4KEF/RvyuX9NnMQGPg7FDKRcdAsQECIDCXAPLqwbchHzZdJjXIGZtX6yv6Y4zYmEogO5t+e2p5ZwVmf5WftJlLAf5h1cqT8OhdgM+ne1Ce66Z08kJ9uEpdR7tXdHyKRaIXZOdTcYO76jiGQBtJnSR5hWI8ojYgrlciOxblr4LK9tCzq/hKi7uFVadAGj38xL99l1zoF+u+yyh7muS0IWLTGobmhzDoU0bFfr9R5HVJbzf1eL9xQjiIK+9zpcmN4NREBUR6kvXz9XoLleRPFxaFOUvxI6u2IaXABB9i3rqwW4uulj6N6kLVZrZlVJgxrM+QcDr9ZFPFmU2UPoMnrwK2JU7OSSK/kBhIm5FNycpUEm4bV9N9ec2iMkDF13sYWZnA6gtV9P5yAsgMZwDUM1XbdK7LOXKHvyIIP8WcZ/tSxUkv9d8t5+CwBQIgcBsB5NUTdT0fpunNJ8QwzdXlDM+rtRX9OUhsTSSgzCav7ed/yd/mb63zffA5hkDBDWMUQMqCBBAVCzptusmIikmIAXYSWIgFgaUJIDMs7T4YDwIgYJAA8qpBp8CkRQkUZhNqeff5tOCG+4yAJmMEEBXGHGLCHETFJDcA7CSwEAsCSxNAZljafTAeBEDAIAHkVYNOgUmLEijMJtTy7vNpwQ33GQFNxgggKow5xIQ5iIpJbgDYSWAhFgSWJoDMsLT7YDwIgIBBAsirBp0CkxYlUJhNqOXd59OCG+4zApqMEUBUGHOICXMQFZPcALCTwEIsCCxNAJlhaffBeBAAAYMEkFcNOgUmLUqgMJt+Nu3vP/yBAAiAAAiAAAiAAAiAAAiAAAiAAAiAAAiAAAgYI4D78u6rzxZKqvcZAU3GCCAqjDnEhDmIikluANhJYCEWBJYmgMywtPtgPAiAgEECyKsGnQKTFiVQmE2o5d3n04Ib7jMCmowRQFQYc4gJcxAVk9wAsJPAQiwILE0AmWFp98F4EAABgwSQVw06BSYtSqAwm1DLu8+nBTfcZwQ0GSOAqDDmEBPmIComuQFgJ4GFWBBYmgAyw9Lug/EgAAIGCSCvGnQKTFqUQGE2oZZ3n08LbrjPCGgyRgBRYcwhJsxBVExyA8BOAguxILA0AWSGpd0H40EABAwSQF416BSYtCiBwmxCLe8+nxbccJ8R0GSMAKLCmENMmIOomOQGgJ0EFmJBYGkCyAxLuw/GgwAIGCSAvGrQKTBpUQKF2YRa3n0+LbjhPiOgyRgBRIUxh5gwB1ExyQ0AOwksxILA0gSQGZZ2H4wHARAwSAB51aBTYNKiBAqzCbW8+3xacMN9RkCTMQKICmMOMWEOomKSGwB2EliIBYGlCSAzLO0+GA8CIGCQAPKqQafApEUJFGYTann3+bTghvuMgCZjBBAVxhxiwhxExSQ3AOwksBALAksTQGZY2n0wHgRAwCAB5FWDToFJixIozKZFa3nb+/l4/Li/x/P13lbwTMENv9vr8XxnBtE0WOq0A/l5PJ6fEinZ8/v7u71fh7rH85XiD22+wZ4Mubi5huj99ADjz4cyvljyJ3txVGzbtr2fGtFPdDSfy+pfivqTneruZgWuYzm6WnS19KEwPaJ0RBB2jvKT7nFUfCLpb88lD/i8lEvUo/q05KXfEthSWLYYOTreSva0DDa0+aP4J0E+J3745dIpinJy5oux+h30t5EP7YsRQGa44LDO6VzS0ClKzQx/cwlXGhWOgcB3E0BeveD/zmRY0tApSs2rfLV5Xsl/dDFZshXHagQKs2nFWt72evw8fP1ue79omZG53q+RufW44obt9Xw+9zmiD4EGK0eb9HTzz1fUNr6iuVSBqttDszo0aXtRBSy2iDs8X9tukHPRPHuanFhH5Ib1fL3Dv9czX2Nt0lvtFEbFtldIL7Gqaqp28HUXqT50OAfXRSYt0dWiq6XP72/d41Ugf9chjIq/s+JDzeSnWqIe1aclL9FwFLD1sAwDjv+R8ZAp73dgvNXtaRks2zwiCQ+cR72iqL9CumX4H4YuTv86AsgMvS7vnc4F+b2i9Mzg8vTtl3CFceEQCHw5AeTV3gDoTYYF+b2i9LzqlvwjLiYLpuJQCwFlNvnTemp52+uVu3XMixv2WdBF4RZXG9KWYXaMFKS4YduocOQqOHE9zCl2C7KIetrk5mtkKU9JTWDUK92p2XMsWc9TWVXkD8WevbByntW41WBPkyTFpATR+xmNguVqbU0K2zvJqCD/poa0y/uwZ6qeAy60iMiF+80a695s0dXSx1dWItMSj0dHbe3IqLBlXZs1aZzMa0kdzt5Ow1QBWwtLDrg4maZNpC7uwzlPtrWQq9lzaxIeOK5eUexBtZYnJXHP1NctsNEHBBwBZIa+SJCTcE9LVzJeryie70pm0C7XtLa+gaI3CIDAZQLIq33oepNhQXqvqHxeTS5ur67oC9biUAMBZTb5s3pqee+nWKx4IRM+C7o44KIL92R1P8GgASLzbkiXhk6d3k4AgvGrnUSfTutVkSwjf+RQQarTQNFbj5PKGw1aiwLU8wWiLf1p6fYKMBcVfHBQRgXZeoPanMWJeoWd0pQTp7XnT1eOJE1Jw36jaBxySi9X7vlDtBqLXJuMilw/y+00weJQZq9EHhjVR/W3BicPNidCb0+yh3KrnuijmVNo0/XSCfkjhzhSHc8IOqS3HicpG6qqa+PqFEU3Cb+Um76bhq+MBE0gUCSAzBD9z7jIKpeE/jYz/NUlXA0VjoPA9xJAXl09r+qXjXrr98b5PSPPz6bfjlre+6msDiYNoKiL7lvwvydlLnUpcgAAE4xJREFU/eoqYZJlH4jNuyE3AP3SSPTm3XjN/GnZQmg4x5w9cHbhlWa0Xudj76c0MTilttmitiTjGqJ7/qMro4JsTfGVRjf0mFSvoqe4vJ4MVJE0CPWA0NXSx4uSHPXpNBTfKGEyKkbJvVVOS6Ie00eNCnWsebA5GXrUiN68OzbehIZzNNkDZ5dhSXjguLpEcSVvU29tbBl+QAKbINBEAJkhuqiuMeuazmVhXaIKmSHVcs8lXKoXLSAAAo4A8urqeZXyc7ok/WhFj8lxkUB+NjXX8twz2NL/9F+0qHhaty5abd1jWtHu2sG8G3LLk8IyMpxb9EPdOF/kBNZM3I9nT9cNElL57NA+d0eIaBEnFXez9hTPCg/2I6o8eD4U/tG2jAoa6weoPrJlL4IF6jVf7kW3oNehlJ+Rrx04evg6mzJfW3S19HG6+j0e2vjX2zIq/tqeMfpbEvWlPk15iceQB8uhpYSlLjsJxOHxlrOHC1y1Oebq4qLXpauvgeNqFrWv192/pORXu+6PMQEKKd9LAJmh0/fN07kut1lUMTNIPXddwkm92AcBEPAEkFc9icbP5mRYl9csqpxXk4vdj1f0ddPRQyWQn00NtTz2o3+J3fmpLHp+/aP76adVmVephi9VoU7PZ/gMvg5dfqAkcMSrNb28iZ95N+SWbXo7LWbK5R46T6zjusal6w1qOEx9DwbF03z+zw8doRoj9dbipdmmnD3NAtKONUTFO0NTcddbZFR4w4LXNOrxHU4l+YpQOpneqULUz1lZlfN4vulVMkHoMPlg342TW+Ua2z8vpxKbmdvvfI2voqvPnsgrHmzUaHVHRoVVO9vtaknUV/scUcEC8nlJf/fFPgYWoqQpvf37krB39cB5pIsKluBMOfYJu4OyRN3X3mJ8gkCdQD7l6hkg90WGzFBnXe1xJTNIobddwknF2AcBEPAEkFc9iaufejK8JE0XVb7iIkX8FThwRX/JeJykvrvPY2n/jS15M76q9jLcJ13CHC8tpAvtdE3vAsnfQlZ4A21NF2vcwytQGhtkbq8/qWm/MeJbn1K2wWgd5vhGveBwwyajVZzN7fQUI6oKOQW5myhppeUrv0l9psGEqEvOnqhTz04N0fZ6fGx0oz0yKpxpLypye8LuvcGRQ/cb4I4uBDu0eHtzDyroeUFuvgmv7h6N5ISCMgsTbhaiaLy7WZGpCYecN1t0tfRJFFJDzePqSX/XKKPi7yz5XDP7m//94FN/KvOzPnx2W17Kg2UhSkwjCYfuIkphogmPdW7rooLrSvW+vA5fd9qD7l9NAJnhM/fr0/mSTF1ULTPEqm68hIsVYw8EQOAkgLx6sriypSfDK5Iyi6DGvDp0RX/JfJx0Sy2P1thiHZTGYPqPsswXLp0qpOX8uLkQG7S8yGkZ0n4hqe318OdRa6EaE906lV9PZZB2jYD4aw7gSkpyhFpj/uQTtvm4uSw+3mWM/69AY0A0yK4i6oi/BnXlLjIqmL2ALwnLfdKQtCUNaSpX/ExNgbNISLi/j4WbrzpE0cpiW3S19FF4Vz2unPOnTTIq/tSYIcpbEvXVPhwVDXnp0n15/p+S356EKQoGziNdVHRdqdbyOnw9JG4h5EsI5FNu7gsLmeEMDX06n8c7tnRR9cwQqSCfXb1AiQRhBwRA4AMCyKsfwLNwxUXmj17Rf4Lkq8/Nz6aG39h6csUvR7rATr45k0YW4W/o2uXK91hwc1GXNyj4JE1BASI4Ymkz7wYab8pvt/38jeSP+5Ekr2b04eqXQd0QcvZkNAv88rFMe0E/iY92s3L2tEs4ezYgovF8YO2pq2VLRgWNNXFuTDje80rkiekoZA8Nq+jDXRJzuPUyIk0tDaJFV0sfD8R/NnjcdzXzKaPCjGGfGaJHbizzQh86JZ00aXn7Yi2PY/O4zfhbk/D8y0rSEOdddqzSlGQk1ddxXGEPBEoE8ik394XF0nB5dkOJvykzhM6lxBHnjfAotkEABG4igLx6GfTAlUtGVMsVF/9LNbri+nxFfxnJt5+Yn02Danl8seN/URl9RiFA5d3Xg396Sc+4K//iquubuGX99+dRkHdD8WJR2q2XM4beNJGzJ6M66k47wuvaXWNyVMX9SEGxZ+VgJqPFZ90bTDIqVH6RSRkasjm9nJWiI6k7A9GHhSbu1Ftjivk9PluZ3rrUuDXe8zr0Vj7a5HEvx86njAo7ln1miRZyUmJ/n4z/uVkEWh6s1luaduxnNI5c1ubsyaiOutNOMms/qncNnEdZUTyE6PIh3Nkd2TL8w03YAIFWAsgM5Udj5Dhmp3PuhHx7VlRTZgjktnyFBN2xCQIgMIkA8urieXX8xeSkSPsGsfnZNLKWJxZNJbD800uq6elP4+c7dPLitvRePv6uz59RsuW+Y3k3dJlP1ynp/xzdTbCDBpO1R79GirpTF8UT+pmN9kYKGs9JuzUiGqMsVZ9pkVFB6pNleEQv2gmkinbajR0hRYsTWJTso9KgE4XswI7apiqSTlIPCF0tfQ4DGj1+9LezIaPCjmUdlrQk6jF9tEjW4ykPVo2s3GhFVO7dhsZb1p6GwVKXeO6zhfqZuTGe7QPH1SdKw6wPIkvrHAW2QKBAAJnh1b/o7JvOBfr+Z1zFLsFBLTMch5EMDhTYAIG/JYC8unhepVQ78GLyb6Nxde352TSolsf/8VfcHYHbXk8Z1PziBOU8+i5Wmlkcf0/Lakfxmz2y4g938m4oX3vEV1jqUI9XSgfD217hK4KDA/XNrD18oF5pUnxHZicn1i1xPbL2tApwr2VI9KuIVMAdijq7yqigsSaGxvRoL0UsIaW9pGh5Blku+/DUFtq08zpGnT9dQZ90bunjjBk8KTpG+HlXGRWfS7xdAntOhrLw3tA+lVnjAOTBJpEWEfviJDxwHvWKEuHCHmE/Nfk6ciB2QKBIAJlBXp4XcdHB3ulcENgrSssMh/jiwaMXNkAABKYTQF5dPK9SNk2Xmx/9ymN60P2zCvKz6XotLy6D6NfXcR/65k+iWj5bzfmAxAXRE8nRVK3x3Z13A48pGPAZiXwkYKGNnsCmJ8elUycn5X9qCrfy9milHaIfSFanvujjbsEKzwrVJ9t5e1rH1YBo19oqMTHyYoOMCtIf0GSpkp7cp05JGzXEYZGI5rHGfRIxzlWhRWmXY+gfvcfW35lX0cVGV/q4dUY8MjIynhSH2fY2ZFTYs7BqUeKnPUjDoBzVJ/uWhDBO2OI8WGUy7GPkI4HZmtX/bBJuy5wOUUI7DpI2UeE5lGoC8PshpbWQk0J52AaBHAFkhvP/FaOmc5OcS1/WSg44HNuq9TgBGyAAApMIIK+unlcp1yZrKVxxTZovZbH52dRRy4uKBdv7KZzL35/0k9k9cPnJeHHpjr9+3ftNnb3cR73+DwMl0eUO+qftkRD6se67zMDA0awb3LXHj39RYmhqdFnCtzHKWUU9Hq93/PeiJ7UHSHYNSZEoVHVuF+zx6/GHf9oh2yR8SBWdwM+7h8JgGGVPmxzqVUXkh89R2gjKn/PJp4wKNvYR4YtrpayM58ARMAphV90IQkC75+4ogbhJ6376vv/23c+vs8LGLZq/j+E7dhV4u88O44+zeYOP7tGV01XvwxBrkyJWbGtPRoUt6xqtaUnUo/rsoVzMS2R2FmwhLN2hPcl9VRJunUc7vNLMbxUVxtb24lpe+M3hDnOiqfo6FIVtECgTQGY4+Iyazg1yjsuS+AL2La9gD9vcRjYz0GF3GSIuSoUA7IIACNxBAHn1oNyQD5sukxrkjM2r9RX9MUZsTCWQnU2/PbW8/flD9Dhq/TF3XArwT6tWutAbv57Pp3v5BfdTOnkQPlxVXbGmoO7hzzb5qbjBXXV4Zo6JXLkkL0qLB3eAiqTQTljIcb2qlzct9vAbTM63Our06Tkq/JITMkR5z8koe5rktCHasapr9Rj50D0ZFfutY5HXg7raqZsQe59LwoEfvc+VJifr1ESupMdPP1+vt1B5KivMWbqKprq6jGBvc2DCYbjSt0VXpU+Xx715lj5lVFiyrcOWlkQ9qk9TXtJqeS1heU4S/QuJ/p+k/q2dhJvnUT0PN4vi8Ep7hyDpQtWt9pl5+J+PjuBEVxAICCgpF5kh4BNvphPUp79wotbTgv9XoT87+gxFefWp4qTX3Zdw3jR8ggAISALIqyeRej5M05vPiGGaq8sZnldpxXVc5Mr15jlCbM0loMwmr/Dnf8nf5m+t833wOYZAwQ1jFEDKggQQFQs6bbrJiIpJiAF2EliIBYGlCSAzLO0+GA8CIGCQAPKqQafApEUJFGYTann3+bTghvuMgCZjBBAVxhxiwhxExSQ3AOwksBALAksTQGZY2n0wHgRAwCAB5FWDToFJixIozCbU8u7zacEN9xkBTcYIICqMOcSEOYiKSW4A2ElgIRYEliaAzLC0+2A8CICAQQLIqwadApMWJVCYTajl3efTghvuMwKajBFAVBhziAlzEBWT3ACwk8BCLAgsTQCZYWn3wXgQAAGDBJBXDToFJi1KoDCbfjbt7z/8gQAIgAAIgAAIgAAIgAAIgAAIgAAIgAAIgAAIGCOA+/Luq88WSqr3GQFNxgggKow5xIQ5iIpJbgDYSWAhFgSWJoDMsLT7YDwIgIBBAsirBp0CkxYlUJhNqOXd59OCG+4zApqMEUBUGHOICXMQFZPcALCTwEIsCCxNAJlhaffBeBAAAYMEkFcNOgUmLUqgMJtQy7vPpwU33GcENBkjgKgw5hAT5iAqJrkBYCeBhVgQWJoAMsPS7oPxIAACBgkgrxp0CkxalEBhNqGWd59PC264zwhoMkYAUWHMISbMQVRMcgPATgILsSCwNAFkhqXdB+NBAAQMEkBeNegUmLQogcJsQi3vPp8W3HCfEdBkjACiwphDTJiDqJjkBoCdBBZiQWBpAsgMS7sPxoMACBgkgLxq0CkwaVEChdmEWt59Pi244T4joMkYAUSFMYeYMAdRMckNADsJLMSCwNIEkBmWdh+MBwEQMEgAedWgU2DSogQKswm1vPt8WnDDfUZAkzECiApjDjFhDqJikhsAdhJYiAWBpQkgMyztPhgPAiBgkADyqkGnwKRFCRRmE2p59/m04Ib7jIAmYwQQFcYcYsIcRMUkNwDsJLAQCwJLE0BmWNp9MB4EQMAgAeRVg06BSYsSKMwm1PLu82nBDfcZAU3GCCAqjDnEhDmIikluANhJYCEWBJYmgMywtPtgPAiAgEECyKsGnQKTFiVQmE2o5d3n04Ib7jMCmowRQFQYc4gJcxAVk9wAsJPAQiwILE0AmWFp98F4EAABgwSQVw06BSYtSqAwm1DLu8+nBTfcZwQ0GSOAqDDmEBPmIComuQFgJ4GFWBBYmgAyw9Lug/EgAAIGCSCvGnQKTFqUQGE2oZZ3n08LbrjPCGgyRgBRYcwhJsxBVExyA8BOAguxILA0AWSGpd0H40EABAwSQF416BSYtCiBwmxCLe8+nxbccJ8R0GSMAKLCmENMmIOomOQGgJ0EFmJBYGkCyAxLuw/GgwAIGCSAvGrQKTBpUQKF2YRa3n0+LbjhPiOgyRgBRIUxh5gwB1ExyQ0AOwksxILA0gSQGZZ2H4wHARAwSAB51aBTYNKiBAqzCbW8+3xacMN9RkCTMQKICmMOMWEOomKSGwB2EliIBYGlCSAzLO0+GA8CIGCQAPKqQafApEUJFGYTann3+bTghvuMgCZjBBAVxhxiwhxExSQ3AOwksBALAksTQGZY2n0wHgRAwCAB5FWDToFJixIozCbU8u7zacEN9xkBTcYIICqMOcSEOYiKSW4A2ElgIRYEliaAzLC0+2A8CICAQQLIqwadApMWJVCYTajl3efTghvuMwKajBFAVBhziAlzEBWT3ACwk8BCLAgsTQCZYWn3wXgQAAGDBJBXDToFJi1KoDCbUMu7z6cFN9xnBDQZI4CoMOYQE+YgKia5AWAngYVYEFiaADLD0u6D8SAAAgYJIK8adApMWpRAYTahlnefTwtuuM8IaDJGAFFhzCEmzEFUTHIDwE4CC7EgsDQBZIal3QfjQQAEDBJAXjXoFJi0KIHCbEIt7z6fFtxwnxHQZIwAosKYQ0yYg6iY5AaAnQQWYkFgaQLIDEu7D8aDAAgYJIC8atApMGlRAoXZhFrefT4tuOE+I6DJGAFEhTGHmDAHUTHJDQA7CSzEgsDSBJAZlnYfjAcBEDBIAHnVoFNg0qIECrMJtbz7fFpww31GQJMxAogKYw4xYQ6iYpIbAHYSWIgFgaUJIDMs7T4YDwIgYJAA8qpBp8CkRQkUZhNqeff5tOCG+4yAJmMEEBXGHGLCHETFJDcA7CSwEAsCSxNAZljafTAeBEDAIAHkVYNOgUmLEijMJtTy7vNpwQ33GQFNxgggKow5xIQ5iIpJbgDYSWAhFgSWJoDMsLT7YDwIgIBBAsirBp0CkxYlUJhNqOXd59OCG+4zApqMEUBUGHOICXMQFZPcALCTwEIsCCxNAJlhaffBeBAAAYMEkFcNOgUmLUqgMJtQy7vPpwU33GcENBkjgKgw5hAT5iAqJrkBYCeBhVgQWJoAMsPS7oPxIAACBgkgrxp0CkxalEBhNqGWd59PC264zwhoMkYAUWHMISbMQVRMcgPATgILsSCwNAFkhqXdB+NBAAQMEkBeNegUmLQogcJs+j+SYVd0dpDjNwAAAABJRU5ErkJggg==



单机多实例配置:
三个实例配置分别如下: 这3个实例 分属不同的 mgr集群,每个 mgr集群有自己独立的vip


以下为 其中一台物理服务器上的实例配置.其他两台 各实例将对应的report_host 分别为:192.168.2.247, 192.168.2.248

===========================================

bind_address = 0.0.0.0
port = 3316
report_host= 192.168.2.246
report_port= 3316

#*** GreatSQL mgr vip Specific settings ***
loose-plugin_load_add = 'greatdb_ha.so'
loose-greatdb_ha_enable_mgr_vip = 1
loose-greatdb_ha_mgr_vip_nic = 'bond0:1000'
loose-greatdb_ha_mgr_vip_ip = '192.168.1.25'
loose-greatdb_ha_mgr_vip_mask = '255.255.0.0'


===========================================

bind_address = 0.0.0.0
port = 3326
report_host= 192.168.2.246
report_port= 3326

#*** GreatSQL mgr vip Specific settings ***
loose-plugin_load_add = 'greatdb_ha.so'
loose-greatdb_ha_enable_mgr_vip = 1
loose-greatdb_ha_mgr_vip_nic = 'bond0:1001'
loose-greatdb_ha_mgr_vip_ip = '192.168.1.26'
loose-greatdb_ha_mgr_vip_mask = '255.255.0.0'


===========================================

bind_address = 0.0.0.0
port = 3336
report_host= 192.168.2.246
report_port= 3336

#*** GreatSQL mgr vip Specific settings ***
loose-plugin_load_add = 'greatdb_ha.so'
loose-greatdb_ha_enable_mgr_vip = 1
loose-greatdb_ha_mgr_vip_nic = 'bond0:1002'
loose-greatdb_ha_mgr_vip_ip = '192.168.1.27'
loose-greatdb_ha_mgr_vip_mask = '255.255.0.0'


3个集群启动后 会自动绑定各自的vip到 primary节点的服务器上 当前3个集群 primary节点均在节点1上
ifconfig

bond0: flags=5187<UP,BROADCAST,RUNNING,MASTER,MULTICAST>mtu 1500
      inet 192.168.2.246netmask 255.255.0.0broadcast 192.168.255.255

bond0:1000:0: flags=5187<UP,BROADCAST,RUNNING,MASTER,MULTICAST>mtu 1500
      inet 192.168.1.25netmask 255.255.0.0broadcast 192.168.255.255


bond0:1001:0: flags=5187<UP,BROADCAST,RUNNING,MASTER,MULTICAST>mtu 1500
      inet 192.168.1.26netmask 255.255.0.0broadcast 192.168.255.255


bond0:1002:0: flags=5187<UP,BROADCAST,RUNNING,MASTER,MULTICAST>mtu 1500
      inet 192.168.1.27netmask 255.255.0.0broadcast 192.168.255.255



但是 当通过mysql shell 或 udf 传统 方式 主动指定 primary节点时
c.setPrimaryInstance('192.168.2.247:3316')
vip 在原来的主节点服务器上不会主动释放, 会造成类似脑裂的问题

经测试单机单实例时功能正常.单机多实例 对于多个集群的vip管理功能异常.


解决:
3个集群的配置文件中 分别 添加
loose-greatdb_ha_port = 33162
loose-greatdb_ha_port = 33262
loose-greatdb_ha_port = 33362
重启集群.


附log:
==============================================
源主库
2024-11-15T00:44:21.757900-08:00 277 Plugin group_replication reported: 'Starting group operation local execution: Primary election change'
2024-11-15T00:44:21.762822-08:00 0 Plugin group_replication reported: 'A new primary with address 192.168.2.247:3316 was elected. The new primary will execute all previous group transactions before allowing w
rites. Enabling conflict detection until the new primary applies all relay logs.'
2024-11-15T00:44:21.764115-08:00 278 Plugin group_replication reported: 'Setting super_read_only=ON.'
2024-11-15T00:44:21.774908-08:00 278 Plugin group_replication reported: 'This server is working as secondary member with primary member address 192.168.2.247:3316.'
2024-11-15T00:44:21.774948-08:00 277 Plugin group_replication reported: 'Termination of group operation local execution: Primary election change'
2024-11-15T00:44:21.775029-08:00 231 Plugin group_replication reported: 'Primary had applied all relay logs, disabled conflict detection.'
2024-11-15T00:44:21.775981-08:00 0 Plugin group_replication reported: 'Configuration operation 'Primary election change' terminated. Primary server switched to: ca348a8c-a312-11ef-9854-ac1f6bdb80fe'



目标 主库:
2024-11-15T00:44:21.759272-08:00 275 Plugin group_replication reported: 'Starting group operation local execution: Primary election change'
2024-11-15T00:44:21.763051-08:00 0 Plugin group_replication reported: 'Elected primary member gtid_executed: bea16249-a312-11ef-adf7-ac1f6bdb81d2:1-32, e7895b9b-a31b-11ef-8c27-ac1f6bdb81d2:1-89, e7896234-a31b
-11ef-8c27-ac1f6bdb81d2:1-11'
2024-11-15T00:44:21.763150-08:00 0 Plugin group_replication reported: 'Elected primary member applier channel received_transaction_set: bea16249-a312-11ef-adf7-ac1f6bdb81d2:1-32, e7895b9b-a31b-11ef-8c27-ac1f6
bdb81d2:1-89, e7896234-a31b-11ef-8c27-ac1f6bdb81d2:1-11'
2024-11-15T00:44:21.763180-08:00 0 Plugin group_replication reported: 'A new primary with address 192.168.2.247:3316 was elected. The new primary will execute all previous group transactions before allowing w
rites. Enabling conflict detection until the new primary applies all relay logs.'
2024-11-15T00:44:21.763900-08:00 276 Plugin group_replication reported: 'Setting super_read_only=ON.'
2024-11-15T00:44:21.765008-08:00 233 Plugin group_replication reported: 'The member action "mysql_disable_super_read_only_if_primary" for event "AFTER_PRIMARY_ELECTION" with priority "1" will be run.'
2024-11-15T00:44:21.765065-08:00 233 Plugin group_replication reported: 'Setting super_read_only=OFF.'
2024-11-15T00:44:21.765198-08:00 233 Plugin group_replication reported: 'The member action "mysql_start_failover_channels_if_primary" for event "AFTER_PRIMARY_ELECTION" with priority "10" will be run.'
2024-11-15T00:44:21.774529-08:00 0 Plugin greatdb_ha reported: 'connect_with_timeout 192.168.2.246:0 failed return -3'
2024-11-15T00:44:21.774893-08:00 276 Plugin group_replication reported: 'This server is working as primary member.'
2024-11-15T00:44:21.774909-08:00 275 Plugin group_replication reported: 'Termination of group operation local execution: Primary election change'
2024-11-15T00:44:21.775068-08:00 225 Plugin group_replication reported: 'Primary had applied all relay logs, disabled conflict detection.'
2024-11-15T00:44:21.775826-08:00 0 Plugin group_replication reported: 'Configuration operation 'Primary election change' terminated. Primary server switched to: ca348a8c-a312-11ef-9854-ac1f6bdb80fe'
2024-11-15T00:44:21.781015-08:00 0 Plugin greatdb_ha reported: 'connect_with_timeout 192.168.2.246:0 failed return -3'
2024-11-15T00:44:21.781143-08:00 0 Plugin greatdb_ha reported: 'connect_with_timeout 192.168.2.246:0 failed return -3'
2024-11-15T00:44:21.804386-08:00 0 Plugin greatdb_ha reported: 'connect_with_timeout 192.168.2.246:0 failed return -3'
2024-11-15T00:44:21.804420-08:00 0 Plugin greatdb_ha reported: 'try to connect or send message to bea16249-a312-11ef-adf7-ac1f6bdb81d2 failed when get node bind message'
2024-11-15T00:44:21.817273-08:00 0 Plugin greatdb_ha reported: 'connect_with_timeout 192.168.2.248:0 failed return -3'
2024-11-15T00:44:21.823532-08:00 0 Plugin greatdb_ha reported: 'connect_with_timeout 192.168.2.248:0 failed return -3'
2024-11-15T00:44:21.823646-08:00 0 Plugin greatdb_ha reported: 'connect_with_timeout 192.168.2.248:0 failed return -3'
2024-11-15T00:44:21.828941-08:00 0 Plugin greatdb_ha reported: 'connect_with_timeout 192.168.2.248:0 failed return -3'
2024-11-15T00:44:21.828961-08:00 0 Plugin greatdb_ha reported: 'try to connect or send message to d154d45e-a312-11ef-ba18-ac1f6bdb815c failed when get node bind message'
2024-11-15T00:44:22.369481-08:00 0 Plugin greatdb_ha reported: 'try to bind vip : 192.168.1.25 success'

yejr 发表于 2024-11-15 17:19:29

切换主节点时的日志也请提供,以及是否有触发VIP切换的动作相关的日志

yejr 发表于 2024-11-16 07:13:51

在GreatSQL 8.0.32-26版本中,配置VIP时,还需要配置 greatdb_ha_port 端口,否则无法正常工作,详情参考 https://greatsql.cn/docs/8.0.32-26/5-enhance/5-2-ha-mgr-vip.html。

此外,看到源主库上没有 unbind 动作,但是在新的目标主库上却有 bind success 的日志,还请确认是否日志没贴完整,还是其他什么情况。

earl86 发表于 2024-11-19 13:38:26

本帖最后由 earl86 于 2024-11-19 13:43 编辑

GreatSQL-8.0.32-26 这个问题 找到原因了, greatdb_ha_port 这个参数 需要配上. 配上后 源主库就可以收到停止vip的消息.源主库
2024-11-18T21:32:29.301178-08:00 271 Plugin group_replication reported: 'Starting group operation local execution: Primary election change'
2024-11-18T21:32:29.302638-08:00 0 Plugin group_replication reported: 'A new primary with address 192.168.2.248:3316 was elected. The new primary will execute all previous group transactions before allowing writes. Enabling conflict detection until the new primary applies all relay logs.'
2024-11-18T21:32:29.303398-08:00 272 Plugin group_replication reported: 'Setting super_read_only=ON.'
2024-11-18T21:32:29.311920-08:00 272 Plugin group_replication reported: 'This server is working as secondary member with primary member address 192.168.2.248:3316.'
2024-11-18T21:32:29.311917-08:00 232 Plugin group_replication reported: 'Primary had applied all relay logs, disabled conflict detection.'
2024-11-18T21:32:29.311980-08:00 271 Plugin group_replication reported: 'Termination of group operation local execution: Primary election change'
2024-11-18T21:32:29.312849-08:00 0 Plugin group_replication reported: 'Configuration operation 'Primary election change' terminated. Primary server switched to: d154d45e-a312-11ef-ba18-ac1f6bdb815c'
2024-11-18T21:32:29.828145-08:00 0 Plugin greatdb_ha reported: 'kill connections binding to vip: 192.168.1.25'
2024-11-18T21:32:29.828216-08:00 0 Plugin greatdb_ha reported: 'try to unbind vip : 192.168.1.25 success'



目标主库
2024-11-18T21:32:29.301072-08:00 226 Plugin group_replication reported: 'Starting group operation local execution: Primary election change'
2024-11-18T21:32:29.302685-08:00 0 Plugin group_replication reported: 'Elected primary member gtid_executed: bea16249-a312-11ef-adf7-ac1f6bdb81d2:1-32, e7895b9b-a31b-11ef-8c27-ac1f6bdb81d2:1-119, e7896234-a31b-11ef-8c27-ac1f6bdb81d2:1-22'
2024-11-18T21:32:29.302747-08:00 0 Plugin group_replication reported: 'Elected primary member applier channel received_transaction_set: bea16249-a312-11ef-adf7-ac1f6bdb81d2:1-32, e7895b9b-a31b-11ef-8c27-ac1f6bdb81d2:1-119, e7896234-a31b-11ef-8c27-ac1f6bdb81d2:1-22'
2024-11-18T21:32:29.302761-08:00 0 Plugin group_replication reported: 'A new primary with address 192.168.2.248:3316 was elected. The new primary will execute all previous group transactions before allowing writes. Enabling conflict detection until the new primary applies all relay logs.'
2024-11-18T21:32:29.303415-08:00 227 Plugin group_replication reported: 'Setting super_read_only=ON.'
2024-11-18T21:32:29.303979-08:00 205 Plugin group_replication reported: 'The member action "mysql_disable_super_read_only_if_primary" for event "AFTER_PRIMARY_ELECTION" with priority "1" will be run.'
2024-11-18T21:32:29.304021-08:00 205 Plugin group_replication reported: 'Setting super_read_only=OFF.'
2024-11-18T21:32:29.304162-08:00 205 Plugin group_replication reported: 'The member action "mysql_start_failover_channels_if_primary" for event "AFTER_PRIMARY_ELECTION" with priority "10" will be run.'
2024-11-18T21:32:29.311926-08:00 227 Plugin group_replication reported: 'This server is working as primary member.'
2024-11-18T21:32:29.311928-08:00 197 Plugin group_replication reported: 'Primary had applied all relay logs, disabled conflict detection.'
2024-11-18T21:32:29.311934-08:00 226 Plugin group_replication reported: 'Termination of group operation local execution: Primary election change'
2024-11-18T21:32:29.312811-08:00 0 Plugin group_replication reported: 'Configuration operation 'Primary election change' terminated. Primary server switched to: d154d45e-a312-11ef-ba18-ac1f6bdb815c'
2024-11-18T21:32:29.827174-08:00 0 Plugin greatdb_ha reported: 'try to bind vip : 192.168.1.25 success'
页: [1]
查看完整版本: GreatSQL-8.0.32-26 单机多实例场景 vip 功能不能切换问题