1 / 66

BP0950 The Progress RDBMS On Linux

Why Are We Here?. ?You can have any two of the following:good, fast, cheap."- an old saying. Why Are We Here?. Wrong! You can have all three.The Progress RDBMS on Linuxis a reliable,high performance,cost-effectivedatabase server system.. To Prove This:. Once again, we convened at a bunker i

chibale
Download Presentation

BP0950 The Progress RDBMS On Linux

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. BP0950 The Progress RDBMS On Linux John Harlow, BravePoint Dan Foreman, BravePoint Gus Björklund, Progress

    2. Why Are We Here?

    3. Why Are We Here?

    4. To Prove This:

    5. But:

    6. Topics

    7. Topics

    8. Goals Show some effects of database tuning Compare disk layouts Compare operating systems Compare filesystems

    9. Topics

    10. Setup: Test Environment

    11. Test Environment The Bunker

    13. Test Environment Equipment

    14. Test Environment More Equipment

    15. Test Environment The System Administrators

    16. Test Environment Hardware Details

    17. Test Equipment Adaptec 2005s Price $ 214.00 USD “Zero channel” RAID 64-bit 66 MHZ PCI Card Ultra 160 SCSI Up to 15 devices Supported disk configurations: JBOD, RAID 0, 1, 0 + 1, 5, 0 + 5

    18. Test Equipment Zero Channel RAID

    19. Test Equipment 6 IBM Disks

    20. Software

    21. Test Environment The ATM Benchmark Simulates teller machine transactions deposit or withdrawal heavy database update workload Each transaction retrieves and updates account, branch, and teller rows creates a history row Run “n” transaction generators concurrently for fixed time period count total number of transactions performed

    22. Test Environment Test Database (logical)

    23. Test Environment Test Database (physical)

    24. Test Environment Test Database (other info)

    25. Test Environment Test Workload Same for all post-setup measurements 150 self-serving clients No think time

    26. Setup: Initial Measurements

    27. The usual careful, detailed records

    28. Setup Measurements

    29. Setup: We Had Some Problems

    30. Problems No telnet to host “windoze” NTLM authentication by default To fix: run TLNTADMN take menu pick no 3 (display/change …) pick 7 (NTLM) set value to 1 take menu pick no 4 (restart service)

    32. More Problems Motherboards came with very old BIOS Adaptec controller is no good did not notice a bad drive cheesy software config stored in controller no driver for Linux 2.5 kernel

    33. Still More Problems tux’s IP address stopped working after several days We think it was a neighbor’s wireless network We ran out of beer. Dan and I did not agree about bi empty buffer waits

    34. Aside: Cygwin We set up Cygwin on Windows so Unix ATM scripts could be used Used it a little bit Works Looks pretty good Minor issue with device pathnames cygwin download is HUGE No chance to fully explore Abandoned while diagnosing machine problems

    35. Topics

    37. Caution: Your Mileage May Vary Some results are very system or hardware dependent

    38. Results The Baseline Tuning Effects Disk Effects Operating System Effects

    39. The Baseline A “standard” configuration Used to make comparison easier Same basic configuration for all tests Vary thing we want to study

    40. Baseline Data and Results

    41. Exploring TPS by Number of Clients

    42. Exploring 95 % Response Time by Number of Clients

    43. Baseline Results (on RedHat 7.3): 295 TPS

    44. Tuning Effects

    45. Tuning -spin (on RedHat)

    46. Tuning -B (on RedHat)

    47. Tuning miscellany (on RedHat)

    48. Disk Effects

    49. Disk Layouts (RedHat)

    50. Disk Layouts (Windows)

    51. Disk Location (on Mandrake 9)

    52. Stripe Size

    53. Controller VS Linux Striping

    54. Linux File Systems

    55. Operating System Effects

    56. Operating Systems

    57. Operating Systems

    58. Best Numbers

    59. Summary Of Results Larger stripe size is better RAID 5 is slow JFS slightly better than ext3 ReiserFS is still very erratic Outer region of disk fastest Operating systems pretty close Win2k 12 % faster than RH on baseline Linux striping beats Adaptec but not by much Adaptec beats Windows striping

    60. Topics

    61. Good Things To Do Ensure drivers exist for your system Use quality hardware 3ware Escalade controller was better than Adaptec Lots of memory Many spindles Have spares Have service/support contracts Use recent kernels not too old, not too new Backups

    62. Things To Avoid Crappy disk controllers 2.5 kernel ReiserFS Consultants with no Linux experience Fixing things that are not broken Do not join the “patch of the week” club

    63. Topics

    64. Netting It Out Linux and Progress is a great combination Great performance at very reasonable prices Use quality hardware Set the database up properly Enjoy the ride

    66. What is the correct way to pronounce “Linux” anyway?

More Related