5 ms·

Pretty quiet here. :) Let us know if you have any questions or comments. This was a pretty big project and I think we're the largest deployment of ProxySQL righ

• stevenjohns 11y ago
  Right place for an off-topic feature request? :) I introduced Nylas to a few of my coworkers and one brought up something he felt was lacking: the ability to 'mark all as read.'
  • grinich 11y ago
    Working on it! https://github.com/nylas/N1/issues/886 https://github.com/nylas/N1/issues/886
• rgrove 11y ago
  This was a fantastic post and might save me a lot of headaches in the near future. Thanks for sharing what you learned!
• soccerdave 11y ago
  Really enjoyed your post. I had a question about your usage of ProxySQL. 1) Do you have to update the ProxySQL configuration on your application servers when you do a slave promotion or is that handled automatically? 2) I didn't fully understand how you know which database host has a shard (i.e. shard 22). Is that also part of your ProxySQL configuration?
  • grinich 11y ago
    1) We actually keep the "state" for slave/master in EC2 tags, which are changed via a different mechanism. 2) There's a different configuration for mapping which database hosts exist on which shard. Our system currently has multiple database shards per machine, and that's stored in a configuration that our automation will update when new machines/shards go into production.