For OLTP applications, MySQL rocks!
Also, it's always good to see what the guys from WebScaleSQL are improving.
For example:
https://code.facebook.com/posts/190251048047090/myrocks-a-space-and-write-optimized-mysql-database/
On Wed, Aug 31, 2016 at 2:13 PM, Ryan January <rjanuary@xxxxxxxxx> wrote:
Everyone else has been killing it with their suggestions and I can't add a
whole lot there. Grafana is amazing for visualization. I've used the
percona app, and really do like it. It relies on Prometheus to gather and
persist data behind the scenes. You won't find anything with better
dashboards straight out of the box.
Another potential data source is Telegraf (and the MySQL plugin) dumping
data to InfluxDB. We're using Influx for a great deal of our metrics, so
that route was a little more natural than adding in another data store.
The one thing I would add for anybody else who's curious at alternate
databases; MySQL does seem to be hitting a maturation tipping point. I'm
at a crossroads where I'm seriously considering moving away from Oracle to
focus mostly on MySQL. I feel like I rode the coat tails of the Oracle wave
(starting right after the release of 10.1). I want to get out ahead of the
next thing.
The addition of Performance Schema was huge for me. What MySQL has
historically lacked is instrumentation. PS is a huge step forward into
seeing what the DB is doing internally. Throw the sys schema on top,
making an Oracle DBA feel at home, and it's adding up to having a great
level of potential in the next few years.
Thanks,
Ryan
On Aug 31, 2016, at 11:35 AM, Marko Sutic <marko.sutic@xxxxxxxxx> wrote:
Kyle,
in my humble opinion the best performance book:
High Performance MySQL, 3rd Edition
Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
The best (free) monitoring and visualisation performance tool for MySql:
https://grafana.net/plugins/percona-percona-app
And of course blogs Thiago noted.
Regards,
Marko
On Wed, Aug 31, 2016 at 1:55 AM, kyle Hailey <kylelf@xxxxxxxxx> wrote:
After all the fun with Uber going from Postgres to MySQL (after they had
previous gone from MySQL to Postgres) ...
Does anyone have recommendations on good MySQL forums (like Oracle-L) or
recommend performance blogs or performances books?
I'm looking into ways of monitoring and visualizing performance data in
these databases similar to the work I did with teams at Oracle on OEM and
Embarcadero for DB Optimizer.
Thanks
Kyle
