118 reputation
212
bio website melikedev.com
location Murrieta, CA
age 41
visits member for 2 years, 10 months
seen Oct 23 at 3:20

We are working on the next big social media project. If you are interested in the project drop me a line @ mike.purcell@shouttag.com.


Oct
21
comment HA - MySQL Master Master replication - Duplicate entry errors
I've actually seen single write master-master replication work in environments serving 200+ million hits per month. Perhaps it's not the ideal solution (still subjective imo), but at this juncture, I have no other alternative. As we are bootstrapping, we are lucky to even have this level of fault tolerance. +1 for the suggestions tho.
Oct
19
asked HA - MySQL Master Master replication - Duplicate entry errors
Aug
15
comment MySQL Replication - Master Master - Single Master write
Doh, already puppetized those changes :( . Ok I'll back out. Rather just replicate all databases in case new ones are added in the future, without having to add to a puppet config, and re-run puppet on masters. Thanks again.
Aug
15
revised MySQL Replication - Master Master - Single Master write
added 2 characters in body
Aug
15
accepted MySQL Replication - Master Master - Single Master write
Aug
15
revised MySQL Replication - Master Master - Single Master write
added 1268 characters in body
Aug
13
asked MySQL Replication - Master Master - Single Master write
Jul
22
awarded  Notable Question
Jul
2
awarded  Curious
May
19
awarded  Notable Question
Apr
18
awarded  Benefactor
Apr
18
comment MySQL - Best long read query solution within a replication based system
Thanks for the clear and concise breakdown.
Apr
18
accepted MySQL - Best long read query solution within a replication based system
Apr
11
awarded  Promoter
Apr
8
revised MySQL - Best long read query solution within a replication based system
added 23 characters in body
Apr
8
asked MySQL - Best long read query solution within a replication based system
Feb
25
awarded  Popular Question
Nov
1
awarded  Popular Question
Oct
25
comment MySQL - Add index to low cardinality text column?
Nice. Appreciate the write-up. I actually ended up converting the enums to varchars, then added the indices. Took some refactoring on the lower level api, but seems to work well.
Oct
25
comment MySQL - Add index to low cardinality text column?
I ended up fixing the lower layer code to accept enums, but convert to varchars, so now I can add indices. Thanks again, as I learned something new.