Easy, Fast, Secure. Pick any two.
Sql Server, Oracle, DB2, Postgres are all complex because data is not easy when done properly. Learning how to index properly for FAST data retrieval from billion row tables is what takes skill. Skill is also knowing how much time tweaking an index will take is also required when you have windows for maintenance at low use points in the week. I believe that Marina is much the same way.
As a heads up when you have multiple SQL centers around the world generating the next key is a little more complicated. If you were going to have them just around the country for local offices you too will run into this as well. I am just trying to give you a heads up on potential issues that will pop up.
If I were doing this I'd attempt to follow how other leaders in computing systems have done this. You are selling the cloud so it only makes sense that this too will be driven by cloud-oriented technology.
Good luck.
On Wed, Jul 12, 2017 at 5:13 PM, < mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
On 2017-07-12 17:50, Stephen Russell wrote:
I have no MariaDB experience but doing this in SQL Server is not easy as this reads. They are more taking to the idea of local country DBs that interconnect but you are suggesting the same thing I beleive between a few locals and 1 Master.
Honestly, I found M$ SQL Server to be overly complicated on a great many things. That was part of the appeal of MySQL...far less geeky and easy to configure/use.
[excessive quoting removed by server]