Hosting multiple apps on a single Appwrite VPS

I have a decently spec'd VPS with excess capacity provisioned currently powering an existing project. I am going to start work on a second project and want to leverage the same Appwrite instance with by creating a second Project however how do I add a second custom domain to the same appwrite VPS ?

I have an existing project1.myappwrite.com with VPS IP configured as domain redirect. Now for project2.myappwrite.com I configure the same IP Address ? or do I purchase a new public IP ? any one has experience with running multiple projects of the same Appwrite instance ?

you can use custom domains per project, right? like with CNAME routing to the host appwrite domain?

See if this helps -
https://appwrite.io/docs/advanced/platform/custom-domains

I already have 1 custom domain configured and the domain DNS has the VPS IP configured. Now when I add a 2nd custom domain do I add the same VPS IP to that as well ? the traffic separation is something appwrite manages ?

Afaik the custom domain setup on appwrite doesn't require IP but a CNAME.

You'll have to navigate to your project > settings > custom domains.

add project2.myappwrite.com which will show the steps to add CNAME on your main domain.

In your Website's DNS Settings, add project2 CNAME and point it to the appwrite domain (example: cloud.appwrite.io).