Solved

MySQL cluster or master/slave

Posted on 2011-09-16
2
523 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Accepted Solution

by:
maeltar earned 250 total points
ID: 36553173
0
 
LVL 8

Assisted Solution

by:wolfgang_93
wolfgang_93 earned 250 total points
ID: 36554892
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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

696 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