Scaling MySQL: Catch 22 of Read-Write Splitting | January 17, 2013 2:00pm EST
This webinar will examine the benefits of Read-Write splitting. To register, click here.
![]()
There are thousands of new online and mobile apps launching every day…but what happens when demand climbs for these apps and databases can’t keep up? The long-term success of any app hangs on a company’s ability to provide uninterrupted access and availability – translation: Database performance and scalability.
Read write splitting is a great way to scale out your database. Just use a replicated cluster (master(s), slaves), those are commodity shared nothing database servers, and distribute sessions workload across them, and gain increasing throughput, and better resource utilization where replication slaves can be used to offload read activity from the master database. It’s simple to understand and simple to deploy.
This webinar will explore the secrets, dos and don’ts, benefits and caveats behind R/W Splitting. We’ll discuss the following:
- What are the principles for R/W Splitting in a way to ensure as even session distribution as possible across servers.
- Can write-mostly application scale with R/W Splitting? Absolutely! See how.
- Can I also gain performance increase in addition to scaling my throughput? Absolutely! See how.
- Replication lag and “reads after writes”. How those can be overcome?
We’ll cover how ScaleBase provides transparent data distribution to its clients, overcoming caveats, hiding the complexity involved in data distribution, and making it transparent to the application. ScaleBase is specifically designed to scale next generation applications without requiring any changes to the existing infrastructure. Below please find our series of webinars addressing these topics:
(Completed) Aug 16 & Sept 20: Scaling MySQL: ScaleUp versus Scale Out: This webinar will examine best practices around scaling MySQL databases
(Completed) October 23: Methods and challenges to Scale out a database
(Completed) December 13: Automated data distribution and parallelization
THIS WEBINAR (Completed): January 17: Catch 22 of read-write splitting
Please join us as Doron Levari, the CTO of ScaleBase discusses the benefits of automatic data distribution. Doron is a long-time veteran of the database industry. He has extensive experience in building and scaling-out database systems. Doron is also the publisher of the Database Scalability Blog, where he enjoys discussing challenging database scalability issues such as big data, throughput, complexity, virtualization and global distribution.




Leave a Reply
Want to join the discussion?Feel free to contribute!