Network and Storage Protocols

MySQL Replication NetApp and NFS


We're currently setting up a new MySQL 5.5 replicated database using NFS mounts for the database.  The standard configuration for MySQL replication includes setting "innodb_flush_log_at_trx_commit=1" and "sync_binlogs=1" to make sure database updates are saved and replicated properly in the case of a server crash, or power outage.  My question is regarding NFS.  If we store the databases for the replicated servers on NetApp NFS mounts, are we still guaranteed that the updates are saved properly even with "innodb_flush_log_at_trx_commit=1" and "sync_binlogs=1"?  I've read two NetApp documents "Best Practices Guidelines for MySQL" and "MySQL 5.0 Performance Protocol Comparision", but there is nothing I can find that talks specifically about NFS and MySQL Replication.




Hey Mike, I'm keen to know which settings you came up with? Or maybe you didn't go any further with NFS?



Register for Insight 2021 Digital

INSIGHT 2021 Digital: Meet the Specialists 2

On October 20-22, gear up for a fully digital, totally immersive virtual experience with a downright legendary lineup of world-renowned specialists. Tune in for visionary conversations, solution deep dives, technical sessions and more.

NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner