ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
¸é±ð±è±ô¾±³¦²¹³¦¾±¨®
                            MySQL
                            Mites, llegendes i realitats



                                       @ifosch
Wednesday, January 2, 13
A DBMS also needs to provide
                        e!ective run-time execution to
                       properly support (e.g., in terms of
                        performance, availability, and
                       security) as many end-users (the
                        database's application users) as
                                    needed
                                      definici¨® de ¡®DataBase¡¯ a la Wikipedia




Wednesday, January 2, 13
A DBMS also needs to provide
                        e!ective run-time execution to
                       properly support (e.g., in terms of
                        performance availability, and
                        performance,
                       security) as many end-users (the
                        database's application users) as
                                    needed
                                      definici¨® de ¡®DataBase¡¯ a la Wikipedia




Wednesday, January 2, 13
A DBMS also needs to provide
                        e!ective run-time execution to
                       properly support (e.g., in terms of
                        performance availability, and
                        performance, availability
                       security) as many end-users (the
                        database's application users) as
                                    needed
                                      definici¨® de ¡®DataBase¡¯ a la Wikipedia




Wednesday, January 2, 13
A DBMS also needs to provide
                        e!ective run-time execution to
                       properly support (e.g., in terms of
                        performance availability, and
                        performance, availability
                       security as many end-users (the
                       security)
                        database's application users) as
                                    needed
                                      definici¨® de ¡®DataBase¡¯ a la Wikipedia




Wednesday, January 2, 13
A DBMS also needs to provide
                        e!ective run-time execution to
                                                    t y ?
                                         b   li
                       properly support (e.g., in terms of
                                           i
                        performance availability, and
                        performance, availability

                               ca la
                       security as many end-users (the
                       security)
                             s
                        database's application users) as
                                    needed
                                      definici¨® de ¡®DataBase¡¯ a la Wikipedia




Wednesday, January 2, 13
¸é±ð±è±ô¾±³¦²¹³¦¾±¨® MySQL
                                                          Slave
                                                  I/O
                                                Thread


                           Master
                             BinLog            RelayLog




                                       SQL
                                      Thread




Wednesday, January 2, 13
¸é±ð±è±ô¾±³¦²¹³¦¾±¨® MySQL



                              Master   Slave




Wednesday, January 2, 13
¸é±ð±è±ô¾±³¦²¹³¦¾±¨® MySQL

   Master                   Slave




Wednesday, January 2, 13
¸é±ð±è±ô¾±³¦²¹³¦¾±¨® MySQL

   Master                   Slave




                                             Slave



                                    Master

                                             Slave




Wednesday, January 2, 13
¸é±ð±è±ô¾±³¦²¹³¦¾±¨® MySQL
                                                Slave
   Master                   Slave

                                       Master

                                                Slave




Wednesday, January 2, 13
¸é±ð±è±ô¾±³¦²¹³¦¾±¨® MySQL
                                                       Slave
   Master                   Slave

                                              Master

                                                       Slave




                                Master   Master




Wednesday, January 2, 13
¸é±ð±è±ô¾±³¦²¹³¦¾±¨® MySQL
                                                      Slave
   Master                   Slave

                                           Master

                                                      Slave




                                      Master        Master



Wednesday, January 2, 13
¸é±ð±è±ô¾±³¦²¹³¦¾±¨® MySQL
                                                                          Slave
   Master                   Slave

                                                               Master

                                                                          Slave

                                    Master            Master




                                             Master



                                                        Master          Master



Wednesday, January 2, 13
¸é±ð±è±ô¾±³¦²¹³¦¾±¨® MySQL
                                                            Slave
   Master                       Slave

                                                 Master

                                                            Slave




        Master                     Master




                                            Master        Master

                       Master

Wednesday, January 2, 13
¸é±ð±è±ô¾±³¦²¹³¦¾±¨® MySQL
                                                            Slave
   Master                       Slave

                                                 Master

                                                            Slave




        Master                     Master
                 Poc recomenable


                                            Master        Master

                       Master

Wednesday, January 2, 13
Rendiment

                   Master




                                         App
                            Slave


                 Slave




Wednesday, January 2, 13
Rendiment
                                               Implica que
                                                l¡¯aplicaci¨®
                   Master
                                                  estigui
                                                preparada

                                         App
                            Slave


                 Slave




Wednesday, January 2, 13
Rendiment
                                                Implica que
                                                 l¡¯aplicaci¨®
                   Master
                                                   estigui
                                                 preparada

                                         App
                                                MySQL proxy
                            Slave              podria ajudar a
                 Slave
                                                redirigir les
                                                 conexions
                                                adientment



Wednesday, January 2, 13
Disponibilitat


                  Master         Master




                           App




Wednesday, January 2, 13
Disponibilitat

                                           MySQL proxy
                  Master         Master   podria ajudar a
                                           redirigir les
                                            conexions
                                           adientment

                           App




Wednesday, January 2, 13
Backup i Extracci¨®


                            Master         Slave




                                     DWH




Wednesday, January 2, 13
Eines i gesti¨®


            ?maatkit           ?Logs binaris
            ?HAproxy           ?Comunicacions
            ?mysqlproxy        ?Estat de la replicaci¨®




Wednesday, January 2, 13
Demostraci¨® M-M




Wednesday, January 2, 13
Gr¨¤cies!




Wednesday, January 2, 13
Ad

Recommended

Cloud building talk
Cloud building talk
bodepd
?
[NHN] ???? ???? ??? ??
[NHN] ???? ???? ??? ??
GAMENEXT Works
?
Testing mysql creatively in a sandbox
Testing mysql creatively in a sandbox
Giuseppe Maxia
?
What makes JBoss AS7 tick?
What makes JBoss AS7 tick?
marius_bogoevici
?
Mysql Replication Excerpt 5.1 En
Mysql Replication Excerpt 5.1 En
liufabin 66688
?
From chaos to order
From chaos to order
Ignasi Alonso
?
Clouds can cause rainy weather
Clouds can cause rainy weather
Ignasi Alonso
?
The Near Future of CSS
The Near Future of CSS
Rachel Andrew
?
Advanced MySQL Replication Architectures - Luis Soares
Advanced MySQL Replication Architectures - Luis Soares
MySQL Brasil
?
Advanced mysql replication for the masses
Advanced mysql replication for the masses
Giuseppe Maxia
?
Keith Larson Replication
Keith Larson Replication
Dave Stokes
?
MySQL High Availability Sprint: Launch the Pacemaker
MySQL High Availability Sprint: Launch the Pacemaker
hastexo
?
MySQL High-Availability and Scale-Out architectures
MySQL High-Availability and Scale-Out architectures
FromDual GmbH
?
Replication Tips & Trick for SMUG
Replication Tips & Trick for SMUG
Mats Kindahl
?
LCA 2012: High Availability Sprint
LCA 2012: High Availability Sprint
hastexo
?
Data
Data
Tommy Chiu
?
090507.New Replication Features(2)
090507.New Replication Features(2)
liufabin 66688
?
MySQL Webinar 2/4 Performance tuning, hardware, optimisation
MySQL Webinar 2/4 Performance tuning, hardware, optimisation
Mark Swarbrick
?
²Ñ²â³§²Ï³¢¸ß¿ÉÓÃ
²Ñ²â³§²Ï³¢¸ß¿ÉÓÃ
thinkinlamp
?
MySQL Consegi
MySQL Consegi
henriquesidney
?
Try NoSQL it doesn't hurts and is fun
Try NoSQL it doesn't hurts and is fun
Pere Urb¨®n-Bayes
?
Gearman
Gearman
Brian Moon
?
Testing mysql creatively in a sandbox
Testing mysql creatively in a sandbox
Giuseppe Maxia
?
Data servers
Data servers
SagarChougule11
?
MySQL High Availability and Disaster Recovery with Continuent, a VMware company
MySQL High Availability and Disaster Recovery with Continuent, a VMware company
Continuent
?
Drupal Camp G?teborg 2013: Skalbarhet och tillg?nglighet med MySQL-replikering
Drupal Camp G?teborg 2013: Skalbarhet och tillg?nglighet med MySQL-replikering
Sven Sandberg
?
MySQL High Availability Solutions
MySQL High Availability Solutions
Lenz Grimmer
?
Mysqlhacodebits20091203 1260184765-phpapp02
Mysqlhacodebits20091203 1260184765-phpapp02
Louis liu
?
FIDO Seminar: New Data: Passkey Adoption in the Workforce.pptx
FIDO Seminar: New Data: Passkey Adoption in the Workforce.pptx
FIDO Alliance
?
"Database isolation: how we deal with hundreds of direct connections to the d...
"Database isolation: how we deal with hundreds of direct connections to the d...
Fwdays
?

More Related Content

Similar to Replicacio? MySQL (20)

Advanced MySQL Replication Architectures - Luis Soares
Advanced MySQL Replication Architectures - Luis Soares
MySQL Brasil
?
Advanced mysql replication for the masses
Advanced mysql replication for the masses
Giuseppe Maxia
?
Keith Larson Replication
Keith Larson Replication
Dave Stokes
?
MySQL High Availability Sprint: Launch the Pacemaker
MySQL High Availability Sprint: Launch the Pacemaker
hastexo
?
MySQL High-Availability and Scale-Out architectures
MySQL High-Availability and Scale-Out architectures
FromDual GmbH
?
Replication Tips & Trick for SMUG
Replication Tips & Trick for SMUG
Mats Kindahl
?
LCA 2012: High Availability Sprint
LCA 2012: High Availability Sprint
hastexo
?
Data
Data
Tommy Chiu
?
090507.New Replication Features(2)
090507.New Replication Features(2)
liufabin 66688
?
MySQL Webinar 2/4 Performance tuning, hardware, optimisation
MySQL Webinar 2/4 Performance tuning, hardware, optimisation
Mark Swarbrick
?
²Ñ²â³§²Ï³¢¸ß¿ÉÓÃ
²Ñ²â³§²Ï³¢¸ß¿ÉÓÃ
thinkinlamp
?
MySQL Consegi
MySQL Consegi
henriquesidney
?
Try NoSQL it doesn't hurts and is fun
Try NoSQL it doesn't hurts and is fun
Pere Urb¨®n-Bayes
?
Gearman
Gearman
Brian Moon
?
Testing mysql creatively in a sandbox
Testing mysql creatively in a sandbox
Giuseppe Maxia
?
Data servers
Data servers
SagarChougule11
?
MySQL High Availability and Disaster Recovery with Continuent, a VMware company
MySQL High Availability and Disaster Recovery with Continuent, a VMware company
Continuent
?
Drupal Camp G?teborg 2013: Skalbarhet och tillg?nglighet med MySQL-replikering
Drupal Camp G?teborg 2013: Skalbarhet och tillg?nglighet med MySQL-replikering
Sven Sandberg
?
MySQL High Availability Solutions
MySQL High Availability Solutions
Lenz Grimmer
?
Mysqlhacodebits20091203 1260184765-phpapp02
Mysqlhacodebits20091203 1260184765-phpapp02
Louis liu
?
Advanced MySQL Replication Architectures - Luis Soares
Advanced MySQL Replication Architectures - Luis Soares
MySQL Brasil
?
Advanced mysql replication for the masses
Advanced mysql replication for the masses
Giuseppe Maxia
?
Keith Larson Replication
Keith Larson Replication
Dave Stokes
?
MySQL High Availability Sprint: Launch the Pacemaker
MySQL High Availability Sprint: Launch the Pacemaker
hastexo
?
MySQL High-Availability and Scale-Out architectures
MySQL High-Availability and Scale-Out architectures
FromDual GmbH
?
Replication Tips & Trick for SMUG
Replication Tips & Trick for SMUG
Mats Kindahl
?
LCA 2012: High Availability Sprint
LCA 2012: High Availability Sprint
hastexo
?
090507.New Replication Features(2)
090507.New Replication Features(2)
liufabin 66688
?
MySQL Webinar 2/4 Performance tuning, hardware, optimisation
MySQL Webinar 2/4 Performance tuning, hardware, optimisation
Mark Swarbrick
?
²Ñ²â³§²Ï³¢¸ß¿ÉÓÃ
²Ñ²â³§²Ï³¢¸ß¿ÉÓÃ
thinkinlamp
?
Try NoSQL it doesn't hurts and is fun
Try NoSQL it doesn't hurts and is fun
Pere Urb¨®n-Bayes
?
Testing mysql creatively in a sandbox
Testing mysql creatively in a sandbox
Giuseppe Maxia
?
MySQL High Availability and Disaster Recovery with Continuent, a VMware company
MySQL High Availability and Disaster Recovery with Continuent, a VMware company
Continuent
?
Drupal Camp G?teborg 2013: Skalbarhet och tillg?nglighet med MySQL-replikering
Drupal Camp G?teborg 2013: Skalbarhet och tillg?nglighet med MySQL-replikering
Sven Sandberg
?
MySQL High Availability Solutions
MySQL High Availability Solutions
Lenz Grimmer
?
Mysqlhacodebits20091203 1260184765-phpapp02
Mysqlhacodebits20091203 1260184765-phpapp02
Louis liu
?

Recently uploaded (20)

FIDO Seminar: New Data: Passkey Adoption in the Workforce.pptx
FIDO Seminar: New Data: Passkey Adoption in the Workforce.pptx
FIDO Alliance
?
"Database isolation: how we deal with hundreds of direct connections to the d...
"Database isolation: how we deal with hundreds of direct connections to the d...
Fwdays
?
The Future of Technology: 2025-2125 by Saikat Basu.pdf
The Future of Technology: 2025-2125 by Saikat Basu.pdf
Saikat Basu
?
Cyber Defense Matrix Workshop - RSA Conference
Cyber Defense Matrix Workshop - RSA Conference
Priyanka Aash
?
The Future of Data, AI, and AR: Innovation Inspired by You.pdf
The Future of Data, AI, and AR: Innovation Inspired by You.pdf
Safe Software
?
Security Tips for Enterprise Azure Solutions
Security Tips for Enterprise Azure Solutions
Michele Leroux Bustamante
?
AI VIDEO MAGAZINE - June 2025 - r/aivideo
AI VIDEO MAGAZINE - June 2025 - r/aivideo
1pcity Studios, Inc
?
Smarter Aviation Data Management: Lessons from Swedavia Airports and Sweco
Smarter Aviation Data Management: Lessons from Swedavia Airports and Sweco
Safe Software
?
Lessons Learned from Developing Secure AI Workflows.pdf
Lessons Learned from Developing Secure AI Workflows.pdf
Priyanka Aash
?
FIDO Seminar: Targeting Trust: The Future of Identity in the Workforce.pptx
FIDO Seminar: Targeting Trust: The Future of Identity in the Workforce.pptx
FIDO Alliance
?
ReSTIR [DI]: Spatiotemporal reservoir resampling for real-time ray tracing ...
ReSTIR [DI]: Spatiotemporal reservoir resampling for real-time ray tracing ...
revolcs10
?
CapCut Pro Crack For PC Latest Version {Fully Unlocked} 2025
CapCut Pro Crack For PC Latest Version {Fully Unlocked} 2025
pcprocore
?
OpenACC and Open Hackathons Monthly Highlights June 2025
OpenACC and Open Hackathons Monthly Highlights June 2025
OpenACC
?
FIDO Alliance Seminar State of Passkeys.pptx
FIDO Alliance Seminar State of Passkeys.pptx
FIDO Alliance
?
MuleSoft for AgentForce : Topic Center and API Catalog
MuleSoft for AgentForce : Topic Center and API Catalog
shyamraj55
?
2025_06_18 - OpenMetadata Community Meeting.pdf
2025_06_18 - OpenMetadata Community Meeting.pdf
OpenMetadata
?
Information Security Response Team Nepal_npCERT_Vice_President_Sudan_Jha.pdf
Information Security Response Team Nepal_npCERT_Vice_President_Sudan_Jha.pdf
ICT Frame Magazine Pvt. Ltd.
?
A Constitutional Quagmire - Ethical Minefields of AI, Cyber, and Privacy.pdf
A Constitutional Quagmire - Ethical Minefields of AI, Cyber, and Privacy.pdf
Priyanka Aash
?
Improving Data Integrity: Synchronization between EAM and ArcGIS Utility Netw...
Improving Data Integrity: Synchronization between EAM and ArcGIS Utility Netw...
Safe Software
?
GenAI Opportunities and Challenges - Where 370 Enterprises Are Focusing Now.pdf
GenAI Opportunities and Challenges - Where 370 Enterprises Are Focusing Now.pdf
Priyanka Aash
?
FIDO Seminar: New Data: Passkey Adoption in the Workforce.pptx
FIDO Seminar: New Data: Passkey Adoption in the Workforce.pptx
FIDO Alliance
?
"Database isolation: how we deal with hundreds of direct connections to the d...
"Database isolation: how we deal with hundreds of direct connections to the d...
Fwdays
?
The Future of Technology: 2025-2125 by Saikat Basu.pdf
The Future of Technology: 2025-2125 by Saikat Basu.pdf
Saikat Basu
?
Cyber Defense Matrix Workshop - RSA Conference
Cyber Defense Matrix Workshop - RSA Conference
Priyanka Aash
?
The Future of Data, AI, and AR: Innovation Inspired by You.pdf
The Future of Data, AI, and AR: Innovation Inspired by You.pdf
Safe Software
?
AI VIDEO MAGAZINE - June 2025 - r/aivideo
AI VIDEO MAGAZINE - June 2025 - r/aivideo
1pcity Studios, Inc
?
Smarter Aviation Data Management: Lessons from Swedavia Airports and Sweco
Smarter Aviation Data Management: Lessons from Swedavia Airports and Sweco
Safe Software
?
Lessons Learned from Developing Secure AI Workflows.pdf
Lessons Learned from Developing Secure AI Workflows.pdf
Priyanka Aash
?
FIDO Seminar: Targeting Trust: The Future of Identity in the Workforce.pptx
FIDO Seminar: Targeting Trust: The Future of Identity in the Workforce.pptx
FIDO Alliance
?
ReSTIR [DI]: Spatiotemporal reservoir resampling for real-time ray tracing ...
ReSTIR [DI]: Spatiotemporal reservoir resampling for real-time ray tracing ...
revolcs10
?
CapCut Pro Crack For PC Latest Version {Fully Unlocked} 2025
CapCut Pro Crack For PC Latest Version {Fully Unlocked} 2025
pcprocore
?
OpenACC and Open Hackathons Monthly Highlights June 2025
OpenACC and Open Hackathons Monthly Highlights June 2025
OpenACC
?
FIDO Alliance Seminar State of Passkeys.pptx
FIDO Alliance Seminar State of Passkeys.pptx
FIDO Alliance
?
MuleSoft for AgentForce : Topic Center and API Catalog
MuleSoft for AgentForce : Topic Center and API Catalog
shyamraj55
?
2025_06_18 - OpenMetadata Community Meeting.pdf
2025_06_18 - OpenMetadata Community Meeting.pdf
OpenMetadata
?
Information Security Response Team Nepal_npCERT_Vice_President_Sudan_Jha.pdf
Information Security Response Team Nepal_npCERT_Vice_President_Sudan_Jha.pdf
ICT Frame Magazine Pvt. Ltd.
?
A Constitutional Quagmire - Ethical Minefields of AI, Cyber, and Privacy.pdf
A Constitutional Quagmire - Ethical Minefields of AI, Cyber, and Privacy.pdf
Priyanka Aash
?
Improving Data Integrity: Synchronization between EAM and ArcGIS Utility Netw...
Improving Data Integrity: Synchronization between EAM and ArcGIS Utility Netw...
Safe Software
?
GenAI Opportunities and Challenges - Where 370 Enterprises Are Focusing Now.pdf
GenAI Opportunities and Challenges - Where 370 Enterprises Are Focusing Now.pdf
Priyanka Aash
?
Ad

Replicacio? MySQL