66,408 reputation
1069155
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 8 months
seen 5 hours 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
8
reviewed Reject suggested edit on Moving model database
Apr
8
reviewed Approve suggested edit on importing MySQL dump to SQL Server 2012
Apr
8
reviewed Edit suggested edit on plpython tag wiki excerpt
Apr
8
revised plpython wiki excerpt
deleted 3 characters in body
Apr
7
revised MySQL5.6 on Mac OS X 10.6.8 problems when granting permissions to root
edited tags
Apr
7
answered MySQL5.6 on Mac OS X 10.6.8 problems when granting permissions to root
Apr
7
reviewed Approve suggested edit on Trying to create PostGIS database
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