<DIV>
<DIV> </DIV>
<DIV>
<TABLE cellSpacing=0 cellPadding=0 width=500 border=0>
<TBODY>
<TR>
<TD class=txt width=100 bgColor=#d8d8d8><FONT face="Trebuchet MS; verdana; arial" size=2><B>De:</B></FONT></TD>
<TD class=txt width=400 bgColor=#d8d8d8><FONT face="Trebuchet MS; verdana; arial" size=2>drbd-user-bounces@lists.linbit.com</FONT></TD></TR></TBODY></TABLE></DIV>
<DIV>
<TABLE cellSpacing=0 cellPadding=0 width=500 border=0>
<TBODY>
<TR>
<TD class=txt width=100 bgColor=#d8d8d8><FONT face="Trebuchet MS; verdana; arial" size=2><B>Para:</B></FONT></TD>
<TD class=txt width=400 bgColor=#d8d8d8><FONT face="Trebuchet MS; verdana; arial" size=2>"drbd-user" drbd-user@lists.linbit.com</FONT></TD></TR></TBODY></TABLE></DIV>
<DIV>
<TABLE cellSpacing=0 cellPadding=0 width=500 border=0>
<TBODY>
<TR>
<TD class=txt width=100 bgColor=#d8d8d8><FONT face="Trebuchet MS; verdana; arial" size=2><B>Cópia:</B></FONT></TD>
<TD class=txt width=400 bgColor=#d8d8d8><FONT face="Trebuchet MS; verdana; arial" size=2></FONT></TD></TR></TBODY></TABLE></DIV>
<DIV>
<TABLE cellSpacing=0 cellPadding=0 width=500 border=0>
<TBODY>
<TR>
<TD class=txt width=100 bgColor=#d8d8d8><FONT face="Trebuchet MS; verdana; arial" size=2><B>Data:</B></FONT></TD>
<TD class=txt width=400 bgColor=#d8d8d8><FONT face="Trebuchet MS; verdana; arial" size=2>Thu, 23 Sep 2004 15:09:37 +0200</FONT></TD></TR></TBODY></TABLE></DIV>
<DIV>
<TABLE cellSpacing=0 cellPadding=0 width=500 border=0>
<TBODY>
<TR>
<TD class=txt width=100 bgColor=#d8d8d8><FONT face="Trebuchet MS; verdana; arial" size=2><B>Assunto:</B></FONT></TD>
<TD class=txt width=400 bgColor=#d8d8d8><FONT face="Trebuchet MS; verdana; arial" size=2>Re: [DRBD-user] drbd tranfer limitations (random and sequential acccess) using raw</FONT></TD></TR></TBODY></TABLE></DIV>
<DIV>
<TABLE cellSpacing=0 cellPadding=0 width=500 border=0>
<TBODY>
<TR>
<TD width=100 bgColor=#e8e8e8> </TD>
<TD width=400 bgColor=#e8e8e8> </TD></TR></TBODY></TABLE></DIV>
<DIV>> / 2004-09-23 09:47:48 -0300</DIV>
<DIV>> \ crsurf:</DIV>
<DIV>> > > / 2004-09-23 09:01:50 -0300</DIV>
<DIV>> > > \ crsurf:</DIV>
<DIV>> > > > Hello list</DIV>
<DIV>> > > > I?m using drbd in a Gigabit network (crossover cable) and when I</DIV>
<DIV>> > > > synchronize data (sequential read/write) the tranfer hit to 30~40</DIV>
<DIV>> > > > Mb/s, but when I make inserts into database (random read/write) that</DIV>
<DIV>> > > > access drbd device via raw, the transfer rate hit only 5~6 Mb/s.</DIV>
<DIV>> > > > Exists some way to improve this performance? I increased the</DIV>
<DIV>> > > > sndbuf-size to 256K, but no such effect. I increase interface MTU to</DIV>
<DIV>> > > > 9000 and no such effect too. One database process that run in 4 min.</DIV>
<DIV>> > > > without replication, run in 30 min. with replication. Now I?m trying</DIV>
<DIV>> > > > using filesystem jfs instead raw to view if the performance will be</DIV>
<DIV>> > > > improved.</DIV>
<DIV>> > > > Maybe sync-nice can help us?</DIV>
<DIV>> > ></DIV>
<DIV>> > > I am not sure which transfer rate you are talking about.</DIV>
<DIV>> > > the throughput of your applications, or the resync throughput?</DIV>
<DIV>> > ></DIV>
<DIV>> > </DIV>
<DIV>> > With resync tha transfer hit 40~50 Mb/s, afer I changed MTU.</DIV>
<DIV>> > </DIV>
<DIV>> > > or the resync throughput while you have resynchronization and</DIV>
<DIV>> > > applications running concurrently?</DIV>
<DIV>> > ></DIV>
<DIV>> > </DIV>
<DIV>> > And when I make a insert into database the transfer hit to 4~6 Mb/s,</DIV>
<DIV>> > without full synchronization, only online synchronization.</DIV>
<DIV>> </DIV>
<DIV>> which transfer.</DIV>
<DIV>> sorry, again I don't get you here.</DIV>
<DIV>> </DIV>
<DIV>> is it that your data base has a write throughput of 6 MB,</DIV>
<DIV>> or that drbd resync throughput drops to 6 MB while the database is</DIV>
<DIV>> running?</DIV>
<DIV> </DIV>
<DIV>Yes is it, when using database throughput not pass 6 Mb/s.</DIV>
<DIV> </DIV>
<DIV>> </DIV>
<DIV>> how do you measure?</DIV>
<DIV> </DIV>
<DIV>I´m using iptraf to view network traffic and is that wich says the throughput I mencioned before (4~6 Mb when inserting in database and 40~50 Mb/s when doing SyncingAll).</DIV>
<DIV> </DIV>
<DIV>
<DIV>This is the output of iostat on primary server</DIV>
<DIV><BR>avg-cpu: %user %nice %sys %iowait %idle<BR> 0.79 0.00 1.54 3.28 94.39</DIV>
<DIV>Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn<BR>sda 120.44 5271.05 1872.72 290326040 103148100<BR>sda1 0.00 0.05 0.01 2928 424<BR>sda2 120.43 5271.00 1872.71 290323088 103147676<BR></DIV></DIV>
<DIV> </DIV>
<DIV>This is the output of iostat on seconday server</DIV>
<DIV><BR>avg-cpu: %user %nice %sys %iowait %idle<BR> 0.32 0.00 1.82 3.58 94.27</DIV>
<DIV>Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn<BR>sda 212.38 1159.70 6143.03 84933272 449898916<BR>sda1 0.00 0.02 0.01 1736 416<BR>sda2 212.38 1159.67 6143.02 84931456 449898500<BR></DIV>
<DIV> </DIV>
<DIV>> </DIV>
<DIV>> and if you are concerned about your database application throughput,</DIV>
<DIV>> how does it compare to the figures you get when not using drbd?</DIV>
<DIV> </DIV>
<DIV>When using drbd connected to secondary the time of an process is 20~30 min.</DIV>
<DIV>When using with drbd disconnect to secondary the time is 4~5 min.</DIV>
<DIV> </DIV>
<DIV>On primary server I have a RAID 10 (0+1) and on secondary server I have only one disk SCSI. Maybe this causing delay too?</DIV>
<DIV> </DIV>
<DIV>> </DIV>
<DIV>> > > and when you talk about sync-nice, you are using drbd 0.6 ?</DIV>
<DIV>> > </DIV>
<DIV>> > Yes, I?m using 0.6.13</DIV>
<DIV>> > </DIV>
<DIV>> > ></DIV>
<DIV>> > > maybe you want to use 0.7 instead. it reduces the amount of data</DIV>
<DIV>> > > transfered to a minimum, thus reducing the time for resynchronization to</DIV>
<DIV>> > > some one to three minutes, typically.</DIV>
<DIV>> > </DIV>
<DIV>> > Well, I?m already compiled 0.7.4, but my question is: I can use the</DIV>
<DIV>> > config file of 0.6 in 0.7? And the drbdsetup commands to replicate and</DIV>
<DIV>> > define primary node are the same?</DIV>
<DIV>> </DIV>
<DIV>> you have to adopt the conf file, syntax has changed.</DIV>
<DIV>> should be easy enough.</DIV>
<DIV>> though, make sure you first read</DIV>
<DIV>> upgrade_0.6.x_to_0.7.0.txt and</DIV>
<DIV>> upgrade_0.7.0_to_0.7.1.txt</DIV>
<DIV>> </DIV>
<DIV>> I don't understand what you mean by "commands to replicate".</DIV>
<DIV>> in general, the interface for 0.7 is the new drbdadm command,</DIV>
<DIV>> and it has a nice little english manpage that should even be complete.</DIV>
<DIV>> </DIV>
<DIV> </DIV>
<DIV>Tanks in advance</DIV>
<DIV> </DIV>
<DIV>> </DIV>
<DIV>> Lars Ellenberg</DIV>
<DIV>> </DIV>
<DIV>> -- </DIV>
<DIV>> please use the "List-Reply" function of your email client.</DIV>
<DIV>> _______________________________________________</DIV>
<DIV>> drbd-user mailing list</DIV>
<DIV>> drbd-user@lists.linbit.com</DIV>
<DIV>> http://lists.linbit.com/mailman/listinfo/drbd-user</DIV>
<DIV>> </DIV>
<DIV>> Esta mensagem foi verificada pelo E-mail Protegido Terra.</DIV>
<DIV>> Scan engine: VirusScan / Atualizado em 22/09/2004 / Vers?o: 1.5.2</DIV>
<DIV>> Proteja o seu e-mail Terra: http://www.emailprotegido.terra.com.br/</DIV>
<DIV>> </DIV>
<DIV>> E-mail classificado pelo Identificador de Spam Inteligente Terra.</DIV>
<DIV>> Para alterar a categoria classificada, visite</DIV>
<DIV>> http://www.terra.com.br/centralunificada/emailprotegido/imail/imail.cgi?+_u=crsurf&_l=1095944996.747869.15443.gravatal.terra.com.br</DIV>
<DIV>> </DIV></DIV>