42,788 reputation
530111
bio website logicworks.net/products
location New York, NY (USA)
age 48
visits member for 2 years, 4 months
seen 1 hour ago
stats profile views 4,818

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.

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


Jun
13
reviewed Close i have to retrive all the rows from multiple table which does not have common field without duplication
Jun
13
reviewed Close Home rolled gridview search results shows rows that are supposed to be ignored
Jun
13
reviewed Close Sybase tools in web
Jun
13
reviewed Reject suggested edit on Difference Between SP with BEGIN/END and without BEGIN/END
Jun
13
reviewed Approve suggested edit on MySQL replication - slave update
Jun
12
reviewed Close Postgres books for a Sql Server DBA
Jun
12
reviewed No Action Needed Infinite Loop While Running Query
Jun
12
revised MySQL: Securing Access using Stored Procedures
added 2 characters in body; edited title
Jun
12
answered MySQL: Securing Access using Stored Procedures
Jun
12
revised BEFORE INSERT trigger in MySQL
added 1 characters in body
Jun
12
comment BEFORE INSERT trigger in MySQL
I addressed your last comment in my answer...
Jun
12
revised BEFORE INSERT trigger in MySQL
added 1 characters in body
Jun
12
revised BEFORE INSERT trigger in MySQL
added 7 characters in body
Jun
12
revised BEFORE INSERT trigger in MySQL
added 1 characters in body
Jun
12
comment BEFORE INSERT trigger in MySQL
I missed the extra semicolon. I'll add it to my answer. If my answer helped you, please mark it accepted.
Jun
12
comment How to recover MySQL table structure from FRM files
The question mentions WAMP so this is a "MySQL for Windows" topic. Although the answer is short, your answer is more of a Linux environment suggestion which is common problem (not to say file permissions doesn't affect Windows as well). When I recently answered this question, dba.stackexchange.com/a/44316/877, I remembered your answer along the lines of file permissions. From this perspective, you get a +1 !!!
Jun
12
reviewed Close MySQL-CLuster PHP5
Jun
12
answered Convert the table PROCESSLIST from InnoDB to MYISAM
Jun
12
revised Performing SELECT on EACH ROW in CTE or Nested QUERY?
edited tags
Jun
11
revised Multiple table rows in one row
edited tags