It's a desktop PC running Windows 10. It's on most of the time, but I was playing.
I don't remember the steps I did to get the MASTER/SLAVE replication going, other than step by step having to learn what everything meant. Here are a few tips: If you are running mysql on a Raspberry Pi or any other computer with only one network interface, you don't have to bind MySQL to any ip address. Just comment that out. I switched from the ethernet port to wifi, which changed the ip address, and suddenly it was unable to connect to the database. Make sure MySQL allows remote access. if the slave can't connect, it won't work. Schema is a synonym for database. Then just type everything in the way it says in the instructions. You'll need to create an account on the master (where weewx is running), but it only needs access to the weewx schema. The instructions are very clear about what to do, but they aren't good at explaing to a novice what's going on. First, you turn on logging on the master. Then you pause the master. Then you get the offset into the log file. Then you mysqldump the database out. Then you import it into the slave mysql. Then you tell the slave who the master is, what the name of the log file is, and what the offset is. Then you unpause the master, and boom. Oh, the last thing I forgot was to restart mySQL on my computer. Then it started copying the data over. On Tuesday, February 28, 2017 at 8:34:12 PM UTC-5, [email protected] wrote: > > Am I right in thinking your main Windows PC is a laptop? Would be great if > you wrote up step by step instructions for anything not already documented > -- the stuff you had to Google (the Master Slave stuff esp). > > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
