Galera Cluster Tutorial: Building a Highly Available Database System

In this video, we look into the database library Galera for MySQL or MariaDB. It enables replication over multiple hosts where each host is a master and replicated to the other hosts so it's eventually consistent.

Join the Google Cloud-led certificate program on Coursera and dive into security principles in cloud computing. Master cloud risk management and attack mitigation techniques. Equip yourself with cutting-edge cybersecurity skills.

Enhance your career in Cybersecurity with AI. Build in-demand generative AI skills and gain credentials for your cybersecurity career in 3 months or less. No degree or prior experience required.

Get Proficient knowledge in Azure services and infrastructures, managing cloud resources, cloud security with our Cloud Support Associate Certificate !

Join the channel to get access to more perks:

Or visit my blog at:

Outro music: Sanaas Scylla

#galera #mysql #mariadb

[sagardolui]

This video is absolutely gold. Thank you, it helped me a lot.

[paolonervi]

Hi Daniel, thank you very much for the time you have dedicated in making this super useful video..cheers from Italy.

[rajaparthiban]

thanks for the video, this made some knowledge about Maria DB HA

[aaronperl]

This was a very interesting demonstration. Thanks!

[andrespanella]

Hi Daniel! Thanks for the video. I need to know how many tps maximum I can expect with this configuration. I saw some videos that talk 1million qps. I think that isn't possible in production environments.

[djkadakamc]

❤ Next video: configurate maxscale, haproxy, corosync and pacemaker

[clecimarfernandes]

We used to say: "Aonde está a galera ?" that means: How about the guys ? Where they are ? Something like this.

[andresj]

Thanks for this video.
I have recently had an outage on my DB server, so now I'm running two MariaDB servers on primary and replicate configuration. My question is:
I have lots of services that access the primary DB server, if that one goes down, how should I setup things for the services to automatically switch to the replicate server?
At the moment I defined a domain with the local IP of the current primary, so I can change the register of that DNS and every service would resolve the new IP.

[manit]

great video thanks. resources are hard to find on this subject.

[damodarsimkhada]

Hi Daniel, I'm doing this in ubuntu sysrtem and i have come far but while executing sudo galera_ it says that commant not found

[SangreNL]

Thnx for the video, i had one question though, After setting the global var, wsrep_provider_options='pc.bootstrap=true', would it be wise to set is to false after the cluster is up and running again, to prevent that this node will allways be the bootstrap-one?

[kaustubhmanitripathi]

please make a detailed video on this. please it would really mean alot. thank youuu

[shrine]

So I in case of 3 nodes, when one node fails I shouldn't restart any of remaining nodes without setting pc.bootstrap=true?

[niloufarpadkan]

Thanks. But you did not show the procedure of installing gelara. And also load balancers