How to use the MySQL Trigger for database with Whitelist IPs

Help
, , ,
1

Hi all,

I am new to Pipedream and would like to get your help here.

Here is the workflow that I would like to complete:
Every time when there is new or updated row in a specific MySQL table, the trigger fires and the workflow sends this row’s data to Slack.

It should be easy if my database doesn’t require whitelisted IPs; however, I found that Pipedream doesn’t have a list of IPs.

I have also checked this example, but the UI looks different from mine and I cannot set up a SSH connection in the current workflow.

Could anyone let me know how to properly set it up?

setup page
setup page988×600 48.2 KB

Thanks for your time!

2

Hi @pettsup ,

First off, welcome to the Pipedream community. Happy to have you!

That’s a good question, we do offer a reverse HTTP proxy for team subscribers.

But it don’t believe it could be used for MySQL connections, you’d need a SSH tunnel for that directly to the workflow as you mentioned.

The MySQL source could be extended to accept an SSH connection as props. Here’s the source code for that source: pipedream/new-row.js at master · PipedreamHQ/pipedream · GitHub

You’d still have to manage your own box that accepts SSH connections from your workflow, but would that be a workable solution?

We accept PRs for sources & actions in our public registry as well, or you can deploy your own privately created sources too with our CLI.

3

Hi Pierce,
Thanks for your reply.
I am not a developer and I guess Pipedream is too advanced for me to set it up. :joy: