66,583 reputation
1070156
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 8 months
seen 22 mins 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


2d
reviewed Close How do you generate large OLTP and reporting workloads?
2d
reviewed Leave Open SQL server query is slow *without* including execution plan
2d
reviewed Close dynamic table can't be accessed by the users
2d
reviewed Close How to find out duplicate rows by using oracle 10g forms
2d
reviewed Close How to limit results using join in SQL in php
2d
reviewed Close Subqueries in SQL Server 2014
2d
reviewed Close DB Model for Small requiremnt
2d
reviewed Close Explicit transactions for each DML query are necessary or not?
2d
reviewed Close PostgreSQL how to change to Repeatable read
2d
reviewed Close Roomwise track of beds sql server table design
2d
reviewed Close Oracle SGA memory areas
Oct
17
reviewed Looks OK Fourth inner join to the same table increases query duration significantly
Oct
17
comment Integrity constraint violation in Percona XtraDB Cluster
You could use two CNAMEs, 1 that points a specific node as a Master, and the other CNAME shoudl be assigned to a floating load-balanced VIP for SELECTs that can round-robin among the three servers. That may take some additional coding for using two DBVIPs.
Oct
17
revised Any known issues upgrading from MySQL 5.1.73 to 5.6.21?
added 138 characters in body
Oct
17
revised What goes well to link with java? MySQL or Oracle XE?
added 30 characters in body; edited tags; edited title
Oct
17
revised Any known issues upgrading from MySQL 5.1.73 to 5.6.21?
added 605 characters in body
Oct
17
answered Any known issues upgrading from MySQL 5.1.73 to 5.6.21?
Oct
17
reviewed Reopen How to handle big table?
Oct
17
reviewed Leave Closed Study material for Advanced Databases module inc SQL, Relational Model, ERM & TM
Oct
17
revised Mysql Create table shows ERROR 1005 errno 150
edited tags