I would recommend using a 2 part epoxy resin: Gorilla offers a good one. They have high bond strength with a lot of materials and are strong against shearing and tension. Here is an article for more info: https://www.hotmelt.com/blogs/blog/8-benefits-of-using-a-two-part-epoxy

I would recommend using a 2 part epoxy resin: Gorilla offers a good one. 2 part epoxy resins require 2 elements to complete the adhesive solution - a resin and a hardener. Typically after mixing, there is a short curing/ hardening period. Some advantages of this:

• Strong adhesion to similar and dissimilar substrates
• Holds strong against shearing and tension
• very long lasting

Here is an article for more info: https://www.hotmelt.com/blogs/blog/8-benefits-of-using-a-two-part-epoxy