68,668 reputation
1070160
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 9 months
seen 28 secs ago

One of JEHOVAH's Witnesses (TV)

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


Apr
6
revised Adding slave to existing master-master config in mysql throws Foreign key constraint failed error
added 284 characters in body
Apr
6
revised Adding slave to existing master-master config in mysql throws Foreign key constraint failed error
added 1304 characters in body
Apr
6
revised Adding slave to existing master-master config in mysql throws Foreign key constraint failed error
added 501 characters in body
Apr
5
revised “Site Offline” MySQL server failing to start and stop
added 10 characters in body
Apr
5
revised Adding slave to existing master-master config in mysql throws Foreign key constraint failed error
added 18 characters in body
Apr
5
revised “Site Offline” MySQL server failing to start and stop
added 539 characters in body
Apr
5
answered Adding slave to existing master-master config in mysql throws Foreign key constraint failed error
Apr
5
comment Adding slave to existing master-master config in mysql throws Foreign key constraint failed error
Also, tell me if you are using auto_increment_increment and auto_increment_offset on both masters. Also tell me what version of MySQL you are using (run mysql --version | awk '{print $5}'). Is every table InnoDB or are some tables MyISAM ?
Apr
5
comment Adding slave to existing master-master config in mysql throws Foreign key constraint failed error
First of all, show me the exact mysqldump you used (every option please)...
Apr
5
answered “Site Offline” MySQL server failing to start and stop
Apr
5
revised How to run a cold backup with Linux/tar without shutting down MySQL slave?
added 832 characters in body
Apr
5
revised ibdata1 grows exponentially when innodb_file_per_table is configured
added 5 characters in body; edited title
Apr
5
revised MySQL slave stuck in “Reading event from the relay log”?
added 24 characters in body
Apr
5
revised MySQL slave stuck in “Reading event from the relay log”?
added 1940 characters in body
Apr
5
revised Refactoring/normalization - but almost empty table
Removed mysql tag because there is nothing mysql-specific mentioned; added database-design tag
Apr
5
comment “Site Offline” MySQL server failing to start and stop
Please run df -h /var/lib/mysql
Apr
5
revised How to JOIN two table to get missing rows in the second table
edited tags
Apr
5
reviewed Edit suggested edit on
Apr
5
revised
deleted 1 characters in body
Apr
5
reviewed Approve suggested edit on