Solved

MySQL cluster or master/slave

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Access - need to reduce row size 25 78
SELECT query on two levels (detail and summary) 13 69
Present Absent from working date rage 11 56
phpmyadmin memory error 55 92
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
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…

734 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