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 laterInformation 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 |