MySQL 8.0.1 introduces new features and improvements to replication. The next sections summarize some related to performance.
1. WL#9556 – Writeset-based dependency tracking on the master
Transaction writesets can now be used to evaluate which transactions are independent and can be executed in parallel on the binary log applier on the asynchronous slaves.…
From everyone at Percona and Percona Live 2017, we’d like to send a big thank you to all our sponsors, exhibitors, and attendees at this year’s conference.
This year’s conference was an outstanding success! The event brought the open source database community together, with a technical emphasis on the core topics of MySQL, MariaDB, MongoDB, PostgreSQL, AWS, RocksDB, time series, monitoring and other open source database technologies.
We will be posting tutorial and session presentation slides at
the Percona Live site, and all of them should be available
shortly.
Highlights This Year:
Originally, the goal of the benchmark is to compare performance and price/performance of Amazon RDS (Aurora) and MySQL server running on an EC2 instance. MySQL Versions MySQL 5.6 on RDS Aurora on RDS MySQL 5.6 community version on EC2 MySQL 5.7 community version on EC2 Sysbench Test Primary Key lookup queries OLTP workload with mix […]
The post RDS vs. Aurora vs. EC2 Benchmark appeared first on TwinDB.
Dear MySQL Users,
A new GA (general availability) version of MySQL Connector/C has
been
made available: MySQL Connector/C 6.1.10 GA. The MySQL
Connector/C 6.1
implements the MySQL C API for connecting client applications to
the
MySQL Server 5.5 or newer.
You can download the production release at:
http://dev.mysql.com/downloads/connector/c/6.1.html
MySQL Connector C (Commercial) will be available for download on
the My
Oracle Support (MOS) website. This release will be available
on
eDelivery (OSDC) in next month’s upload cycle.
Please see the documentation and the README file in the source
distribution
for a detailed description of bugs that have been fixed.
Enjoy!
Changes in MySQL Connector/C 6.1.10 (2017-04-28,
General
Availability) …
Query Reviews part 2: pt-query-digest
One task that can really help reduce future problems is to do a periodic query review. I’ve been using pt-query-digest to do this since 2010 (back when it was part of Ma’atkit, mk-query-digest!), and while I have presented the idea several times at conferences, I have never blogged about it.
I am going to share a secret with you – I blog not just to share information with YOU, but to share information with ME. Future me. This comes up because I am working on a query review at Salesforce.com for one of our busiest shards. I went to go look up a blog post on using pt-query-digest, because it’s a handy cheat sheet….and….I never did it. So, here goes!
This is the first blog post in what will …
[Read more]Dear MySQL Users,
MySQL Connector/J 5.1.42, a maintenance release of the production
5.1
branch has been released. Connector/J is the Type-IV pure-Java
JDBC
driver for MySQL.
MySQL Connector Java is available in source and binary form from
the
Connector/J download pages at
http://dev.mysql.com/downloads/connector/j/5.1.html
and mirror sites as well as Maven-2 repositories.
MySQL Connector Java (Commercial) is already available for
download on the
My Oracle Support (MOS) website. This release will be available
on eDelivery
(OSDC) in next month’s upload cycle.
As always, we recommend that you check the “CHANGES” file in
the
download archive to be aware of changes in behavior that might
affect
your application.
MySQL Connector/J 5.1.42 includes the …
[Read more]The place is still frantic here at Percona Live 2017 as everybody tries to squeeze in a few more talks before the end of the day. One such talk was given by Red Hat’s Stefan Negrea on Hawkular Metrics.
Hawkular Metrics is a scalable, long-term, high-performance storage engine for metric data. The session was an overview of the project that includes the history of the project, an overview of the Hawkular ecosystem, technical details of the project, developer features and APIs and third party integrations.
Hawkular Metrics is backed by Cassandra for scalability. Hawkular Metrics is used and exposed by Hawkular Services.The API uses JSON to communicate with clients.
Users of Hawkular Metrics include: …
[Read more]The last day of Percona Live 2017 is still going strong, with talks all the way until 4:00 pm (and closing remarks and a prize giveaway on the main stage then). I’m going to a few more sessions today, including one from Stephane Combaudon from Slice Technologies: Lessons learned while automating MySQL deployments in the AWS Cloud.
In this talk, Stephane discussed how automating deployments is a key success factor in the cloud. It is actually a great way to leverage the flexibility of the cloud. But often while automation is not too difficult for application code, it is much harder for databases. When Slice started automating their MySQL servers at Slice, they chose simple and production-proven …
[Read more]Welcome to the third (and final) day of the Percona Live Open Source Database Conference 2017, and the third (and final) set of Percona Live keynotes! The enthusiasm hasn’t waned here at Percona Live, and we had a full house on Thursday morning!
Day three of the conference kicked off with three keynotes talks, and ended with the Community Awards Ceremony:
Spinaltap: Airbnb’s Change Data Capture System
Xinyao Hu (AirBnB)
In this talk, Xinyao introduced Airbnb’s change data change system, Spinaltap. He briefly covered its design, and focused on various use cases inside Airbnb. These use cases covered both online …
[Read more]The recent “Unified Data Dictionary Lab Release” quietly delivered an important change to the MySQL server with InnoDB engine: the “InnoDB System Tables” are now officially “decommissioned”. And InnoDB is now deriving its metadata from the new “Transactional Data Dictionary” delivered in 8.0.0 DMR.…
