Re: Questions about:- Multi Servers. Geographically Dispersed. Fault Tolerant Databases

[Mike Lischke]

Hey Tim,

as this is the forum for MySQL Workbench related questions I can only answer your second question. For the others I recommend to ask in the specialized forums for replication, cluster etc.

When it comes to Workbench in your scenario then I don't see any special requirements or tricks that could help to distribute your data. WB is a tool to design a schema and for your task this would be the same on all MySQL instances. So once you have designed your schema (just as you would for any single machine) you then would implement it on all the other boxes. And that's it from the point of WB.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/