My Oracle Support Banner

How To Record Actual Client IP Information Into Audit Log While Connecting Innodb Cluster Node Through Router? (Doc ID 2750749.1)

Last updated on FEBRUARY 10, 2021

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Goal

Consider the following Innodb cluster setup:

                                                 Clients  ( Source IP: xx.xx.xx.xxx )

                                                      |

                                                      v

                                           MySQL Router  ( Router IP: yy.yy.yy.yyy )

                                                      |

                                                      v

                       ----------------------------------------------------------            

                      |                                |                                  |

                      v                               v                                  v

                 MySQL Server           MySQL Server               MySQL Sever

                    (R/W)                        (R/O)                           (R/O)

                   

 

Generally, Audit plugin on the MySQL server records router IP as SOURCE IP for all incoming connections through router instead of actual client IP in audit log event. How to record actual client IP information in the audit log event while connecting cluster nodes through router for auditing? 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.