product evaluation of MariaDB and MySQL cluster community edition .

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

hi,

"There are plenty of step-by-step guides written you can follow:"

how about MySQL cluster ? any really 100% step by step and WILL Work installation guide ? I am focusing on community edition only !

MySQL cluster has community edition free to test with very less data, right?

"1. How many redhat linux nodes on testing each of this? >> Use 3"

so MySQL cluster test use 3 x nodes and MariaDB also use 3, and 1 x for ProxySQL for MySQL cluster needed . total 7, right?

any additional nodes for cluster installation ? like in Windows, one more node for AD installation ?

"can we use only node with 1 x network card to install ProxySQL and test it? >> yes it should work"

is ProxySQL is necessary ?

and for each MariaDB nodes and MySQL cluster nodes, do we need 2x NIC ?

they should only need 1 x DNS ?

ASKER

any test tools/driver for me to quickly test both ?

1. How many redhat linux nodes on testing each of this?

For well galera environment setup 3 Nodes for clustering.

2. Anything else needed?

only 3 nodes required

3. no shared storage is needed as actually the testing should not have shared storage and we should try horizontal scale out.

No need of shared storage, we can horizontally scale UP. Whenever new nodes comes, add into cluster.

4. anything we should test on cluster ?

If nodes are in different location ,check the connectivity, time required for replication, Check any sql error when data updated from 3 servers.

ASKER

any good one stop installation guide on setting up 3 x nodes MariaDB on 3 x redhat linux 7 x86- 64 bits?

you seems tried that before and 3 x nodes already enough for testing everything?

if you try it again, any change on the number of nodes needed ?

please help to address MySQL cluster installation question above:

so MySQL cluster test use 3 x nodes and MariaDB also use 3, and 1 x for ProxySQL for MySQL cluster needed . total 7, right? 

any additional nodes for cluster installation ? like in Windows, one more node for AD installation ?

"can we use only node with 1 x network card to install ProxySQL and test it?  >> yes it should work"

is ProxySQL is necessary ?

and for each MariaDB nodes and MySQL cluster nodes, do we need 2x NIC ?

they should only need 1 x DNS ?

Open in new window

any good one stop installation guide on setting up 3 x nodes MariaDB on 3 x redhat linux 7 x86- 64 bits?

Please find the below link,
https://www.dreamvps.com/tutorials/install-mysql-galera-cluster-centos-7/

you seems tried that before and 3 x nodes already enough for testing everything?

yeah i have tried with 3 nodes and 3 nodes configure with application works fine. data's are getting replicated without any issues.

if you try it again, any change on the number of nodes needed ?

You can try with 2 nodes as well , for better experience try with 3 nodes. scale horizontally when adding new servers

ASKER

"yeah i have tried with 3 nodes and 3 nodes configure with application works fine. data's are getting replicated without any issues."

what is the test you do with it ?

" scale horizontally when adding new servers"

it automatically do it for us or need additional DBA work, like in MS SQL , need to ALTER read only load balancing list again ?

ASKER

hi,

can I install both MySQL cluster and MariaDB cluster on the SAME 3x nodes?

how about MySQL proxySQL? can I install it on one of the 3 x nodes too ?

can I install both MySQL cluster and MariaDB cluster on the SAME 3x nodes?
- never tried that but don't do it.

how about MySQL proxySQL? can I install it on one of the 3 x nodes too ?
- Yes

ASKER

theGhost_k8,

hi,

" how about MySQL proxySQL? can I install it on one of the 3 x nodes too ?
- Yes"

sorry I have to ask this! did you try it before ?

so from your point of view , for product evaluation only ! how many nodes for MysQL cluster and mariaDB cluster should i use?

for MysQL cluster, which nodes should i use for management nodes, SQL node and data node?

this is the guide I read but it seems more than 3 nodes for MySQL cluster;
https://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/

" sorry I have to ask this! did you try it before ? " >> No worries. I already said I have implemented that in production and there are many others using it.

I think the guide you shared has every detail about how to evaluate. As said earlier I have little to no experience in NDB. Look for evaluation best practices section:

If you want to test the full performance and HA (High Availability) characteristics of MySQL Cluster,
we recommend the following minimal hardware setup:
• 2 hosts each running one Data Node
• 2 hosts each running one Application Node and Management Server

ASKER

"I think the guide you shared has every detail about how to evaluate.

not really ! diff from all of you suggested.

"• 2 hosts each running one Data Node
• 2 hosts each running one Application Node and Management Server
"

already 4 x nodes but people here said 3 x

" As said earlier I have little to no experience in NDB." < Please follow the guide else wait for more instructions.
You can implement galera cluster in single server, 3 VMs. Even 2 machines. but i'd ask you to try with atleast 3 nodes.
For NDB don't follow me.

ASKER

"You can implement galera cluster in single server, 3 VMs. Even 2 machines. but i'd ask you to try with atleast 3 nodes."

fyi, mariaDB just reply we should use 4 x as the other one is for maxscale.

each with 1 x IP address.

ASKER

I am waiting for more input on MySQL cluster,

it seem also 4 x server with that extra 1 for cluster, the guide said 2 x IP for each node, do you know why ? necessary ?

if u are going for galera cluster no need for extra cluster node.

ASKER

"if u are going for galera cluster no need for extra cluster node."
no I am going to setup 2x product evulation, one for MySQL cluster and the other one is mariaDB.

