Tag: Fosdem

Feed: Planet MySQL; Author: Giuseppe Maxia; This was not on the radar. I have never been proficient in Galera clusters and related technologies, and thus I hadn’t given much thought to Percona Xtradb Cluster (PXC), until Alkin approached me at FOSDEM, and proposed to extend dbdeployer features to support PXC. He mentioned that many support engineers at Percona use dbdeployer) on a daily basis and that the addition of PXC would be welcome.I could not follow up much during the conference, but we agreed on making a proof-of-concept in an indirect way: if several nodes of PXC can run in ... Read More

Feed: Planet MySQL; Author: Giuseppe Maxia; After a conference, when I take stock of what I have learned, I usually realise that the best achievements are the result of interacting with other attendees during the breaks, rather than simply listening to the lectures. It might be because I follow closely the blogosphere and thus the lectures have few surprises in store for me, or perhaps because many geeks take the conference as an excuse to refresh dormant friendships, catch up with technical gossip, and ask their friends some questions that were too sensitive to be discussed over Twitter and have ... Read More

Feed: Planet MySQL; Author: Shlomi Noach; We are pleased to release gh-mysql-rewind, a tool that allows us to move MySQL back in time, automatically identify and rewind split brain changes, restoring a split brain server into a healthy replication chain. I recently had the pleasure of presenting gh-mysql-rewind at FOSDEM. Video and slides are available. Consider following along with the video. Motivation Consider a split brain scenario: a "standard" MySQL replication topology suffered network isolation, and one of the replicas was promoted as new master. Meanwhile, the old master was still receiving writes from co-located apps. Once the network isolation ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST For those not familiar with it, FOSDEM is an amazing, free entry, full on celebration of open source that takes place in Brussels, Belgium every year. This year the event was held over the first weekend of February. Fringe events, such as the Pre-FOSDEM MySQL day hosted by Oracle MySQL, and the community dinner that follows, provide an opportunity to network. In case you didn’t make it to FOSDEM this year, here are links to Percona’s presentations from the event. Organizers video and share online every talk from every dev room, a ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; This year I had not only spoken about MySQL bugs reporting at FOSDEM, but spent almost the entire day listening at MySQL, MariaDB and Friends Devroom. I missed only one talk, on ProxySQL, (to get some water, drink a bottle of famous Belgian beer and chat with my former colleague in MySQL support team, Geert, whom I had not seen for a decade). So, for the first time out of my 4 FOSDEM visits I've got a first hand impression about the entire set of talks in the devroom that I want to share ... Read More

Feed: Planet PostgreSQL. Extensions are capable of extending, changing, and advancing the behavior of Postgres. How? By hooking into low level Postgres API hooks. The open source Citus database that scales out Postgres horizontally is itself implemented as a PostgreSQL extension, which allows Citus to stay current with Postgres releases without lagging behind like other Postgres forks. I’ve previously written about the various types of extensions, today though I want to take a deeper look at the most useful Postgres extension: pg_stat_statements. You see, I just got back from FOSDEM. FOSDEM is the annual free and open source software conference ... Read More

Feed: Planet MySQL; Author: Kaj Arnö; Why a sea lion? That’s a question we get every now and then, most recently at FOSDEM. Here is the story: Our Founder Monty likes animals in the sea. For MySQL, he picked a dolphin, after swimming with them in the Florida Keys. For the MariaDB sea lion, there was a similar encounter. It happened when Monty and his older daughter My were snorkeling on one of the islands in the Galapagos. Something big, brown and fast suddenly appeared at an arm’s distance, laughing in their faces. Fond memories of this fast and funny ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; This event was just awesome. We got 110 participants ! Thank you everybody and also a big thank to the speakers. Here are the slides of all the sessions: MySQL Shell – A DevOps-engineer day with MySQL’s development and administration tool, Miguel Araújo MySQL Shell : the best DBA tool ? – How to use the MySQL Shell as a framework for DBAs, Frédéric Descamps Tuning MySQL 8.0 InnoDB for High Load, Dimitri Kravtchuk MySQL 8.0: advance tuning with Resource Group, Marco Tusa New index features in MySQL 8.0, Erik Frøseth Optimizer Histograms: When ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Last week I presented the following session at the pre-FOSDEM MySQL Day: The audience seemed very interested on how the MySQL Shell can be extended. During the presentation I showed how I extended the MySQL Shell with two new modules in Python: Both projects are on github and are waiting for ideas, feature requests, pull requests, … Here is the video of the Innotop module as during the presentation: I hope you will enjoy the MySQL Shell even more and that you will start contributing to these modules. Related ... Read More

Feed: Planet PostgreSQL. Andreas 'ads' ScherbaumAt FOSDEM someone asked how long 64 bit Transaction-IDs will last. To refresh: PostgreSQL is currently using 32 bits for the TXID, and is good for around 4 billion transactions: fosdem=# SELECT 2^32; ?column? ------------ 4294967296 (1 row) That will not last very long if you have a busy database, doing many writes over the day. MVCC keeps the new and old versions of a row in the table, and the TXID will increase with every transaction. At some point the 4 billion transactions are reached, the TXID will overrun, and start again at the beginning. The way transactions ... Read More