I’d like to run 3 separate Servoy solutions on the same machine at the same time. The solutions have some table names in common. Each solution includes a web site. Is there a way to do this?
Sure you can do that. You could use a deeplink to the solution directly…
What about the duplicate table names? Won’t they conflict with each other? Or can I really run 3 solutions with duplicate tables names together with no problem?
adamk:
can I really run 3 solutions with duplicate tables names together with no problem?
Yes, you can.
If your solutions don’t use the same data, they should connect to different databases, and then it doesn’t matter if the table names are the same.
On the other hand, if you want your solutions to share the same data, you should use the same database connection for all of them. Then you’ll also have data broadcasting between solutions.
I don’t want the solutions to share data. The 3 solutions are actually 3 different variations of the same solution that are used by customers with different needs.
I forgot to mention something that is probably pretty important. Not only are the table names the same in the 3 solutions, but the database and log file names are also the same. I know I can run multiple solutions at the same time, but can I have Servoy look in multiple database folders to get the database files? Naturally, I can’t have more than 1 file with the same name in 1 folder.
Hi Adam,
If you want 3 different solutions to use their own database then, I think, you have 2 choices.
- rename the database/log files (not sure if you can do that without creating a new one and unload/load, but you might) and point each solution to their own database connection.
- have 3 Servoy server instances each in their own directory and let them run on different port numbers
Hope this helps.
All the solutions have to be hosted on port 80, so I guess I’ll need to unload the database files to new ones with different names. I was hoping I wouldn’t have to do this because of time constraints.
The machine that I want to host 3 solutions on is only a backup for 3 separate machines. In case the 3 machines go down (maybe a truck knocks down the telephone pole outside killing my internet connection or something), I want to be able to quickly move the data to a machine in a different location with as little downtime as possible. Loading and unloading database files takes time.
I’ll look into using virtual machines to see if that will work.
Thanks, everyone, for your help.
adamk:
I want to be able to quickly move the data to a machine in a different location with as little downtime as possible. Loading and unloading database files takes time.
Sounds like you should start considering a Servoy cluster: http://www.servoy.com/generic.jsp?mt=39 … omy_id=895