topic MySQL Replication NetApp and NFS in Network and Storage Protocols https://community.netapp.com/t5/Network-and-Storage-Protocols/MySQL-Replication-NetApp-and-NFS/m-p/66520#M6064 <HTML><HEAD></HEAD><BODY><P>We're currently setting up a new MySQL 5.5 replicated database using NFS mounts for the database.&nbsp; 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.&nbsp; My question is regarding NFS.&nbsp; 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"?&nbsp; 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.</P><P></P><P>Thanks!!</P></BODY></HTML> Thu, 05 Jun 2025 06:55:01 GMT MIKEA0730 2025-06-05T06:55:01Z MySQL Replication NetApp and NFS https://community.netapp.com/t5/Network-and-Storage-Protocols/MySQL-Replication-NetApp-and-NFS/m-p/66520#M6064 <HTML><HEAD></HEAD><BODY><P>We're currently setting up a new MySQL 5.5 replicated database using NFS mounts for the database.&nbsp; 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.&nbsp; My question is regarding NFS.&nbsp; 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"?&nbsp; 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.</P><P></P><P>Thanks!!</P></BODY></HTML> Thu, 05 Jun 2025 06:55:01 GMT https://community.netapp.com/t5/Network-and-Storage-Protocols/MySQL-Replication-NetApp-and-NFS/m-p/66520#M6064 MIKEA0730 2025-06-05T06:55:01Z Re: MySQL Replication NetApp and NFS https://community.netapp.com/t5/Network-and-Storage-Protocols/MySQL-Replication-NetApp-and-NFS/m-p/66524#M6065 <HTML><HEAD></HEAD><BODY><P>Hey Mike, I'm keen to know which settings you came up with? Or maybe you didn't go any further with NFS?</P><P></P><P>Cheers,</P><P>Vladimir</P></BODY></HTML> Fri, 25 May 2012 21:03:57 GMT https://community.netapp.com/t5/Network-and-Storage-Protocols/MySQL-Replication-NetApp-and-NFS/m-p/66524#M6065 vladimirzhigulin 2012-05-25T21:03:57Z