<h2 dir="auto">Bug Report</h2>
<p dir="auto"><strong>For English only</strong>, other languages will not accept.</p>
<p dir="auto">Before report a bug, make sure you have:</p>
<ul dir="auto">
<li>Searched open and closed <a href="https://github.com/apache/shardingsphere/issues">GitHub issues</a>.</li>
<li>Read documentation: <a href="https://shardingsphere.apache.org/document/current/en/overview" rel="nofollow">ShardingSphere Doc</a>.</li>
</ul>
<p dir="auto">Please pay attention on issues you submitted, because we maybe need more details.<br>
If no response anymore and we cannot reproduce it on current information, we will <strong>close it</strong>.</p>
<p dir="auto">Please answer these questions before submitting your issue. Thanks!</p>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">5.1.0</p>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">ShardingSphere-Proxy</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">apache flink cdc connector work together with apache shardingsphere</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">when use apache ShardingSphere as cdc datasource,it will cause a error when cdc try to enum the database tables:</p>
<h3 dir="auto">Reason analyze (If you can)</h3>
<p dir="auto">ShardingSphere is missing the information_schema database which provider the metadata information of the instance databases,may be that's the reason?</p>
<h3 dir="auto">Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.</h3>
<p dir="auto">reference issue:<br>
<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1223905815" data-permission-text="Title is private" data-url="https://github.com/ververica/flink-cdc-connectors/issues/1148" data-hovercard-type="issue" data-hovercard-url="/ververica/flink-cdc-connectors/issues/1148/hovercard" href="https://github.com/ververica/flink-cdc-connectors/issues/1148">ververica/flink-cdc-connectors#1148</a></p>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>
<p dir="auto">reference issue:<br>
<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1223905815" data-permission-text="Title is private" data-url="https://github.com/ververica/flink-cdc-connectors/issues/1148" data-hovercard-type="issue" data-hovercard-url="/ververica/flink-cdc-connectors/issues/1148/hovercard" href="https://github.com/ververica/flink-cdc-connectors/issues/1148">ververica/flink-cdc-connectors#1148</a></p>
<h2 dir="auto">Preface</h2>
<p dir="auto">currently the agent module use <code class="notranslate">maven shade plugin</code> as the solution for dependency conflict, however this makes a lot of dependency duplication in different plugin modules, followings are the plugins :</p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/4112856/209263808-0a3da44b-8bdd-47a5-abb9-b39a57b84236.png"><img src="https://user-images.githubusercontent.com/4112856/209263808-0a3da44b-8bdd-47a5-abb9-b39a57b84236.png" alt="image" style="max-width: 100%;"></a></p>
<p dir="auto">the shaded guava are duplicated in all plugin artifact:<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/4112856/209263906-3a6892b1-99c1-4415-aa76-2a86b043f802.png"><img src="https://user-images.githubusercontent.com/4112856/209263906-3a6892b1-99c1-4415-aa76-2a86b043f802.png" alt="image" style="max-width: 100%;"></a><br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/4112856/209263921-164cabe3-ba7f-4817-9488-843b76513547.png"><img src="https://user-images.githubusercontent.com/4112856/209263921-164cabe3-ba7f-4817-9488-843b76513547.png" alt="image" style="max-width: 100%;"></a></p>
<h2 dir="auto">Missions</h2>
<p dir="auto">to refactor the agent packaging, we need to refactor followings :</p>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> add shaded dependency in bootstrap module</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> add exclusions in plugins to make the plugin artifact smaller</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> extract the metrics-core seperately</li>
</ul>
<h3 dir="auto">Shaded Dependencies</h3>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/4112856/209606709-04246875-3ea4-4060-89f0-b6a515dc77df.png"><img width="403" alt="image" src="https://user-images.githubusercontent.com/4112856/209606709-04246875-3ea4-4060-89f0-b6a515dc77df.png" style="max-width: 100%;"></a></p>
<h3 dir="auto">Reduce Size</h3>
<p dir="auto"><strong>before</strong><br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/4112856/209593377-8594f09e-2657-47ee-b011-0494dfd167ef.png"><img width="1627" alt="image" src="https://user-images.githubusercontent.com/4112856/209593377-8594f09e-2657-47ee-b011-0494dfd167ef.png" style="max-width: 100%;"></a></p>
<p dir="auto"><strong>after</strong><br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/4112856/209600549-7d2f0537-5b89-4ba3-815b-e182fe1d96c5.png"><img width="1633" alt="image" src="https://user-images.githubusercontent.com/4112856/209600549-7d2f0537-5b89-4ba3-815b-e182fe1d96c5.png" style="max-width: 100%;"></a></p>
<p dir="auto">the plugins reduced from <strong>63.2MB</strong> to <strong>12.1MB</strong></p>
<h3 dir="auto">extract metrics-core</h3>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/4112856/209606654-b0405da8-e72b-4192-8ff9-1fe06fdfe9c5.png"><img width="659" alt="image" src="https://user-images.githubusercontent.com/4112856/209606654-b0405da8-e72b-4192-8ff9-1fe06fdfe9c5.png" style="max-width: 100%;"></a></p>
<h2 dir="auto">Test</h2>
<h3 dir="auto">Prometheus</h3>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/4112856/209606746-0823b405-f349-453d-9978-1885601631f4.png"><img width="890" alt="image" src="https://user-images.githubusercontent.com/4112856/209606746-0823b405-f349-453d-9978-1885601631f4.png" style="max-width: 100%;"></a></p>
<h3 dir="auto">Zipkin</h3>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/4112856/209606779-20c8d9e7-d1d5-4601-bcc1-fcc43899b622.png"><img width="1485" alt="image" src="https://user-images.githubusercontent.com/4112856/209606779-20c8d9e7-d1d5-4601-bcc1-fcc43899b622.png" style="max-width: 100%;"></a></p>