Solved

MySQL cluster or master/slave

Posted on 2011-09-16
2
510 Views
Last Modified: 2012-05-12
I have two servers that I want to put mysql-cluster on.  I have an application load balancer that will point to both of the servers so I don't need another server just for load balancing.

I also have another site that connects through a vpn tunnel that has one mysql server.  Is there a config that I can do to make this work with replication?

Can someone send me a how-to that covers what I've said?  I will test everything in a virtual environment first.

I'm on CentOS 5.6 servers. Will 32bit and 64bit be a problem? The main mysql server is 64bit and the other cluster server is 32bit.  Not sure if that will be a problem.
0
Comment
Question by:jasonslogan
2 Comments
 
LVL 11

Accepted Solution

by:
maeltar earned 250 total points
Comment Utility
0
 
LVL 8

Assisted Solution

by:wolfgang_93
wolfgang_93 earned 250 total points
Comment Utility
It is not reasonable to install MySQL cluster on just 2 servers.

As stated here
http://www.mysql.com/products/cluster/faq.html

Q: How many physical servers are needed to create a minimum Cluster configuration?

A: The recommendation for good redundancy would be 2 MySQL Server Nodes, 2 Data Nodes and 1 Management Node. For evaluation purposes it is possible to have only a single physical server, but that would only serve as a very basic evaluation. The minimum fully fault tolerant solution would consist of 3 servers with the 2 data nodes and the management node all running on different hosts and with at least 2 MySQL Server nodes running on different hosts from each other.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now