Skip to content
wade.one

wade.one

wade womersley – york based software engineer

  • Home
  • 2009
  • September
  • 10
  • Linux RAID, MySQL

Linux RAID, MySQL

Posted on September 10, 2009 By Wade 2 Comments on Linux RAID, MySQL
Programming, Software

Ubuntu…it’s a great Linux OS to use on servers due to its speed and simplicity – personal preference based on no statistics, only personal use. However, one thing Linux drives me mad with is software RAID. It’s taken me the better part of a day to set up a few RAID partitions, two of which are joined via LVM (2 lots of mirrored disks, one big “partition” to store stuff on across all 4 disks). Persuading a developer in our office at work that Whitespace is better than PHP or persuading Ben that all graphs are excellent, informative tools would be easier tasks.

It seems that today we’ve managed to solve most of our current MySQL database issues are fixed now too with one very simple change to our Master->Slaves setup – use ROW based binary logging only, not statement. The slaves are now never lagging more than 2-3 seconds behind the master even with thousands of writes per second across around 100 connections.

Share:

  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on X (Opens in new window) X
  • Click to share on Tumblr (Opens in new window) Tumblr
  • Click to share on Pinterest (Opens in new window) Pinterest
  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on Reddit (Opens in new window) Reddit

Related

Comments

comments

Post navigation

❮ Previous Post: The Bear and the Bird Feeder
Next Post: Anti-Gravity Mice ❯

You may also like

Programming
Using Amazon EC2 with C# .net
October 15, 2012
Programming
Another day, another group of PHP “funness”
September 2, 2009
Programming
MongoDB vs DocumentDB
March 26, 2023
Software
Copenhagen User Experience
September 25, 2009

2 thoughts on “Linux RAID, MySQL”

  1. Ben Davies says:
    September 14, 2009 at 09:29

    Man, seriously, where has this myth come from that I hate graphs? It’s the exact opposite: I love graphs! Graphs. I love graphs. Not interactive widgety doohickys with flashing colours, animated slices and hidden data! Not god awful full colour photo backgrounds with multiple, disparate result sets overlaid on poorly picked sources with multiple y value ranges. Y’know, not-graphs.

    Log in to Reply
  2. Wade says:
    September 14, 2009 at 22:32

    So….you don’t like graphs? 😀

    Log in to Reply

Leave a Reply Cancel reply

You must be logged in to post a comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  • AI
  • artificial intelligence
  • Ego-centric
  • Events
  • Films
  • Food
  • Gaming
  • Gym
  • Hardware
  • Holidays
  • News
  • PHP
  • Programming
  • Random Stuff
  • Reviews
  • Science
  • SEO
  • Software
  • Software Engineer
  • Support
  • Uncategorized
  • Work

Copyright © 2025 wade.one.

Theme: Oceanly News Dark by ScriptsTown