I’m thinking of moving my code over to Relativity but have a couple of questions…
We write restaurant software and have a MySQL instance running on Amazon with many databases within it which all have an identical structure. i.e. each restaurant has it’s own seperate database.
I’ve linked up Relativity to our server and I’ve set up a schema called “Restaurant” and added 2 connections into this schema which point to 2 restaurant database (identical db structures as explained above)
How does the client let the Relativity Server know which connection to use within the schema? Am I approaching this in the wrong way, should I have a schema set up for each restaurant with a single connection defined in each?
I’d prefer to have a single schema if possible, it would just keep things a lot neater.
Hopefully I’ve give enough information but please ask if I’ve missed anything out.
I’m using XE7 and the latest version of DataAbstract and Relativity downloaded from the site.
Thanks in advance for any replies!