RolandoMySQLDBA

41,435 reputation

528108

bio	website	logicworks.net/products
	location	New York, NY (USA)
	age	48
visits	member for	2 years, 3 months
	seen	3 hours ago
stats	profile views	4,557

One of JEHOVAH's Witnesses (Ex 6:2,3; 9:16; Isa 12:2,4,5)
Senior MySQL DBA (SCMDBA since 2007-08-11) with LogicWorks, provider of The Cloud Your Way (LinkedIn,Twitter,FaceBook). I currently support various MySQL Replication Topologies (Master/Slave, Master/Master, DRBD, Percona XtraDB Cluster) for Clients of Managed DB Services (Hardware and High Availability) in DB/Web/Cloud Hosting Environments (60+ MySQL Clients) since November 12, 2007.

	41,435 reputation	bio	website	logicworks.net/products	visits	member for	2 years, 3 months
528108 badges		location	New York, NY (USA)		seen	3 hours ago

summary answers questions tags badges favorites bounties reputation activity

8,378 Actions

suggestions reviews revisions comments badges posts accepts all

Nov 30	revised	What is the best approach to run a DELETE query on 92K of 4 million rows? edited title
Nov 30	revised	Webapp & MySQL: Row Level Security edited title
Nov 30	revised	How can I check the status of transactional replication? edited tags; edited title
Nov 30	revised	Are there any free online collaboration database schema tools? edited title
Nov 30	revised	mysql db backup excluding specific tables deleted 4 characters in body
Nov 30	revised	Visualization of MySQL/PostgreSQL table structure as a graph/UML edited title
Nov 30	revised	Is it advisable to have MySQL Master/Slave running on the same physical server, on the same mysqld, sharing the same disk? added 188 characters in body
Nov 30	revised	Is it advisable to have MySQL Master/Slave running on the same physical server, on the same mysqld, sharing the same disk? edited title
Nov 30	revised	Is it advisable to have MySQL Master/Slave running on the same physical server, on the same mysqld, sharing the same disk? added 188 characters in body
Nov 30	answered	Is it advisable to have MySQL Master/Slave running on the same physical server, on the same mysqld, sharing the same disk?
Nov 30	revised	mysql db backup excluding specific tables edited tags
Nov 30	revised	mysql db backup excluding specific tables edited tags
Nov 30	comment	mysql db backup excluding specific tables This is as StraightForward an answer as possible. +1 !!!
Nov 29	revised	Webapp & MySQL: Row Level Security added 3 characters in body
Nov 29	comment	What is the best approach to run a DELETE query on 92K of 4 million rows? I like `DELETE QUICK` for MyISAM (specified in your link) because it does what OPTION 2 in my answer does. +1 !!!
Nov 29	revised	Webapp & MySQL: Row Level Security edited title
Nov 29	answered	Webapp & MySQL: Row Level Security
Nov 29	revised	What is the best approach to run a DELETE query on 92K of 4 million rows? edited title
Nov 29	comment	mysql replication deadlock slave stopped This answer is exactly what is recommended in the error message. (+1) I did this as well for my clients as long as my clients are aware of it. I sometimes get this condition when the master's execution of the query is interrupted but still gets recorded in its binary logs, thus letting it get replicated to the slave. The slave caught that condition and nicely gave the option of having the SQL re-executed.
Nov 29	revised	Is there a max allowance for entries in a table in mysql? added 489 characters in body