Solved

MySQL cluster or master/slave

Posted on 2011-09-16
2
521 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

735 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