RolandoMySQLDBA

41,200 reputation

528108

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

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,200 reputation	bio	website	logicworks.net/products	visits	member for	2 years, 3 months
528108 badges		location	New York, NY (USA)		seen	2 hours ago

summary answers questions tags badges favorites bounties reputation activity

8,330 Actions

suggestions reviews revisions comments badges posts accepts all

Jan 3	revised	what are the conditions under which mysql replication might break? added 90 characters in body
Jan 3	comment	How to convert mysql to postgresql? I am not PostgreSQL expert, still learning myself. I removed my answer. However, there is another question about using mysqldump with postgresql posted by someone else : dba.stackexchange.com/q/9792/877. Hope it helps !!!
Jan 3	revised	Optimized my.cnf for high-end and busy server added 943 characters in body
Jan 3	comment	Optimized my.cnf for high-end and busy server How about a compromise ??? Convert the ROW_FORMAT of all your MyISAM tables to `FIXED` on your Master. This will increase the query speed 20-25% in exchange for 80-100% increase in overall table size. I explained this in bulletpoint #6 under `Replication`.
Jan 3	revised	Understanding mysqltuner Recomendations w/ Unused Catalogs added 80 characters in body
Jan 3	revised	Understanding mysqltuner Recomendations w/ Unused Catalogs edited tags
Jan 3	answered	Understanding mysqltuner Recomendations w/ Unused Catalogs
Jan 3	revised	what are the conditions under which mysql replication might break? added 271 characters in body
Jan 3	revised	what are the conditions under which mysql replication might break? added 12 characters in body
Jan 3	answered	what are the conditions under which mysql replication might break?
Jan 3	comment	Optimized my.cnf for high-end and busy server +1 for Finding Diagnosis before Configuration !!!
Jan 3	revised	Optimized my.cnf for high-end and busy server edited body
Jan 3	answered	Optimized my.cnf for high-end and busy server
Jan 3	comment	Database as a service (DbaaS) over dimensions--performance, scalability, & reliability? @ypercube I am sorry, PostgreSQL is open source. I was referring to storage engine internals.
Jan 3	answered	Database as a service (DbaaS) over dimensions--performance, scalability, & reliability?
Jan 2	revised	Is there a way to find my.cnf in shared hosting? edited tags
Jan 2	answered	LOCK IN SHARE MODE
Jan 2	answered	Is there a way to find my.cnf in shared hosting?
Jan 2	comment	Is splitting a 'users' table for authentication purposes a good idea? @Jannes now I am on the same page. Thank you.
Dec 31	revised	Is splitting a 'users' table for authentication purposes a good idea? deleted 6 characters in body