MySQL Best Practices for High Performance, Scalability and High Availability

This free virtual 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.

Registration: https://www.eventbrite.com/e/mysql-best-practices-for-high-performance-scalability-high-availability-tickets-101057983148

AGENDA
6 PM - Introductions
6:10 - 6:40 - Talk 1
6:40 - 7:00 Q&A for Talk 1
7:00 - 7:10 Break
7:10 - 8:00 Talk 2
8:00 - 8:20 Q&A for Talk 2
8:20 - Closing remarks, raffle

Denis Magda - Adding Speed and Scale to MySQL Deployments With In-Memory Computing

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.

René Cannaò - Ensuring MySQL High Availability at Scale

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.

SPEAKERS

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ò founded ProxySQL LLC. in 2016 after developing the same-name open source proxy for MySQL in 2013. Rene has over 15 years of DBA experience, mostly with MySQL. He spent years working as Senior MySQL Support Engineer at Sun/Oracle, Senior Operational DBA at Blackbird, and database consultant for small and large companies like Dropbox. Throughout this period Rene has built an analytic and problem-solving mindset, and he is always eager to take on new challenges, especially if they are related to high performance.

Registration: https://www.eventbrite.com/e/mysql-best-practices-for-high-performance-scalability-high-availability-tickets-101057983148