[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MySQL cluster or master/slave

Posted on 2011-09-16
2
Medium Priority
?
531 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 1000 total points
ID: 36553173
0
 
LVL 8

Assisted Solution

by:wolfgang_93
wolfgang_93 earned 1000 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

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month18 days, 4 hours left to enroll

830 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