I have a system which performs many actions frequently and am looking at splitting databases up a bit to spread out the load and speed up the system hopefully.
The fear is that by splitting up these databases is that transactions may become out of sync.
My question is, if I split up my databases. Can I still perform transactions on say 3 to 6 databases at the same time? Meaning, if there's some sort of err, roll them all back at the same time?
Edit: Am looking at splitting up the databases since there's certain areas that will be called frequently but are unrelated to each other.
Edit 2: By database I mean a separate machine. Which I’m now seeing instance is probably the word I should use.