Hi Heiko, >From an engineering perspective, I genuinely believe you can make anything work. How well it works - how well it copes with faults etc - is where the rubber the meets the road.
If you need fault tolerance, and horizintal scalability (as opposed to vertical scale) - why would you not choose the DB that was designed with that specific purpose in mind from the very beginning? I am not saying you can't successfully develop with MySQL (or PostGreSQL or MS-SQL or XXX) - it has decent sharding and replication schemes that are appropriate and reasonable, a lot of the time. But; If your primary DB concerns are fault tolerance / distributable load - "I" would always go for the one that has "that" as it's primary design philosophy. -Gavin. On Tuesday, 27 October 2015 04:45:37 UTC+11, Justin du coeur wrote: > > Actually, I'll follow up with a more specific question: do folks here have > experience with / opinions about the MySQL backend > <https://github.com/okumin/akka-persistence-sql-async>? > > My IT partner has a very strong preference for MySQL on operational > grounds, and I've gradually convinced myself that it looks plausibly > scalable if you use MySQL's clustering capabilities, which appear to be > roughly isomorphic to Cassandra. (Or, possibly more to my use case, > Amazon's replacements for SQL.) > > In practice, it clearly works okay for the smallish scale -- I'm currently > using it in dev, and everything seems to work as expected. But it would be > enormously useful to me if folks had practical opinions about how well > they've found it to operate, and whether they see any devastating problems > with that approach. > > On Mon, Oct 26, 2015 at 1:24 PM, Heiko Seeberger <[email protected] > <javascript:>> wrote: > >> If you are using Akka Cluster, you should go for a distributed backend >> like Cassandra or Kafka. >> >> Heiko >> >> -- >> >> *Heiko Seeberger* >> Home: heikoseeberger.de >> Twitter: @hseeberger <https://twitter.com/hseeberger> >> Public key: keybase.io/hseeberger >> >> On 26 Oct 2015, at 17:49, [email protected] <javascript:> wrote: >> >> Based on your production experience, what storage backends have worked >> well for akka-persistence? >> >> We are considering postgres because we already use it heavily. Does >> anyone have experience with this? >> >> Is anyone a strong proponent of other storage backends (cassandra, kafka, >> etc)? >> >> Thank You! >> Vikas >> >> -- >> >>>>>>>>>> Read the docs: http://akka.io/docs/ >> >>>>>>>>>> Check the FAQ: >> http://doc.akka.io/docs/akka/current/additional/faq.html >> >>>>>>>>>> Search the archives: https://groups.google.com/group/akka-user >> --- >> You received this message because you are subscribed to the Google Groups >> "Akka User List" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at http://groups.google.com/group/akka-user. >> For more options, visit https://groups.google.com/d/optout. >> >> >> -- >> >>>>>>>>>> Read the docs: http://akka.io/docs/ >> >>>>>>>>>> Check the FAQ: >> http://doc.akka.io/docs/akka/current/additional/faq.html >> >>>>>>>>>> Search the archives: https://groups.google.com/group/akka-user >> --- >> You received this message because you are subscribed to the Google Groups >> "Akka User List" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at http://groups.google.com/group/akka-user. >> For more options, visit https://groups.google.com/d/optout. >> > > -- >>>>>>>>>> Read the docs: http://akka.io/docs/ >>>>>>>>>> Check the FAQ: >>>>>>>>>> http://doc.akka.io/docs/akka/current/additional/faq.html >>>>>>>>>> Search the archives: https://groups.google.com/group/akka-user --- You received this message because you are subscribed to the Google Groups "Akka User List" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/akka-user. For more options, visit https://groups.google.com/d/optout.
