MySQL Best Practices for High Performance, Scalability & High Availability

A high-performance MySQL proxy for MySQL, MariaDB, Amazon Aurora / RDS and other forks. 100% open source. Contact us for 24/7 Support, DBRE, Consulting & more!

ProxySQL Inc.

This free online meetup is intended for the community of MySQL users willing  to manage the growing workloads & unexpected traffic peaks.

Link for last minute registrants: https://global.gotomeeting.com/join/427853781This free online meetup is for MySQL users looking to effectively manage growing workloads, unexpected traffic peaks and demanding business requirements such as high availability with maximum possible uptime for the application. Given the current environment with numerous users working from home, we will provide timely recommendations to our fellow MySQL DBAs on how to better configure and manage MySQL clusters at scale.<h2>Agenda</h2>6 PM - Welcome &amp; raffle announcement.6:10 - 6:40 - Talk 1. &quot;Adding Speed and Scale to MySQL Deployments with In-Memory Computing&quot; - Denis Magda (Gridgain Systems)6:40 - 7:00 - Q&amp;A session with Denis.7:00 - 7:10 - Break, opensource database survey7:10 - 8:00 - Talk 2. &quot;Ensuring MySQL High Availability at Scale&quot; - René Cannaò (ProxySQL)8:00 - 8:20 - Q&amp;A session with René.8:20 - Closing remarks.<h2>Detailed talk abstracts</h2><h3>Adding Speed and Scale to MySQL Deployments with In-Memory Computing</h3>Learn how software architects use in-memory computing technologies to add speed and scale to existing MySQL deployments. You will see how to deploy a distributed in-memory cluster on top of a MySQL database, how to configure the cluster to write-through all the changes to the database, and how to boost SQL operations by querying in-memory data sets.We’re going to use Apache Ignite in-memory computing platform as a reference platform for concepts breakdown and demo needs.<h3>René Cannaò - Ensuring MySQL High Availability at Scale</h3>High availability means that your data is properly replicated with its consistency and security in mind. Modern HA solutions also come with built-in failover scenarios. Clustering solutions for MySQL like Galera or Group Replication provide virtual synchronous replication. High availability is ensured on the database level yet the app isn’t aware of the best options for traffic routing (it may go to overloaded nodes which affects performance at scale).ProxySQL is a high-performance protocol-aware proxy for MySQL which can balance your traffic load between the nodes of the cluster based on their current status. Serving as the middle layer between the application and MySQL clustering solutions from various vendors, ProxySQL can ensure HA even under the conditions of cluster degradation.<h2>About the speakers</h2>Denis Magda is an open-source enthusiast who started his journey in Sun Microsystems as a developer advocate and presently settled down at Apache Software Foundation in the roles of Apache Ignite committer and PMC member. He is an expert in distributed systems and platforms who actively contributes to Apache Ignite and helps companies and individuals deploy it for mission-critical applications. You can be sure to come across Denis at conferences, workshops and other events sharing his knowledge about the open-source, community building, distributed systems. René Cannaò is the CEO of ProxySQL Inc and author of ProxySQL. He has nearly two decades of working experience as a system, network and database administrator mainly on Linux/Unix platforms. Since 2008, his career has been focused on MySQL, having worked as a Senior MySQL Support Engineer at Sun Microsystems/Oracle, as an operational DBA and Lead Engineer at Blackbird IT (formerly PalominoDB), and has consulted for companies like Dropbox. During these periods he built an analytic and problem solving mindset, thus is always eager to take on new challenges, especially if they are related to high performance. Apart from managing the overall operations and resources of the company René directly manages the ProxySQL Engineering team and is heavily involved in the development of ProxySQL.Note. Both ProxySQL and Gridgain Systems are the organizers of this online event.

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

MySQL Best Practices for High Performance, Scalability & High Availability

More events from ProxySQL Inc.

Discover more events from ProxySQL Inc., from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

MySQL Best Practices for High Performance, Scalability & High Availability

More events from ProxySQL Inc.

Discover more events from ProxySQL Inc., from Science & Tech to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.