https://www.infoq.com/news/2023/11/mysql-read-write-splitting/ BT InfoQ Software Architects' Newsletter A monthly overview of things you need to know as an architect or aspiring architects. View an example Enter your e-mail address [ ] [ ] Select your country [Select a country] [ ] I consent to InfoQ.com handling my data as explained in this Privacy Notice. [Subscribe] We protect your privacy. Close Toggle Navigation Facilitating the Spread of Knowledge and Innovation in Professional Software Development English edition * English edition * Chinese edition * Japanese edition * French edition Write for InfoQ Search [ ] [Search] Sign Up / Login Email [ ] Password [ ] [Login] Forgot password ? InfoQ Account Email [ ] [Send Recovery Email] Back to login Resend Activation [ ] [Resend] Back to login Login with: Google Microsoft Twitter Facebook Don't have an InfoQ account? Sign Up Logo - Back to homepage News Articles Presentations Podcasts Guides Topics Development * Java * Kotlin * .Net * C# * Swift * Go * Rust * JavaScript Featured in Development * The Many Facets of "Identity" Radia Perlman describes what aspects of identity and authentication blockchain might address, and compares a "blockchain" approach with what is deployed today. The Many Facets of "Identity" All in development Architecture & Design * Architecture * Enterprise Architecture * Scalability/Performance * Design * Case Studies * Microservices * Service Mesh * Patterns * Security Featured in Architecture & Design * Using Traffic Modeling to Load-Balance Netflix Traffic at Global Scale Niosha Behnam, Sergey Fedorov tell how Netflix has shifted from geo-based DNS load-balancing to a latency-based approach relying on real-user measurements and building a model of Netflix traffic. Using Traffic Modeling to Load-Balance Netflix Traffic at Global Scale All in architecture-design AI, ML & Data Engineering * Big Data * Machine Learning * NoSQL * Database * Data Analytics * Streaming Featured in AI, ML & Data Engineering * PostgresML: Leveraging Postgres as a Vector Database for AI Montana Low provides an understanding of how Postgres can be used as a vector database for AI and how it can be integrated into your existing application stack. PostgresML: Leveraging Postgres as a Vector Database for AI All in ai-ml-data-eng Culture & Methods * Agile * Diversity * Leadership * Lean/Kanban * Personal Growth * Scrum * Sociocracy * Software Craftmanship * Team Collaboration * Testing * UX Featured in Culture & Methods * The Shape of Thoughts: How to Create Visual Templates to Bring Clarity, Context and Change to You and Your Teams! Gemma Honour discusses how simple shapes can shape thinking, and break down difficult problems into something that is manageable and approachable. The Shape of Thoughts: How to Create Visual Templates to Bring Clarity, Context and Change to You and Your Teams! All in culture-methods DevOps * Infrastructure * Continuous Delivery * Automation * Containers * Cloud * Observability Featured in DevOps * From Monitoring to Observability: eBPF Chaos Michael Friedrich discusses the learning steps with eBPF and traditional metrics monitoring and future Observability data collection, storage and visualization. From Monitoring to Observability: eBPF Chaos All in devops EventsNew Helpful links * About InfoQ * InfoQ Editors * Write for InfoQ * About C4Media * Diversity Choose your language * En * Zhong Wen * Ri Ben * Fr [eyJi] InfoQ Live Roundtable Learn practical insights on implementing & sustaining successful platform engineering programs. Register for free with code "PLATFORMENGJAN24". [eyJi] QCon London Discover new ideas and insights from senior practitioners driving change in software. Attend in-person. [eyJi] InfoQ Dev Summit Discover transformative insights to level up your software development decisions. Register now with early bird tickets. [eyJi] QCon San Francisco Level up your software skills by uncovering the emerging trends you should focus on. Register now. InfoQ Homepage News MySQL 8.2 Introduces Transparent Read/Write Splitting AI, ML & Data Engineering MySQL 8.2 Introduces Transparent Read/Write Splitting This item in japanese Like Print Bookmarks Nov 11, 2023 2 min read by * Renato Losio Write for InfoQ Join a community of experts. Increase your visibility. Grow your career.Learn more Oracle has recently announced the general availability of MySQL 8.2, which includes support for Read/Write Splitting. This long-awaited feature has been introduced in the latest innovation release and helps optimize database performance and scalability. Read-write splitting enables applications to direct transparently all write traffic to read-write (primaries or sources) instances and all read traffic to read-only instances, the instances that are secondaries in an InnoDB Cluster or the primary or secondary instances in a Replica Cluster. Frederic Descamps, MySQL community manager, explains: At scale, we distribute reads between replica(s), but this has to be managed somehow in the application: pointing writes somewhere and reads somewhere else. With MySQL 8.2, MySQL Router is now able to identify reads and writes and route them to Primary Instances in the case of an InnoDB Cluster, or to an asynchronous replication source for the writes and to secondary instances or replicas for the reads. Using read-write splitting, each client session can communicate with one read_write and one read_only destination, and the router classifies each query as read or write and directs it to the appropriate backend. Peter Zaitsev, founder at Percona and open source advocate, comments: Great MySQL 8.2 feature! What is not clear though is what, if any consistency level is guaranteed for reads in this case. Can you read stale data? If yes how stale? Connecting to MySQL using the Read/Write Port (by default, 6450), connections will reach the replica (secondary) if they do a read, but they will reach the replication source (primary) if they start a transaction. [1Medium-16] Source: MySQL documentation The new feature has generally been appreciated by the community, but Sunny Bains, software architect at PingCAP, comments: MySQL Group Replication provides timeline consistency, the router can't do better than that unless the router can track the consistency across the replica, seems doable but it will require either a round trip via polling or some type of event notification from the cluster to the router. Descamps concludes: This is a valuable feature for optimizing database performance and scalability without having to make any changes in the application. (...) This feature not only enhances the overall user experience but also simplifies database management and deployment. Earlier this year, Oracle changed the versioning model for MySQL, introducing the innovation and LTS releases. MySQL 8.2.0 is the latest quarterly innovation release and includes bug fixes, security patches, and new features: the improvements include hash table optimization for set operations, enhancements for MySQL Enterprise Firewall, and a new WebAuthn authentication method to support devices such as smart cards, security keys, and biometric readers. MySQL 8.2.0 is generally available and can be downloaded from the Oracle website. About the Author Renato Losio Show moreShow less Rate this Article Adoption ( ) ( ) ( ) ( ) ( ) Style ( ) ( ) ( ) ( ) ( ) [ ] [Submit] [ ] [Submit] [ ] Author Contacted This content is in the AI, ML & Data Engineering topic Related Topics: * Development * AI, ML & Data Engineering * MySQL * SQL * Relational Databases * Database Replication * Database * Cloud * Related Editorial * Related Sponsored Content * Popular across InfoQ + Spring Boot 3.2 Delivers Support for Virtual Threads and Modern RestClient and JdbcClient + 12 Software Architecture Pitfalls and How to Avoid Them + Microsoft Announces Git Partial Clone Support in Azure DevOps + Google Launches New Multi-Modal Gemini AI Model + Java News Roundup: JDK 22 in Rampdown, JDK 23 Expert Group, Spring Cloud 2023.0, TornadoVM 1.0 + Solomon Hykes Discusses Dagger, DevOps, and Docker Related Content The InfoQ Newsletter A round-up of last week's content on InfoQ sent out every Tuesday. Join a community of over 250,000 senior developers. View an example Enter your e-mail address [ ] [ ] Select your country [Select a country] [ ] I consent to InfoQ.com handling my data as explained in this Privacy Notice. [Subscribe] We protect your privacy. Hello stranger! You need to Register an InfoQ account or Login or login to post comments. But there's so much more behind being registered. Get the most out of the InfoQ experience. Tell us what you think [ ] [ ] Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p [ ] Email me replies to any of my messages in this thread [Post Message] Community comments Watch thread Close Your Reply Quote original message [ ] [ ] Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p [ ] Email me replies to any of my messages in this thread [Post Message] Cancel Close Your Reply [ ] [ ] Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p [ ] Email me replies to any of my messages in this thread [Post Message] Cancel Close OK Discuss * Development + JetBrains Launches AI Assistant Integrated in its 2023.3 Release IDEs + Ngrok JavaScript and Python SDKs Aim to Turn Ingress into a High-Level Abstraction + Microsoft Open-Sources ThreadX and the Azure RTOS Development Suite * Architecture & Design + Using Traffic Modeling to Load-Balance Netflix Traffic at Global Scale + 12 Software Architecture Pitfalls and How to Avoid Them + Solomon Hykes Discusses Dagger, DevOps, and Docker * Culture & Methods + The Shape of Thoughts: How to Create Visual Templates to Bring Clarity, Context and Change to You and Your Teams! + Developer Experience for the 99% + Why Leading without Blame Matters to Leaders and Teams * AI, ML & Data Engineering + Apple Open-sources Apple Silicon-Optimized Machine Learning Framework MLX + Meta and IBM Lead Formation of AI Alliance to Drive Open-Source Innovation + Microsoft's Orca 2 LLM Outperforms Models That Are 10x Larger * DevOps + AWS Improves Kubernetes Monitoring with New Enhanced Observability for Amazon EKS + Microsoft Announces Copilot for Azure, an AI Assistant for IT Professionals + HashiCorp Terraform Cloud Operator for Kubernetes Improves Scalability and Performance The InfoQ Newsletter A round-up of last week's content on InfoQ sent out every Tuesday. Join a community of over 250,000 senior developers. View an example * Get a quick overview of content published on a variety of innovator and early adopter technologies * Learn what you don't know that you don't know * Stay up to date with the latest information from the topics you are interested in Enter your e-mail address [ ] [ ] Select your country [Select a country] [ ] I consent to InfoQ.com handling my data as explained in this Privacy Notice. [Subscribe] We protect your privacy. April 8-10, 2024 Real-world technical talks. No product pitches. Practical ideas to inspire you and your team. QCon London International Software Development Conference returns on April 8-10, 2024. Level-up on 15 major software and leadership topics including; The Tech of FinTech, What's Next in GenAI and Large Language Models (LLMs), Performance Engineering, Architecture for the Age of AI, Innovations in Data Engineering and more. Learn the emerging trends. Explore the use cases. Implement the best practices. SAVE YOUR SPOT NOW Home Create account Login QCon Conferences Events Write for InfoQ InfoQ Editors About InfoQ About C4Media Media Kit InfoQ Developer Marketing Blog Diversity Events * InfoQ Live JANUARY 23, 2024 * QCon London APRIL 8-10, 2024 * QCon San Francisco NOVEMBER 18-22, 2024 Follow us on Youtube223K Followers Linkedin21K Followers RSS19K Readers X53.4k Followers Facebook21K Likes AlexaNew Stay in the know The InfoQ PodcastThe InfoQ Podcast Engineering Culture Podcast Engineering Culture Podcast The Software Architects' NewsletterThe Software Architects' Newsletter General Feedback feedback@infoq.com Advertising sales@infoq.com Editorial editors@infoq.com Marketing marketing@infoq.com InfoQ.com and all content copyright (c) 2006-2023 C4Media Inc. Privacy Notice, Terms And Conditions, Cookie Policy BT *