barryf + mysql   64

MySQL replication listener based on ruby-binlog. Kodama provides a simple DSL to easily write your own replication listener. Can be used to do things like replicate from MySQL to Postgres, etc.
database  mysql  ruby  replication  binlog 
december 2012 by barryf
5 subtle ways you’re using MySQL as a queue, and why it’ll bite you
Percona on why MySQL (or any database) is a bad choice for a queue
queue  database  mysql  percona 
september 2011 by barryf
Automatic Reconnection of MySQL Connections in Active Record
Active Record since version 2.3 supports this reconnect option. Per default it's set to false, but it can be enabled by adding reconnect = true to database options in database.yml.
activerecord  rails  mysql  ruby 
april 2010 by barryf
Saying Yes to NoSQL; Going Steady with Cassandra
Commentary of Digg's move from MySQL to NoSQL through Cassandra
cassandra  digg  nosql  mysql  database  architecture 
march 2010 by barryf
Riding Rails: Upgrading to Snow Leopard
Rails specific instructions, including Passenger, MySQL, Macports
rails  snowleopard  mac  macports  mysql  ruby  passenger 
september 2009 by barryf
Peeping into memcached
Find out what's happening under the memcached covers. With examples on how to buld load the data into MySQL for analysis.
peep  memcached  analysis  ptrace  mysql  sysadmin 
april 2009 by barryf
Sphinx 0.9.9-rc2 - with SphinxQL
It now pretends to be a MySQL database so you can write SELECT queries
database  mysql  sql  sphinx  search 
april 2009 by barryf
2009 Rubyist's guide to a Mac OS X development environment
Up-to-date (currently) opinionated list of the author's Mac Rails setup with Git, MySQL, Vim, gems and Fluid apps
rails  mac  setup  tutorial  git  ruby  mysql  vim  fluid 
april 2009 by barryf
xtrabackup-0.3, binaries and stream backup
Hot backup InnoDB databases to a remote box via a stream
mysql  backup  innodb  stream  dba  sysadmin  work  database 
march 2009 by barryf
Jet Profiler for MySQL
Java desktop MySQL profiler using native commands such as SHOW PROCESSLIST
java  database  debug  profiler  optimisation  dba  sysadmin  monitoring  mysql 
march 2009 by barryf
How FriendFeed uses MySQL to store schema-less data
Compressed python pickles are stored in an entities table with other tables storing indexes of this data. Uses normal MySQL replication and transactions via InnoDB but without time-consuming index rebuilds whenever they add features.
friendfeed  mysql  scaling  index  database  replication  sharding  innodb 
february 2009 by barryf
Perl script that suggets improvements to your MySQL config
mysql  mysqltuner  optimise  performance  database  perl  dba  sysadmin  work 
december 2008 by barryf
Scaling Out
Facebook's two data centres: for each update they include instruction in MySQL replication log to expire the object in memcache. Whenever user updates their data a cookie is set and for next 20s the LB uses Level 7 to send them to the master data centre so the slave has time to catch up and expire the cache.
facebook  architecture  dev  data  loadbalancer  level7  scaling  web  mysql  replication  database  cache  memcache 
august 2008 by barryf
Hugely useful MySQL parameter. The post's author says he'll often design an application without indexes and then use this parameter (in development) to add indexes where needed
mysql  tuning  performance  index  database  application  dev  logging  sql 
august 2008 by barryf
Drizzle, Clouds, "What If?"
A new project to create a slimmed down MySQL targeted at web apps - UTF8, InnoDB and no stored procedures or other guff
mysql  web  community  database  opensource  utf8  innodb 
july 2008 by barryf
Unicode Data with PHP 5 and MySQL
Don't forget to SET NAMES 'utf8' before you write
utf8  php  mysql  unicode  dev  web  i18n 
june 2008 by barryf
Slick database diagrammer for Mac. Will also generate DDL and other database functions
database  sql  mac  mysql  entity  er  editor  diagram  design 
june 2008 by barryf
The Death of Read Replication
Build objects from data stored in MySQL and push those objects into memcached
mysql  replication  memcached  scalability  caching  database  scaling 
april 2008 by barryf
Asaph Microblog
Crazily simple tumblelog system that makes it trivial to post quotations and images in an attractive grid-based layout. PHP and MySQL.
blog  tumblelog  photo  quotation  php  mysql  microblog  web 
march 2008 by barryf
Master/Slave Databases with Ruby on Rails
Masochism: split reads and writes to two different databases
rails  database  activerecord  mysql  replication  clustering  plugin  scaling  masochism 
march 2008 by barryf
Jeremy Cole on MySQL Replication
"As you probably know MyISAM uses buffered IO so if master crashes you’re out of sync anyway - whatever sync_binlog option was set to"
mysql  performance  replication  myisam  innodb  sysadmin  database 
february 2008 by barryf
Downloadable tumblelog engine in PHP/MySQL
blog  tumblelog  cms  mysql  php  web 
january 2008 by barryf
Using MacPorts(DarwinPorts) to install Ruby on Rails, MySQL, Subversion, Capistrano and Mongrel on Mac OS X
I only really needed this for setting up MySQL5 on Leopard using Macports. Remember - you must use +server or the plist isn't created
macports  mysql  mac  package  leopard 
november 2007 by barryf
KYTCR Part 1: Backups
MySQL and SVN offsite scripted backups
backup  howto  mysql  rsync  ruby  rails  svn  subversion  dev 
november 2007 by barryf
Multiple Database Connections in Ruby on Rails (ActiveDelegate)
Enables master/slave replication arrangements - write to master; read from slave
rails  database  activerecord  deployment  performance  replication  scaling  mysql  server  sysadmin  dev 
october 2007 by barryf
MySQL Toolkit
Debugging and analysis tools
mysql  database  debug  analysis  dev  sysadmin 
september 2007 by barryf
Roll your own SQL session store
A more efficient Rails session storage than ActiveRecordStore - avoids overhead of
database  mysql  rails  server  sessions  performance  sql  dev  web 
january 2007 by barryf
Sphinx - Open Source SQL Full Text Search Engine
High performance full text text engine for MySQL
mysql  sphinx  text  database 
november 2006 by barryf
Unable to instantiate logger class 'com.mysql.jdbc.log.Log4JLogger'
Note to self: when using CF, MySQL and the Connector/J driver, adding "logger=com.mysql.jdbc.log.StandardLogger" to the connection string stops this from happening
mysql  coldfusion  database  driver  java  jdbc  log4j  jrun 
february 2006 by barryf
DB Designer 4
Open source ER model designer. Includes reverse-engineering and synchronisation features
opensource  database  design  dev  free  mysql 
december 2005 by barryf
SQL Relay
Persistent database connection pooling
database  mysql  postgresql  network 
august 2005 by barryf
MySQL Slow Query Log File
How to log queries of >1 second
mysql  database 
february 2005 by barryf
MySQL Gotchas
Ouch. Time to switch to PostgreSQL.
database  mysql 
september 2004 by barryf

