MySQL cluster by Auto installer

https://dev.mysql.com/downloads/cluster/

Once the web based application is installed, and the servers with mysql exist.....

look at the documentations included with the above.

The webportal then contacts the four members defined in the topology to tell them what needs to be done.

Would you kindly ask a question that has a specific concern for you rather one that requires that I interpret/extrapolate from your question what you really are after?

Nothing is automatic.
I.e. If I create a powershell, vbscript that you can run on a windows platform, which sets up and configures a distributor, publisher, subscriber automatically and call it Automatic Distributor/publisher/subscriber setup.
And the image will be the same, who is the distributor, who is the publisher, database, etc. who is the subscriber.
Would you expects this script to also install windows and ms sql? Certain things have to be setup ahead of time with which this auto-installer/configurator interacts.

What the video is pointing to is a web based interface that collects information, including credentials (ssh) that are used to connect to the members defined in the topology and then executes commands on those systems to configure the existing installed applications.
If mysql was not installed on the pair, ....

Please take the time, run through the process of either installing the OS, adding mysql, mysql-server/configuring the system for basic operations. get familiar with where the configuration files are for the different applications, php, apache/https, mysql, etc.

To enhance your own skill from Windows only, you need to shift your perspective a bit and not be focussed or looking for every interaction to be in a GUI type of interface.
the point being you've learned TSQL that you can achieve in a query, versus someone , who would use the SSMS GUI to perform different tasks.

I think it is better to ask question while attempting to perform different tasks, versus asking questions in the abstract and then analyzing every possible issue that might arise.

I.e. if I call a mechanic and ask how to start a car, I get an answer that I need to enter the car, insert the key into the ignition (the item on the steering wheel or near it) and then turn the key until the car starts...
Instead of trying, I ask what happens if the car does not start?

Sometimes, you can not ask your way into a complete confidence of a solution, at times, you have to try and follow the information you collected and then see if you run into issues and whether you can resolve the issues on your own based on the previously obtained and newly obtained information.

If everything could be automated, you and I would not have a job.

I.e. someone would create an automatically manage your server.
and another will create an automatically DBA your databases.

Nagendra Pratap Singh.

what do you mean, I don't understand that.

Arnold,

actually what I want to know is, how can I make use of the auto installer as it can simplifier the way I install MySQL, but from the video the demostor say as it is windows so he use the .bat file, so is this mean he installed MysQL on Windows and he run the auto installer from within windows ?

"Certain things have to be setup ahead of time with which this auto-installer/configurator interacts."
 good point, then what is it you think he has done ?

"What the video is pointing to is a web based interface that collects information, including credentials (ssh) that are used to connect to the members defined in the topology and then executes commands on those systems to configure the existing installed applications.
 If mysql was not installed on the pair, ...."

ok, you mean before that happen MySQL already installed so that the demo works ? so is that mean I have to install MySQL on all the node in advance, then run that tools to configure the replicatoin to make it active active so that it is much easier?

"Sometimes, you can not ask your way into a complete confidence of a solution, at times, you have to try and follow the information you collected and then see if you run into issues and whether you can resolve the issues on your own based on the previously obtained and newly obtained information.
"

this is what I am going to after listen to you all.

"If everything could be automated, you and I would not have a job."

I knew but I just saw this and I am not sure if I can use it to make the MySQL installation easier.

Looking at the video, carefully, posing and going a bit back when a question cones up.

Listen one can read a book about driving, ask others about their driving experiences, at sone point said person has to get behind the wheel and drive.