it seems the final answer for MariaDB is 4 x nodes within 1 x nodes is for maxscale.

now, I am trying to confirm MySQL cluster's test environment, seems 4 nodes with 1 x nodes is for cluster? and do I need 2 x IP address for each MySQL node? seems a lot !

ASKER

Hi,
Sorry for the delay in response,

For galera cluster doesn't require management server, Each server will act as master server, and keeps data syncing on all the servers!!

You can scale the number of nodes up to 50 min galera cluster.

Already i have shared the link to setup galera cluster , Kindly refer the link for more setup understanding

ASKER

"For galera cluster doesn't require management server, Each server will act as master server, and keeps data syncing on all the servers!!

I requested 4 xVM , do we need 2 x IP for 2 x NIC for MySQL cluster and MariaDB cluster network test ?

mariaDB say one more nodes for Maxscales setup.

so is MySQL cluster need 4 x nodes, right?

do we need cluster IP for mariaDB cluster or MySQL cluster?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

"For scaling up, stop the cluster add the new node and start the cluster service."

I think it will automatically readjust on the fly ,right ?

yes

ASKER

then why we need to do this:

"stop the cluster add the new node and start the cluster service"

this is for safer side

ASKER

I will close it for now but FYI, I will start creating the redhat linux VM for it and I will have more questions post for these platform.

you both good and no one is the best ! both best !

ASKER

I might come back soon.

ASKER

it looks like that MySQL cluster management nodes need license ? can't test it as evaluation ?

requires Licence

slightwv (䄆 Netminder)

Oracle has pretty liberal evaluation options.

A quick Google got me here:
https://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/

In the PDF you get:

MySQL Cluster Manager is part of the commercial MySQL Cluster Carrier Grade Edition offering,
but is available for download and use, without obligation, for 30-days from the Oracle Software
Delivery Cloud5.

On the same page, please pay attention to the other paragraph in section 4:

Will MySQL Cluster “out of the box” run an application faster
than my existing MySQL database?

It hints at things I mentioned in your other questions about fair comparisons.

ASKER

slightwv,

"It hints at things I mentioned in your other questions about fair comparisons."

you mean without a good configuration for that it doesn't make any sense ?

this link can download management server: https://dev.mysql.com/downloads/cluster/ , let's try if I can install it.

slightwv (䄆 Netminder)

>>you mean without a good configuration for that it doesn't make any sense ?

Pretty much yes. Even with the install guides you have asked for you can only test basic functionality. You shouldn't test for things like performance or more advanced functions that likely require advanced product knowledge.

ASKER

"Even with the install guides you have asked for you can only test basic functionality."

But for me this is good enough already to report sth to management.

"You shouldn't test for things like performance or more advanced functions that likely require advanced product knowledge."

this have to takes a long time before the real result come true ! actually I think finally the product compare will take into consideration on what kind of easy tools and support the product offer !

you know recently I get a report from MariaDB which is doing sth I just did ! compare MariaDB, MysQL , MS SQL and Oracle !

actually this report is all wrong! I can see it is bad mouthing MS SQL all the way !!! AHAHAHHAH

if MS SQL that bad , why FINANCIAL firm here (which has government regulation control) nearly all use it now ????

For small financial firm will usually use MariaDB as they want any saving on IT Budget goes into their wallet ! BIG bank use MS SQL !

MariDB / Oracle MySQL / Percona MySQL -- they all are sort-of descendants of "MySQLAB" walking on their on paths (branches you can say) having few different features to offer than one another. The DNA remains the same.
When you say "I can see it is bad mouthing MS SQL all the way !!! " I think you know it's war out there - Opensource vs Proprietary. You have to compare and show your plus points. Importantly every tool has its appropriate application.

In our region a famous couplet goes like:
"रहिमन देखि बड़ेन को, लघु न दीजिए डारि
जहां काम आवै सुई, कहा करै तलवारि"

meaning

"Looking at bigger things, do not neglect the smaller ones.
Where the needle is needed, a sword is of no use"

ASKER

"MariDB / Oracle MySQL / Percona MySQL -- they all are sort-of descendants of "MySQLAB" walking on their on paths (branches you can say) having few different features to offer than one another. The DNA remains the same."

yes !

"When you say "I can see it is bad mouthing MS SQL all the way !!! " I think you know it's war out there - Opensource vs Proprietary. You have to compare and show your plus points. "

yeah ! I already did during the last round and that's why I asked you all so many question based on feature !

one thing, MySQL also confirm there are no OLAP feature from MySQL , any work around can use to fix it?

""Looking at bigger things, do not neglect the smaller ones.
Where the needle is needed, a sword is of no use"
"

yeah ! In my first report, one hadoop to SQL import gateway MS SQL is better as MS integrate it into MS SQL already and it is scale able.

R integrate natively on MS SQL as MS buy it.

Bernard Savonet

just my 2cents "en passant":
the main point about mssql is in fact, as reminded, the debate of open-source vs proprietary.

MS partners use quite a lot the FUD factor (Fuzz, Uncertainty, Doubt) to bring customers to MSSQL. While this is a very good move in some situations, it is not in others. There are lots of Open-source alternatives for sql servers: mysql / MariaDB etc are one family, POstgresql is another one, and both are serving huge companies. Of course MS partners will NOT point to these...