Itamar Reis Peixoto wrote:
Itamar,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 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
