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 SEPTEMBER 22, 2023

Applies to:

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


Consider the following Innodb cluster setup:

                                                 Clients  ( Source IP: )



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




                      |                                |                                  |

                      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? 


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

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