Re: Mysql 5.1.36 cluster - does anybody have this working?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Itamar Reis Peixoto wrote:
I can recommend you mysql master-slave replication

or postgresql with bucardo (2 master's, and more n slaves)




On Thu, Aug 20, 2009 at 10:13 AM, Howard Wilkinson<howard@xxxxxxxxxxx> wrote:
  
  I have upgraded from FC9 through FC10 to FC11 but the cluster code
available with FC11 is refusing to start up properly. Does anybody have this
working? If so was there any magic incantations used to get the database
gods to cooperate?

Regards, Howard.

    


  
Itamar,

I already use the master-slave replication for some of our higher volume databases - although this in itself brings in problems when things get out of step.

But I use the cluster storage for our smaller configuration databases, including the backend to a replciated MyDNS environment. This has worked wonderfully with the 5.0.x series of MySQL but in upgrading to 5.1.36 a number of problems arose.

When I sent out the message I still had part of the cluster running 5.0.x storage, and the new Cluster nodes were refusing to come up. I finally fixed this by altering the parameters to allow the 5.0.x nodes to start under control of the 5.1.36 NDB_MGMD instances (Options that had reasonable defaults for .5.0.x do not if they are provided by a 5.1.36 arbitrator) once these old nodes started I got a sensible error message from the 5.1.36 NDBD nodes - they told me that the cluster version were incompatible - it seems you need to upgrade to an early 5.1.x cluster first and then go through 5.1.20 (or 5.1.21 or something thereabouts) and the jump to 5.1.36 to do a hot upgrade, and even then I have found little evidence of anybody doing it.

So what I did instead was to shutdown the 5.0.x NDB stores, destroy the NDB store on the 5.1.36 nodes, start these nodes with the --initial-state --nowait-nodes arguments and rebuilding the NDB store from our backups. I could then upgrade the 5.0.x nodes knowing that I had a working store and like magic everything burts into life when I brought up the quorum.

So the lesson learnt is that you cannot jump major versions using the upgrade paths suggested by MySQL unless you track their upgrade steps - even then I am not sure it would be easy. They use different database gods with each major release :-[

Regards, Howard.

-- 
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
Guidelines: http://fedoraproject.org/wiki/Communicate/MailingListGuidelines
[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux