64,838 reputation
1065150
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 7 months
seen 54 mins ago

One of JEHOVAH's Witnesses

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

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


Sep
11
reviewed No Action Needed Sync MYSQL to MSSQL
Sep
11
revised Getting root node for a given leafs IDs
added 273 characters in body
Sep
11
answered Getting root node for a given leafs IDs
Sep
11
comment Should we enable innodb_file_per_table for single tenant SaaS app (thousands of databases)
+1 for a very thorough answer !!!
Sep
11
awarded  Revival
Sep
10
answered query to select data between todays date as well as tomorrows date time upto specific time
Sep
10
reviewed Close Selecting a row and row above
Sep
10
reviewed Leave Open Amazon: How to change database name in Amazon RDS MySQL?
Sep
10
reviewed Reviewed How to copy database from server to local macine in SQL Server Management studio?
Sep
10
reviewed Reviewed Send email when some users connect to SQL Server
Sep
10
revised Using Galera for simple master-master replication
edited body
Sep
10
revised Using Galera for simple master-master replication
added 447 characters in body
Sep
10
awarded  Notable Question
Sep
10
revised Is it mandatory to enable --log_slave_updates with MySQL Replication using GTID?
edited title
Sep
10
revised How to backup large MongoDB database
edited body
Sep
10
revised Is it mandatory to enable --log_slave_updates with MySQL Replication using GTID?
added 1101 characters in body
Sep
9
comment Is it mandatory to enable --log_slave_updates with MySQL Replication using GTID?
Gotta commute home, I'll amend later.
Sep
9
comment Is it mandatory to enable --log_slave_updates with MySQL Replication using GTID?
@jynus you are right. I don't use GTID. I guess I am just old school since I am comfortable with binlog coordinates (file and position). I have seen coworkers in my past jobs set it up, have replication break for a variety of reasons, and have a difficult time setting replication back up with GTIDs. My current job does not use it either.
Sep
9
comment How to force MySQL/MariaDB to show numbers in scientific notation?
Right you are. Never once though about NULLs and negatives. +1 !!! Sorry reached my voting limit already.
Sep
9
revised Is it mandatory to enable --log_slave_updates with MySQL Replication using GTID?
edited tags