What I saw after the person collects information about how many systems are in the topology (comma separated list of IPs) and the credentials
The next step that wa display was a list of the four IPs
The important part after pending, each reflects the platform of each system as Linux.
The point either the MySQL is Instalked during the oS setup (commands executed detect/check the OS type, then eother issue apt-get install MySQL.... Or yum install MySQL-server.........

To be clear when you make it easier on yourself on the install, setup part. When Murphy's law kicks in, oh,, and iit will in the most inconvenient and unpleasant time.

Use the setup process yo understand how, why and in what the setup/functionality relies and how to troubleshoot issues.

Nagendra Pratap Singh,

"You can do an automated install of mysql on linux. You will not click on a batch file as linux uses different type of files."

this is what I don't understand about and that video and that speaker did jump across some detail.

Please relook at the youtube video paying attention to what is being access, what is being provided and finally what is being done.

I am of the opinion if you tried setting up last week, you would have a much better understanding of the operations as well as have narrower, specific questions applicable to a situation you might have ran into.....

You need to choose one OS first to learn. Programming etc comes way later.

Buy an introductory book for Windows and another one for Linux.

Trust me, it will do you lots of good.

Nagendra Pratap Singh,

"You need to choose one OS first to learn. Programming etc comes way later."

I think now is, learn how to setup MySQL first then programming later, this is what I keep asking,  I don't focus on Linux much now..

MySQL community edition seems don't have MysQL audit option but the rest of edition, right?

"Trust me, it will do you lots of good."

it is for long terms sir and I understand, but I preferrably make MySQL up and running first, then let team test it. then during this time I keep learning.

If I buy books to read and learn, which take a long time and I will get killed by my boss.

later on I will need to setup oracle too, so buy oracle book and learn oracle in 2 weeks and get everything done? not that easy and quick man.

arnold,

I have much more knowledge on Maria DB only as I study a lot last week but this week ,as I said, I have been told that MariaDB is not allowed here but MySQL, so a lot of MySQL only question is asking, that's why!


so that;s why I stilll looking for an answer of this:

"So finally everyone agree installing MySQL community edition is enough for me to POC the MySQL active active / multi master configuration ?

and this should be the installation guide:

https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication

and this video can also help ?

https://www.youtube.com/watch?v=jMaocv9SVI0

also, what component I have to install from this page ?

https://dev.mysql.com/downloads/mysql/

but community edition do not have audit option for it, right?"

Listen, the information you learned does not limit your understanding of MySQL IMHO.
That is what I mean, I understand the desire to familiarize oneself with the topic at hand.
The point being if I am tasked with Setup of a storage space for a group that will store documents in French, another will store documents in German, another in mandarin ; I will not see it as a requirement to learn those languages before I setup what has been requested.

Pick one and try it. You have an equal chance of succeeding on each node/system, though the total probability for success, is less than 50/50 for a three node setup.
Happened and happens often during initial setup that the first setup part goes well, then one works from memory of what they just did, and inevitably miss a step. Including a typo that wreaks havoc.

If you are told tomorrow, that your firm is having an issue with an oracle db related issue, you have to jump in and quickly figure what is going, mainly confirm that the db is online, there is no time to ask, learn the technology. All one has to find out is how one interacts with oracle in terms of connecting, and how one checks the status. To resolve the issue as quickly as possible by identifying ... And then notifying one , i.e. Oracle DBA where the issue is outside your expertise.
Subsequent to this, take as much time as needed further advance knowledge of basic operations ....

"Pick one and try it. You have an equal chance of succeeding on each node/system, though the total probability for success, is less than 50/50 for a three node setup."

also want to find out, if MysQL replication, cluster is that good. then no one will use Oracle. but we have to tell what is missing from MySQL to make people keep using Oracle but not MySQL.

even there are case , real case here, that more and more company change to MS SQL + MysQL to get ride of Oracle cost. what I say is, you can see 50% or more company is doing this.

just like my research  with my google here (I don't only ask here and ask Mr. google too, but their result may not correct, not that real world experience), MySQL Cluster is for performance while replication is for redundancy as MySLQ Cluster use NDB and replication still use InnoDB.

MySQL cluster table can be on RAM but not MySQL replication, can be a big diff.

one thing, if now decided to use MySQL community edition, should I download and install all rpm from this page:

https://dev.mysql.com/downloads/mysql/

There is no way to answer the question as you posed it, why do people buy a specific car when in general terms a cheaper one is available.

You have to define the conditions, requirements, and based on that you can determine why one item can be preferable to another.

let use a truck example, one has to move 2 tons weight. having a single truck that costs 250,000 dollars load in and haul the lot.
One could use a $25,000 passenger to move that weight as well, but the type of load that makes up the 2 ton will determine whether the passenger car is suitable. i.e. if it is 2 tons of boxes, of stuff. it will take longer, i.e. one would have to make several trips to transfer the weight, however, if the weight is made of three solid items, it would make the passenger car unsuitable for the task.

The requirements of the application that will use the mysql as the storage will dictated whether or what additional steps the developers/programmers have to take to make it work with mysql or ms sql.

you could or you could use the OS mechanism to get the version that is included by the vendor which will provide you with the consistency as well as regular updates should a vulnerability, bug exists in the version.
If you install the version from mysql, you would have to monitor the bug/security related issues and update the installed version on your own..

I.e. mysql version x.y.z has a bug that a specific type of query could lead to buffer overflow, or data corruption. if this version is distributed/included by the vendor, redhat, they will release an update that yum update mysql-server will fix.
if you deploy the package, you would either have to get the rpm of the mysql source you installed, fixed the bug, configure, compile, install or get the newer version and deal with testing before deploying to make sure the change in version does not have an adverse issue with the application, etc.

Are your task/duties migrate (now include through encroachment)  from DBA to Systems management?

"The requirements of the application that will use the mysql as the storage will dictated whether or what additional steps the developers/programmers have to take to make it work with mysql or ms sql."

what is the application already exists for a long time and now we just POC if a MySQL master master setup create any problem. this is it .

requirement, master master replication create no problem on data  integrity. DB don't die because of this, specially DURING and AFTER fail over.

let me watch that video.