{"data":{"id":"ACSD-56226","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where READ queries at the slave node return outdated data when the 'synchronous_replication' flag is enabled.","categories":["Performance","Other"],"components":["magento/module-catalog-permissions","magento/module-resource-connections"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-69/acsd-56226-read-queries-return-outdated-data-with-synchronous-replication-enabled","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-69/acsd-56226-read-queries-return-outdated-data-with-synchronous-replication-enabled.md","blobSha":"7769c6bb2f0cfe9836dc4a74813a7e8832787cba","description":"READ queries return outdated data when the synchronous_replication flag is enabled. This causes the slave connection to be disabled, leading to database overload.","stepsToReproduce":"1. Set MYSQL_USE_SLAVE_CONNECTION to true in the environment variables on Adobe Commerce on cloud infrastructure. 1. Add the following configuration to .magento.env.yaml to set synchronous_replication to false: DATABASE_CONFIGURATION: _merge: true slave_connection: default: synchronous_replication: false 1. Redeploy and perform frontend actions such as login, add to cart, or place an order.","introducedInQpt":"1.1.69","createdFor":["2.4.6-p2"],"documentedRange":"2.4.6 - 2.4.6-p11","scheduledFixRelease":"2.4.7"},"files":[{"package":"magento/magento2-ee-base","constraint":">=2.4.6 <2.4.7","path":"patches/commerce/ACSD-56226_2.4.6-p2.patch","blobSha":"4d2784734a277e517a56eced8b0c9d814b803d3b","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/commerce/ACSD-56226_2.4.6-p2.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-catalog-permissions/etc/di.xml","change":"modified","package":"magento/module-catalog-permissions"},{"path":"vendor/magento/module-resource-connections/DB/Adapter/Pdo/MysqlProxy.php","change":"modified","package":"magento/module-resource-connections"}],"packages":["magento/module-catalog-permissions","magento/module-resource-connections"],"hasTests":false,"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":[],"magento-commerce":["2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-56226 details"}