Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bwwilliams

  1. bwwilliams

    MySQL Clustering

    I set this up as a master-master system with IP failover. Both servers are more than capable of doing inserts and selects, but I'm giving the virtual IP to our developers so they can only talk to the acting master. I'm using the heartbeat utility to do the IP failover, and you can set whether it...
  2. bwwilliams

    MySQL Clustering

    This is one of the ideas I pitched as a solution, and management didn't like that either server could be used to write to the database, even if we give the developers a virtual IP that floats between the servers. I see this as being the ideal solution, so I'll try to get buyoff again. Thanks for...
  3. bwwilliams

    MySQL Clustering

    I'm assuming you use a virtual IP for your masters. Is there a way to prevent the backup master from accepting inserts unless the primary is offline?
  4. bwwilliams

    MySQL Clustering

    Thanks for the info. Sounds like I have my work cut out for me regardless. :)
  5. bwwilliams

    MySQL Clustering

    The headache is what I am trying to avoid. I thought about two way mirroring, but that's another headache waiting to happen.
  6. bwwilliams

    MySQL Clustering

    So how does one typically handle the situation if the master goes down? Doesn't that take away the ability to write to the databse?
  7. bwwilliams

    MySQL Clustering

    I've been reading that MySQL clustering using shared disk is a bad thing. Some of what I have read referrs specifically to NFS mounts being bad. I was considering using a SCSI attached array shared between two servers for storing the databases. Is this considered to be a no-no?
See more

Part and Inventory Search

Back
Top