Kristian Nielsen is working on a new feature for MariaDB 10.3 and he published very interesting results. This feature is MDEV-12179: Per-engine mysql.gtid_slave_pos tables. He writes about replicating twice as fast in the worst case when using two storage engines (InnoDB and MariaRocks in his tests, but could also be InnoDB and TokuDB or TokuDB and MyRocks). I will let you read all the details
10 Older Entries »
The slides and videos from the Percona Live Open Source Database Conference 2017 are available for viewing and download. The videos and slides cover the keynotes, breakout sessions and MySQL and MongoDB 101 sessions.
To view slides, go to the Percona Live agenda, and select the talk you want slides for from the schedule, and click through to the talk web page. The slides are available below the talk description. There is also a page with all the slides that is searchable by topic, talk title, speaker, company or keywords.
To view videos, go to the …[Read more]
Percona announces the GA release of Percona Server for MySQL 5.7.18-14 on May 12, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.
Based on MySQL 5.7.18, including all the bug fixes in it, Percona Server for MySQL 5.7.18-14 is the current GA release in the Percona Server for MySQL 5.7 series. Percona’s …[Read more]
LOCK IN SHARE MODE
LOCK IN SHARE MODE
I did more tests, and I can confirm that his words are true:
LOCK IN SHARE MODE
works in MyRocks.
This quick example demonstrates this. The initial setup:
CREATE TABLE t ( id int(11) NOT NULL, f varchar(100) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=ROCKSDB; insert into t values(12345, 'value1'), (54321, 'value2');
In …[Read more]
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
Highlights This Year:
- Informative tutorials on day one, including …
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:
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]
Welcome to the first day of the Percona Live Open Source Database Conference: Percona Live 2017 tutorials day! While technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source tools and technologies.
Today attendees went to training sessions taught by open source database experts and got first-hand experience configuring, working with, and experimenting with various open source technologies and software.
The first full day (which includes opening keynote speakers and breakout sessions) starts Tuesday 4/25 at 9:00 am.
Some of the …[Read more]
We have been working on bringing out a build of MyRocks with Percona Server for MySQL.
MyRocks is a RocksDB-based storage engine. You can find more information about MyRocks here.
While there is still a lot of work to do, I want to share an experimental build of Percona Server for MySQL with MyRocks, which you can use to evaluate and test this engine
(WARNING: in NO WAY is this build supposed to be for production usage! Consider this ALPHA quality.)
The tar.gz binaries are available from our …[Read more]
Last year I started to explore MyRocks, that is, RocksDB
used as a storage engine with MySQL. So far I had to use Facebook's
MySQL 5.6 to do this. I could try to use some specific
development branches of MariaDB (or maybe even Percona Server)
for this, but I preferred to wait until the engine is included
into a main branch by the company I work for. Recently this
happened, and now you can get RocksDB loaded and working in
main MariaDB 10.2 branch. In this blog post I am
going to explain how to build it from source and do some basic
I was updating my MariaDB local repository on my Ubuntu 14.04 netbook, with 10.2 branch already checked out (do git checkout 10.2 if …
Please join Percona’s Principal Technical Services Engineer Sveta Smirnova, and Senior Software Engineer George Lorch, MariaDB’s Query Optimizer Developer Sergei Petrunia and Facebook’s Database Engineer Yoshinori Matsunobu as they present MyRocks Troubleshooting on March 30, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).
MyRocks is an alternative storage engine designed for flash storage. It provides great write workload performance and space efficiency. Like any other powerful engine, it has its own specific configuration scenarios that require special troubleshooting solutions.…[Read more]
10 Older Entries »