I was at an event recently and the topic of replication stirred the curiosity of the audience. A few audience members had Master to Master but they wanted to move away from that. Others had multiple slaves but wanted little downtime and backend work if a master failed. Relayed replication or a database chain is an option to solve some of their issues. Another option would be Cluster but it depends on your infrastructure, budget and application, some of them are looking into this as well.  Is a chain the best solution for everyone, of course not. While I cannot do consultant work to help them, I can blog about it…

      A relayed replication environment allows you to, of course, have replicated databases but also have a replication environment that is still available if or when the master …

How do you know that your code is fast? Is it fast for your test cases or is it fast for every case? When changes are made how does that affect your customers? How do you know over a period of time if the system is faster or slower.

The same stat system which is used to track new installs, viral clicks, impressions, rates,  funnels, page flows, gauges, counters, etc is also used to let me know how fast code blocks are performing. How is this done?

Since a Front Controller Design Pattern is used for my AJAX calls, I am able to wrap all calls in time deltas to produce a centralized stat on how fast all service calls are taking. So, each code change that is pushed; I can see if that code change slowed something down, or broke something all together.

Here is the setup. Each Service Call Response Time is placed into buckets; less than 200ms, 201ms to 500ms, 501ms to 1 second, 1.001 second to 2 seconds and …

Detecting conflicts

Part of the latest MySQL Cluster Development Milestone Release (MySQL Cluster 7.2.1 – select the “Development Release” tab at http://dev.mysql.com/downloads/cluster/#downloads) is a couple of enhancements to the conflict detection and resolution mechanism for active-active (multi-master) replication. While MySQL Cluster has had conflict detection for years it has now been made much more complete and a lot easier to use:

• No changes needed to the application schema
• Entire conflicting transaction is rolled back together with any dependent transactions

The focus of this post will be to step through how to use this feature – while it will also attempt to explain how it works at …

I was glad to present how to schedule and monitor mysqldump with ZRM community last week in Paris as part of the MySQL Meetup Viadeo / LeMUG

You can find my slides below, enjoy ! :

MYSQLDUMP & ZRM COMMUNITY (EN) View more presentations from Cédric PEINTRE Thanks to Olivier and all the viadeo team in Paris for this event.
And, of course, thanks to all attendees. We need more events like that in France ! Related Posts :

• Slides from MySQL Conference 2012 (Aka Percona …

Hi Folks,

Just another quick update.

I've been working really hard these past couple of weeks on getting what I'm hoping is some great documentation happening for XtraBackup Manager.

There is still more work to be done, but I'm really pleased with how it's coming along.

Stay tuned… awesome things are coming :)

Meanwhile, to those of you who celebrate Thanksgiving this week -- have a safe and happy holiday, however you choose to spend it!

Cheers,
Lachlan

Register now for the MySQL Tech Tour Event – Montreal.

Please join us for our first Canadian MySQL Tech Tour event event hosted by Oracle MySQL experts and learn more about Oracle’s strategy for MySQL, including continued investment in the world’s most popular open source database. Register for either Session 1 or Session 2 of this Tech Tour Event.

The MySQL experts will be on hand to introduce new features in the MySQL 5.5 GA release; provide details on MySQL 5.6.; and discuss the new commercial extensions – MySQL Thread Pool (performance), MySQL Security (authentication) and MySQL HA. Finally, our MySQL Experts will cover the integration of MySQL into the Oracle environment, and NoSQL access methods through MySQL.

Register for any of our sessions and learn about: …

Following a heavy schedule in the last month speaking in Tokyo, Beijing, Manila and Auckland it is nice to be on home soil for upcoming speaking. I will be in Denver, Colorado for RMOUG 2012 from February 14-16, 2012 where I will be speaking about the essentials of MySQL security.

I hope to also organize another presentation in the area for the local MySQL users group. More to follow.

And a friendly reminder, the annual MySQL conference is on again, same place (Santa Clara), same dates …

Five 9s or 99.999% availability is a popular term describing the highest service up-time in a year meaning the highest practical level of availability for most organizations. Its very hard to achieve five 9s in a database environment and needs plenty of hand-holding techniques. But Schooner’s approach and its replication flexibility have made this requirement easily achievable.
We have published a white paper called "Achieving five 9s with SchoonerSQL".  This white paper describes the architecture of SchoonerSQL™, a full HA build of MySQL and its standard InnoDB storage engine. This paper then explains how to use the flexible synchronous and asynchronous replication modes in SchoonerSQL to get five nines availability. The paper then describes  the recommended HA hardware setup for using SchoonerSQL.
You can download the detailed white paper from the link below
…

A third built-in extension point for MySQL Connector/J is the ExceptionInterceptor interface.  This is the third extension point covered in my recent JavaOne and Silicon Valley Code Camp presentations, and is very useful for diagnosing specific Exceptions encountered without modifying application-side code. This corresponds to slide #60 in my slide deck, and there are two Java files we’ll reference from my demo code:

• demo.connectorj.ExceptionInterceptorExample
• demo.connectork.plugins.ExampleExceptionInterceptor

To …

Ever hear of Red Hat Enterprise Linux 6.0? It was released on November the 10th of 2010 . . just over a year ago. In the last couple of days Oracle released the latest version of MySQL Server (5.5.18). Along with the bug fixes, etc they released RPM packages that cover RH EL 6.

Finally. A year later.

Not one given to griping, but really..does it take that long to roll packages for the new version? There were no significant changes in the operating system..in fact the RH EL 5 packages worked on RHEL 6 from my (albeit) limited experience with the combination.

I don't jump onto new versions of operating systems as soon as they come out. I prefer to let others be my beta testers before I put something into production. However, waiting a year seems a bit extreme for this release.

Even so, it's out now so enjoy! Now we have no excuse for not deploying 5.5.

km

…