Personal blog of Yzmir Ramirez

I’m looking forward to next week’s MySQL webinar with Robert Hodges, CEO of Continuent. We’ll be speaking on the topic “Multi-Data Center MySQL with Continuent Tungsten.”

You’re not alone if you’ve been vexed when trying to assemble multi-master, multi-site MySQL clusters. Whether that was a move from a single database server to a scalable cluster, or from a brittle MySQL replication system to a transparent, manageable database cluster.

We’ve all been there at one point or another in our careers. So learn from our experience. In our joint webinar next week (Dec. 11), Robert and I will address these issues so you’ll be successful faster.

We’ll start by discussing the read-write splitting functionality of the Tungsten Connector and then show you the multi-data center capabilities of Continuent Tungsten. To illustrate things, we’ll set up 9 cluster nodes in 3 different data centers and demonstrate various failure scenarios – all while traffic is running!

We’ll see what happens when:

* One of the nodes goes down
* Two of the nodes go down
* One of the data centers goes down
* Two of the data centers go down

At the end of this webinar you will know how to quickly configure and provision highly optimized Continuent Tungsten deployments in the cloud or on-premise.

Have I piqued your attention? Good. Then join us Dec. 11 at 10 a.m. Pacific Standard Time. You can register here to reserve your spot. We’ll be fielding questions afterward, but I welcome questions in advance here in the comments section. I’ll answer them here but we can also address some of them, time permitting, next Wednesday, too. See you then.

The post Multi-Data Center MySQL with Continuent Tungsten: Dec. 11 webinar appeared first on MySQL Performance Blog.

Really Large Queries: Advanced Optimization Techniques: Wednesday, February 27, 2013 10 a.m. PST

Do you have a query you never dared to touch?
Do you know it’s bad, but it’s needed?
Does it fit your screen?
Does it really have to be that expensive?
Do you want to do something about it?

During the next Percona webinar on February 27, I will present some techniques that can be useful when troubleshooting such queries. We will go through case studies (each case study is made from multiple real-world cases). In these cases we were often able to reduce query execution time from 10s of seconds to a fraction of a second.

More info:
Imagine a query that barely fits your monitor screen such as a 7 table join. In this webinar, we will discuss filling the gap between reading explain output and optimizing really large queries. Practical techniques used to address real-world situations will be shared, while pointing out common mistakes organizations often make. The talk will cover topics including:

• How to start optimizing large queries
• The use of denormalization
• The effect of join order

Interested? Register here.

The post Percona MySQL Webinar: Really Large Queries: Advanced Optimization Techniques, Feb. 27 appeared first on MySQL Performance Blog.