Virtual Meetup: 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.
We will start at 6 PM London time: https://global.gotomeeting.com/join/427853781
Agenda
6 PM - Introductions (agenda, online raffle announcement)
6:10 - 6:40 - Talk 1
6:40 - 7:00 Q&A for Talk 1
7:00 - 7:10 Break (we can show time countdown and survey link)
7:10 - 8:00 Talk 2
8:00 - 8:20 Q&A for Talk 2
8:20 - Closing remarks.
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.
Join In-Memory Computing Meetup Groups in London and Paris to keep in touch.
VP, Developer Relations in R&D at GridGain; Apache Ignite committer and PMC member
ProxySQL Founder