- The binlog file number that contains the START TRANSACTION record for the transaction that is being identified
- The record offset of that record
Many Oracle GoldenGate users are familiar with creating Oracle GoldenGate replication for Oracle Databases without downtime. During this process, it's important to complete the initial loading and make the accurate transition to change data capture (CDC) replication. When performing initial loading for Oracle databases, the CSN (Committed Sequence Number) number is used to start the CDC replication. However, MySQL database doesn't have the CSN number then we have to use the followings to start the CDC replication:
When working on IT projects, I found that choosing the right technology and tools is not enough. How business and processes operate also plays an important role. DevOps (#DevOps), is an important practice for many IT projects. The word comes from the phrases "software DEVelopment" and "information technology OPerationS". It refers to a set of IT practices aiming at shortening IT project cycles, improving the project quality and making IT professional's job less stressful. This blog explores its core concepts and includes links to some of my favorite books and online resources.
In summary, there are three core concepts explored:
I got a request today from a customer to look into the conflict resolution and detection (CDR) configuration. This lets me spend some time reviewing my blog on the CDR. In summary, there are two typical strategies when implementing CDR:
Oracle GoldenGate for Oracle supports DDL replications. After Oracle GoldenGate 12.1.2, you no longer need to run the SQL scripts such as marker_setup.sql and ddl_setup.sql to set up the DDL replication. Using the GoldenGate Integrated Capture for Oracle Database, the native DDL replication is very easy to set up. This blog explains the configuration and gives an example.
Oracle GoldenGate Cloud Service (GGCS) announces its support for Big Data (#BigData) and MySQL (#MySQL) databases. This includes the support for Oracle Big Data Cloud Service, Oracle MySQL Cloud Service and the on-premise Big Data and MySQL databases. Both Big Data and MySQL support are delivery only by GGCS. The following Big Data and No SQL repositories are supported:
(The image is from Oracle Documentation.)
Oracle GoldenGate Manager is the controller process that instantiates the Oracle GoldenGate processes. Oracle GoldenGate Manager requires opening TCP/IP (#TCPIP) ports for both itself and the local processes. The ports are configured with the PORT and DYNAMICPORTLIST parameter in the manager configuration. This blog explains the purposes for opening these ports. [Read More]
Tag: Oracle GoldenGate, TCP/IP Port
When using Oracle GoldenGate in mission-critical systems, you need to have the following high availability (HA/#HighAvailability) considerations:
Tag: Oracle GoldenGate, High Availability
"GFI's study shows that 79% of IT staff are actively considering leaving their current role due to job-related stress, despite apparent economic and staffing improvements in many businesses across the US." Because IT professionals work in such highly stressed environment (#IT+#Stress), IT services or applications then have to provide a friendly user interface to alleviate the stress. Visualization is a useful method for this purpose.
In this blog, I discuss four types of my favorite IT visualizations (#IT #Visualization) and their variations including timeline, geo-graph, bar chart and the modified pie chart. The discussion goes through some examples and explains why and when they can be used to present and analyze the data for IT professionals. To me, a good visualization will do at least two things: telling a story and entertaining the audience. In other words, visualization would deliver a clear message while being fun and grabbing reader's attention. [Read More]
Tag: Data Science, Visualization
I recently got several inquiries on "What is supported by Oracle GoldenGate for JD Edwards (#JDE)?". To answer the question, I just updated my previous note and made it up-to-date. In summary, Oracle GoldenGate supports creating operational reporting for Oracle JD Edwards EnterpriseOne. In this deployment, you can select tables for Oracle GoldenGate to replicate from the primary JD Edwards EnterpriseOne database to a secondary instance. By creating an operational reporting repository, you can:
Tag: Oracle GoldenGate
This blog discusses how you can configure Oracle GoldenGate to perform a real-time data capture from the AWS MySQL RDS database.The described approach creates a MySQL slave database on AWS EC2 first, and then configures Oracle GoldenGate for MySQL to capture from the MySQL slave database. To enable Oracle GoldenGate to capture from the master database, you need to set log_slave_updates=1 in my.cnf file of the slave database. The same approach can be used to capture from Amazon Aurora Database on AWS RDS. [Read More] for the detailed steps.
While working on this, I hit some errors as follows:
Hope these are helpful.
Tag: Oracle GoldenGate for MySQL, AWS RDS, AWS EC2, AWS Aurora
Blogs in 2017
What you read here are my words and views.