Quick Upload

Mysql S&M

from notch8, 8 months ago Add as contact

1577 views | 0 comments | 3 favorites | 0 embeds (Stats)

This presentation goes over Master-Slave and Master-Master database replication for MySQL

Embed customize close
 

Categories

Technology

Groups/Events

More Info

This slideshow is Public

Views: 1577 Comments: 0 Favorites: 3 Downloads: 67

View Details: 1577 on Slideshare
0 from embeds
Flagged as inappropriate Flag as inappropriate
Flag as inappropriate

Select your reason for flagging this slideshow as inappropriate.

If needed, use the feedback form to let us know more details.

Loading...
Flash Player 9 (or above) is needed to view slideshows. We have detected that you do not have it on your computer. To install it, go here.
Post to Twitter Post to Twitter
Share on Facebook Share on Facebook
Post to Blogger Post to Blogger
Myspace Hi5 Friendster Xanga LiveJournal Facebook Blogger Tagged Typepad Freewebs BlackPlanet gigya icons

Presentation Transcript

  1. Slide 1:MySQL S&M by Rob Kaufman rob@notch8.com
  2. Slide 2: Slaves and Masters What is Master Slave Replication  One database instance (the Master) that does both reads and writes – This guy is in charge – Should do mostly writing  One or more database instances that only do reads (the Slaves) – Only know what the Master tells them – Never except writes 2
  3. Slide 3:Master Slave Diagram App Server App Server Master Slave 1 Slave 2 Slave 3 Key: Arrow represents data flow direction 3
  4. Slide 4: Master Slave: Why What will a Master Slave setup do for you?  Redundancy – Hot spares of data – Any slave can become the master i