related tags

activerecord  address  advocacy  amazon  analysis  apache  application  architecture  aws  backup  binlog  blog  cache  caching  cassandra  cheatsheet  client  clustering  cms  cocoamysql  code  coldfusion  commercial  community  consulting  country  data  database  dba  debug  deployment  design  dev  diagram  digg  django  driver  edit  editor  entity  er  explain  facebook  fluid  free  friendfeed  geo  geocode  git  hadoop  howto  i18n  index  innodb  ip  java  jdbc  joyent  jrun  leopard  level7  lighttpd  loadbalancer  localisation  location  log4j  logging  lookup  mac  macports  masochism  master  memcache  memcached  metadata  microblog  migration  model  mongrel  monitoring  mv  myisam  mysql  mysql5  mysqltuner  network  nosql  opensource  optimisation  optimise  oracle  package  pager  passenger  peep  percona  performance  perl  photo  php  plugin  postgres  postgresql  productivity  profiler  ptrace  query  queue  quotation  rails  rake  recommendation  recommender  reference  replication  rsync  ruby  s3  scalability  scaling  schema  schemaless  search  server  sessions  setup  sharding  snowleopard  sphinx  sql  startup  stream  subversion  suggestion  svn  sysadmin  tee  text  tumblelog  tuning  tutorial  unicode  upgrade  utf8  utf8mb4  vim  web  work  workbench 

Copy this bookmark: