mysql - Speeding up conversion from MyISAM to InnoDB - Stack Overflow
september 2011 by sweeney
I have a MySQL 1.5 GB MyISAM-table (1.0 GB data, 0.5 GB indexes) in production which I'm about to convert into InnoDB.
Since the table is used in production I'd like to make the downtime as short as possible.
mysql
myisam
innodb
Since the table is used in production I'd like to make the downtime as short as possible.
september 2011 by sweeney
astrails's safe at master - GitHub
november 2009 by sweeney
Simple database and filesystem backups with S3 support (with optional encryption)
Home: http://blog.astrails.com/astrails-safe
backup
s3
aws
mysql
linux
Home: http://blog.astrails.com/astrails-safe
november 2009 by sweeney
gist: 205689 - GitHub
october 2009 by sweeney
Discards old snapshots, only keep hourly from last 24 hours and daily for past 7 days.
ruby
mysql
backup
october 2009 by sweeney
Sphinx - Free open-source SQL full-text search engine
march 2009 by sweeney
Sphinx documentation
php
mysql
search
text
engine
sphinx
manual
march 2009 by sweeney
Database Sharding at Netlog, with MySQL and PHP
march 2009 by sweeney
"Sharding is a technique used for horizontal scaling of databases we are using at Netlog. If you're interested in high performance, scalability, MySQL, php, caching, partitioning, Sphinx, federation or Netlog, read on ..."
php
mysql
sharding
netlog
memcached
database
scalability
scaling
march 2009 by sweeney
related tags
amazon ⊕ article ⊕ automatic ⊕ aws ⊕ backup ⊕ caching ⊕ cassandra ⊕ cheatsheet ⊕ cluster ⊕ cron ⊕ database ⊕ dbslayer ⊕ debian ⊕ deploy ⊕ ebs ⊕ ec2 ⊕ engine ⊕ fulltext ⊕ howto ⊕ http ⊕ indexing ⊕ innodb ⊕ large ⊕ linux ⊕ manager ⊕ manual ⊕ memcached ⊕ myisam ⊕ mysql ⊖ netlog ⊕ osx ⊕ performance ⊕ php ⊕ programming ⊕ reference ⊕ ruby ⊕ s3 ⊕ scalability ⊕ scaling ⊕ Script ⊕ search ⊕ sharding ⊕ sphinx ⊕ sql ⊕ storage ⊕ tagging ⊕ tags ⊕ text ⊕ tools ⊕ tutorial ⊕ wordpress ⊕Copy this bookmark: