89583
Using Replication for Scale-Out
You can use replication as a scale-out solution; that is, where you want to split up the load of database
queries across multiple database servers, within some reasonable limitations. Because replication works from the distribution of one master to one or morę slaves, using replication
for scale-out works best in an environment where you have a high number of reads and Iow number of
writes/updates. Most Web sites fit into this category, where users are browsing the Web site, reading
articles, posts, or viewing products. Updates only occur during session management, or when making a
purchase or adding a comment/message to a forum.
Replication in this situation enables you to distribute the reads over the replication slaves, while still
enabling your web sen/ers to communicate with the replication master when a write is reąuired. You
can see a sample replication layout for this scenario in Figurę 16.1, "Using Replication to lmprove Performance During Scale-Out”.
Wyszukiwarka
Podobne podstrony:
62311867a13eaee381e158c4c08673f7 This file is for persona! use only. You can print as many as you wa
fed3456b80e3211e01b4bd88da2165dd These filos or© for persona! os© only. You eon print os mony os you
c Page ‘ALL Rings’ Necklace -1 The project for ONE shuttle . Take about 4 yards of thread you want
784f369d6bb6191cc6e941fcf18633b4 Thi$ file is for personol use only. You eon print os many os you wa
9. Hacksaw blade A useful tool which you can use lo draw a cable. The blade should have about 14 tee
f14 5 Bi Add Data Source Select which ODBC driver you want to use from the list, then choose OK. OK
f4 12 Pioperty Page Wizard - Select the Pioperty Pages Choose the Property Page(s) you want to use w
f5 8 File Edit View Go Bookniar+is Options Directory Window Help If you want to deny all hosts (for
f9 5 lnbox Setup Wizard Select the information services(s] that you want to use with Microsoft Excha
fd764f37fe0986479a1d4351e5acc8ae How many independent variablcs? One Morę than one
20ddg01 Add Data Source a Select which ODBC driver you want to use from the list, then choose OK. In
33vcu01 Add Data Source Select which ODBC driver you want to use from the list, then choose OK. Inst
42 43 (3) — Tapescripts Unit 2Unit 1 Loan Otflcer: Now, I undęrstand you want to take out a loan wit
76094 image065 (7) Gęg _ Update Driver Software - ABBJndustry_0y DDCC+How do you want to search for
screenshot 9 Menus Create a new menu *✓ Hide This is useful when you want to use only the menus have
więcej podobnych podstron