Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.
Personally I would not advise using clustering. It is not a magic bullet replacement for standard MySql, it works in a very different way. From my understanding, MySql cluster is more like a giant hash-table. As such, it's very bad at any range query (WHERE BETWEEN, or WHERE >, sort of thing), but very good at single record hits. Replication is a very good way of balancing, if your database is more than 50% reading rather than writing. Other than that, you'll need to look at some form of partitioning... I use drbd with two resources, one for each of two MySql partitions. Therefore having an Primary/Secondary, Secondary/Primary setup. Then use Linux-ha to move the MySql from server to server in event of a server loss. Hope this is some use :) Ben Pierguido wrote: > Oliver Welter wrote: >> I dont know much about primary/primary but I guess it has something to >> do with locking and seeking. >> Why dont you use mysql replication ? I have it running here on a cluster >> and it works. > Sure it works, but i shiuld change many things in my company > applications to use both of them, that i'd like something else. > Actually i'd like to use both nodes in the cluster to load balance the > workload...this is my main problem. > > Pier > _______________________________________________ > drbd-user mailing list > drbd-user at lists.linbit.com > http://lists.linbit.com/mailman/listinfo/drbd-user > ************************************************************************* This e-mail is confidential and may be legally privileged. It is intended solely for the use of the individual(s) to whom it is addressed. Any content in this message is not necessarily a view or statement from Road Tech Computer Systems Limited but is that of the individual sender. If you are not the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. We use reasonable endeavours to virus scan all e-mails leaving the company but no warranty is given that this e-mail and any attachments are virus free. You should undertake your own virus checking. The right to monitor e-mail communications through our networks is reserved by us Road Tech Computer Systems Ltd. Shenley Hall, Rectory Lane, Shenley, Radlett, Hertfordshire, WD7 9AN. - VAT Registration No GB 449 3582 17 Registered in England No: 02017435, Registered Address: Charter Court, Midland Road, Hemel Hempstead, Hertfordshire, HP2 5GE. *************************************************************************