Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 99 Next 30 Older Entries

Displaying posts with tag: FOSDEM (reset)

FOSDEM slides ok, but where are your slides from PLUK?
+0 Vote Up -0Vote Down

As usual, you can find the slides from PLUK 2013 and FOSDEM 2014 on [Plus].
You have just to access to the slides page and free up some time to discover and read all the referenced content.

Remember the programs of these fantastic events :

Now, I’ve just discovered that many slides are missing for PLUK 2013 on the perconalive website.

For latecomers, it’s still time to upload your slides from your dedicated speaker page.
Please, do


  [Read more...]
Follow up on FOSDEM
+0 Vote Up -0Vote Down

After my presentation at FOSDEM I got a few questions regarding our Galera implementation and why we did things the way we want. First of all, the slides: Spil Games @ FOSDEM: Galera Replicator IRL from spil-engineering Second of all, the questions I got: Q: Why first copy all the data to a new MySQL […]

The post Follow up on FOSDEM appeared first on Spil Games Engineering.

The FOSDEM schedule in SQL
+1 Vote Up -0Vote Down
I thought it would be nice to be able to query the FOSDEM schedule for the MySQL devroom with SQL.

So I wrote a small Python script which downloads the schedule and inserts it into a MySQL database.

Some examples:
mysql> SELECT summary,dtstart,location,description FROM calendar 
-> WHERE calname='MySQL devroom'
-> AND MATCH (summary, description) AGAINST ('Fabric')\G
*************************** 1. row ***************************
summary: Sharding and Scale-out using MySQL Fabric
dtstart: 2014-02-01 16:05:00
location: UA2.114 (Baudoux)
description: MySQL Fabric is an open-source solution released by the MySQL Engineering team 
at Oracle. It makes management of MySQL server farms easy and available for both












  [Read more...]
FOSDEM 2014 MySQL Devroom, Community Dinner in Brussels this Saturday!
+0 Vote Up -0Vote Down

This weekend, on 1-2 February, FOSDEM 2014 will take place in Brussels, Belgium.
There will be MySQL talks on Saturday in the MySQL Devroom and a MySQL Community dinner afterward.

30 people have already signed up for the community dinner, we’re almost at the amount of people from last year.

Last orders for the MySQL Community dinner will be accepted on Wednesday 29 January, so if you plan to attend, make sure to buy your tickets now. After that day, we


  [Read more...]
FOSDEM 2014 MySQL & Friends devroom
+0 Vote Up -0Vote Down

FOSDEM is a free, yearly event that offers open source communities a place to meet, share ideas and collaborate. It takes place in Brussels, Belgium each February.

10 years ago now, the first MySQL devroom was organized there by David Axmark, marking the first time MySQL users got their own space to come together and discuss at the event. On this anniversary edition, Percona consultants will be present at the MySQL & Friends Community Booth, as well as giving talks in the devroom (full schedule):

*

  [Read more...]
Presenting at FOSDEM and Percona Live
+0 Vote Up -0Vote Down

Very short update from my side: I’ll be presenting at FOSDEM in Brussels (1-2 February 2014) and Percona Live MySQL Conference in Santa Clara (1-4 April 2014).


At FOSDEM I will present about Galera replication in real life which is concentrate around two use cases for Galera: adding new clusters to our sharded environment and migrating existing clusters into a new Galera cluster.


At Percona Live MySQL Conference I will present about


  [Read more...]
FOSDEM MySQL & Friends Devroom – signup for dinner
+1 Vote Up -0Vote Down

FOSDEM happens this year, February 1&2 2014. This year is a special year as it is the 10th anniversary: great content in the schedule, you must pre-register for dinner (lot’s of wonderful Belgian food & drink), and we have a shared booth in the expo hall.

Read more about the event with a wonderful post by Kenny. Again, much thanks to Liz, dim0, Kenny,

  [Read more...]
FOSDEM 2014: MySQL And Friends Community Dinner
+0 Vote Up -0Vote Down

FOSDEM is coming to town again here in Brussels this February 1-2, and as usual, there is a MySQL Devroom. Traditionally, a MySQL and Friends community dinner is also held during the event and this year is no different – we’ve organized one for Saturday, February 1 from 8:30 p.m. to 11:30 p.m. (CET).

If you want to sign up for the dinner, go to http://fosdemmysqlcommunitydinner2014.eventbrite.com/

This year’s edition is going to be slightly different…

We have rented

  [Read more...]
MySQL & Friends – FOSDEM 2014 CfP last chance!
Employee +5 Vote Up -0Vote Down


Heads up that Friday (6th December) is your last chance to submit a 30 minute session proposal for next year’s MySQL & Friends Devroom at FOSDEM. I presented last year and I was really impressed by the number of attendees, the organisation and the positive reception (I’ll be there again next year – hopefully presenting). If you’ve got a MySQL-related topic that you’d like to present to an enthusiastic open-source community then this is a agreat opportunity.

Submit your proposal(s) for a 30 minute session here.


  [Read more...]
FOSDEM MySQL & Friends Devroom
+1 Vote Up -0Vote Down

As Frederic posted, its time to submit talks for the MySQL & Friends Devroom at FOSDEM 2014. The next year, it will be on Saturday February 1 2014. I look forward to being in Brussels again, and I hope to see you there too.

Submit to the MySQL track here, and don’t forget to be there on Friday evening for the start of the beers. I’m told by Frederic & Kenny that we’re likely to have a much more interesting community dinner since things are getting larger year by year. See you at

  [Read more...]
FOSDEM 2014 – MySQL & Friends Devroom
+0 Vote Up -0Vote Down

As every year in February, in Brussels, the FOSDEM will take place!
And as every year, the MySQL Community will also be present! For the 3rd year in a row, I have the honour of organising the MySQL & Friends Devroom.

Let’s start with the most important information: FOSDEM 2014 will be held February 1 and 2.
This year instead of Sunday, the MySQL & Friends Devroom will be on Saturday from 9 a.m. and will finish with
the Community Dinner (more information related to the dinner will come later).

The “Call for Papers” has been announced on the MySQL mailing list, you can still read it




  [Read more...]
Slides from past conferences
+0 Vote Up -0Vote Down

Here are my slides from past conferences. They were generated from Org Mode and Beamer. You can read more about it here. You can get more info on the talks on their respective pages(linked). Talk at FOSDEM 2013: Feed me more: MySQL Memory analysed from Raghavendra Prabhu Talk at PLMCE 2013: MySQL-and-virtualization from Raghavendra Prabhu [...]

The post Slides from past conferences appeared first on Spooky Action at a Distance.

FOSDEM 2013 Slides are available on [Plus]
+0 Vote Up -0Vote Down

I was at FOSDEM for the first time this year and it was very exciting.
I was very glad to see Percona, MariaDB and Oracle together.
If you’ve never been at FOSDEM, I recommend you to join us next year, this is truly a magical event!

You can find some of the slides on [Plus], enjoy! :

If you would like to add your slides, post a comment with the link.
And remember to visit this page for more slides about MySQL : http://www.mysqlplus.net/mysql-docs/




  [Read more...]
[Plus] readers choice 2012 : Final results
+2 Vote Up -0Vote Down

It’s time to unveil the winners of the [Plus] readers choice awards!
Thank you again for your votes, remember that the real winner was the community, again.

I asked you to vote for what you used in 2012 and you’ve voted with your heart.
Here are the final results, congrats to the lucky guys and teams :

The most useful blogs in 2012 :

  • MySQL Performance Blog
  • The MariaDB Blog
  • SkySQL Blog
  • Ok, the Percona team members provides the best technical blog about MySQL (and more), this year again. Of course, this blog is very useful and interesting, I recommend to read the comments too, they are often very informative.



      [Read more...]
    MySQL Presentations from FOSDEM 2013
    Employee +4 Vote Up -0Vote Down

    FOSDEM 2013

    The Free and Open source Software Developers’ European Meeting (FOSDEM) is a two-day event organized by volunteers to promote the widespread use of Free and Open Source software.

    I attended for the first time over the weekend and was really impressed by the number of people there, the energy and the quality of the content. The event really lives up to it’s name and is very developer-focused.

    In the end, I got the opportunity to make 2 presentations. The first is a general introduction to MySQL Cluster….



    The second illustrates how you can realise the benefits promised by NoSQL data stores wihtout losing the consistency and flexibility of relational databases…



    Impressions of FOSDEM 13
    +2 Vote Up -1Vote Down
    FOSDEM 13 is now over, I am on my way home and I would like to share some thoughts sparkled by the intense atmosphere that I have lived in these two days in Brussels.

    I have to admit, I was tempted to skip FOSDEM this year: the last 3 weeks have been crazily busy and I travelled a lot, leaving my family alone for too long. But now I am glad I made the effort.
    For once, I will leave the comments around the MySQL talks to others, I am sure there will be posts on the matter. In this post I want to cover some of the non-MySQL talks and discussions I have attended and heard. Of course the topics that have been discussed are still relevant for MySQL and for the future of the MySQL ecosystem.
    First of all, the number of attendees was impressive. The organisers claim there were more than 5,000 open source enthusiasts,



      [Read more...]
    Developing Libdrizzle
    +2 Vote Up -2Vote Down
    This weekend I am supposed to be giving a talk at FOSDEM on Libdrizzle.  Unfortunately my kids and I all fell ill on Thursday (my wife appears to be immune) so I had to cancel my plans (infecting 5000 people didn't seem wise :)

    Instead I am writing this blog post about Libdrizzle and my part in it which covers some of what I was going to talk about.

    History of Libdrizzle

    Libdrizzle started out as a from-scratch C connector for Drizzle and MySQL originally created by Eric Day.  It was designed to be high performance and use common standards to make it easy to work on.  In the summer of 2010 it was merged into the main Drizzle tree where development has been focused.  There were several attempts to split it out again but until now none were truly successful.

    For a few





      [Read more...]
    SkySQL Solutions Day, FOSDEM MySQL activity
    +4 Vote Up -0Vote Down

    February is turning out to be a busy month. I’ll be giving a talk about MariaDB at the SkySQL Solutions Day in Hamburg, alongside Sergei Golubchik. This happens February 1 2013.

    I’ll also be in Brussels for FOSDEM and presenting at the MySQL & Friends devroom. Here I will talk about MHA and how you can get automated MySQL failover. I’ll also be hanging out at the CentOS booth with Karanbir Singh giving away MariaDB stickers all weekend. If you’re at FOSDEM, don’t forget to sign up for the

      [Read more...]
    FOSDEM 2013, another nice open source event in Europe!
    +2 Vote Up -0Vote Down
    FOSDEM is a free event that offers open source communities a place to meet, 
    share ideas and collaborate.
    It is renowned for being highly developer-oriented 
    and brings together 5000+ geeks from all over the world.

     
    This year again, be sure that FOSDEM will be the place to be in February!

    Do you have any doubts? Really ? Dude, repeat after me :

  • Free event
  • During a week-end
  • Beer
  • 5000+ open source geeks
  • Beer
  • MySQL and Friends devroom
  • NoSQL devroom
  • No registration needed (open source man!)
  • Ok, that sounds good?

    Well, here are the informations to attend this terrific event :

    • How to register? : Are you kidding me?
    • When : 2 & 3 February 2013 (Hurry up guys!)
    • Where : Brussels (beers!!!)

      [Read more...]
    Libdrizzle 5.1.2 released and Libdrizzle at FOSDEM
    +1 Vote Up -0Vote Down
    Libdrizzle is getting better and better with every release, and to reflect this we have two announcements to make.

    First of all, Libdrizzle 5.1.2 has been released.  This release has several major bug fixes and performance enhancements.  Changes are as follows:
    • Non-blocking Windows connections are now more stable
    • Improvements to Windows building
    • Unix Socket connections are now more stable
    • Memory allocation/freeing cleanups (for performance and ease of code)
    • Network packet buffer now much more flexible
    • Many performance improvements (the bundled drizzle_binlogs tool is now around 10x faster on my i7 laptop)
    • Several other minor bug fixes
    API chages:
    • drizzle_query_str() has been removed, drizzle_query() with a 0 byte length parameter now does the same thing.
    As



      [Read more...]
    [Plus] readers choice 2012 : It’s time to vote!
    +2 Vote Up -0Vote Down

    Oh yes, 2012 was an incredible year for the MySQL Community!
    That’s why I would like to change the rules this year and I would like to offer you a new survey for this [Plus] reader’s choice 2012.

    Community users, bloggers and events made the whole community last year, tell us how you used this community?
    It will only take 5 minutes of your precious time, votes will be closed Jan. 31.

    Vote for what you used! (with your heart, again…)

    Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit

      [Read more...]
    Upcoming MySQL Conferences
    +3 Vote Up -0Vote Down
    I may not work on many MySQL related things any more but there are some MySQL ecosystem events that I am participating in.

    First there is Percona Live London.  This event is on the 3rd and 4th of December at The Millennium Gloucester Conference Centre.  At this event I will be giving a talk on MySQL Compatible Open Source Connectors.  This will cover alternatives to the standard connectors and how to use them, it will be useful if you find the licensing behind the standard connectors prohibiting.  There is also a 40% off discount code you can use when registering, simply enter the promo code "Come2mytalk".

    On the 2nd and 3rd of February is



      [Read more...]
    Managing MySQL with Percona Toolkit by Frédéric Descamps
    +2 Vote Up -0Vote Down

    Frédéric Descamps of Percona.

    Percona Toolkit is Maatkit & Aspersa combined. Opensource and the tools are very useful for a DBA.

    You need Perl, DBI, DBD::mysql, Term::ReadKey. Most tools are written in Perl, and whatever is in Bash is being re-written in Perl. There is also a tarball or RPM or DEB packages.

    Know your environment. The hardware & OS are crucial for you to know. How much memory/CPU do you use? Do you use swap? Is this a physical/virtual machine? Do you have free space? What kind of RAID controller? Volumes? Disk? What about the network interfaces? What IO schedulers are used? Which filesystem is the data stored on? To answer all that, just use pt-summary.

    Know your MySQL

      [Read more...]
    Replication features of 2011 by Sergey Petrunia
    +1 Vote Up -0Vote Down

    Sergey Petrunia of the MariaDB project & Monty Program.

    MySQL 5.5 GA at the end of 2010. MariaDB 5.3 RC towards the end of 2011 (beta in June 2011).

    MySQL 5.5 is merged to Percona Server 5.5 which included semi-sync replication, slave fsync options, atuomatic relay log recovery, RBR slave type conversions (question if this is useful or not), individual log flushing (very useful, but not many using), replication heartbeat, SHOW RELAYLOG EVENTS. About 2/3rds of the audience use MySQL 5.5 in production, with only 2 people using semi-sync replication.

    MariaDB 5.3 brings replication features brings group commit in the binary log, which is merged into Percona Server 5.5. Checksums for binlog events which is merged from

      [Read more...]
    MySQL Creatively in a Sandbox by Giuseppe Maxia
    +1 Vote Up -0Vote Down

    Giuseppe Maxia of Continuent and long time creator of MySQL Sandbox.

    Only works on Unix-like servers. Works with MySQL, Percona & MariaDB servers. MySQL server has the data directory, the port and the socket – you can’t share these.

    To use it: make_sandbox foo.tar.gz. Then just do ./use.

    $SANDBOX_HOME is ~/sandboxes. You can also create ~/opt/mysql/ and if you have MySQL 5.0.91 binary in that directory, you can just do “sb 5.1.91″.

    Sandbox has features to start replication systems as well. You can have varying master/slave setups with varying versions as well (good idea to test from MySQL -> MariaDB master->slave for migration).

    You can now also play with

      [Read more...]
    Optimizing your InnoDB buffer pool usage by Steve Hardy
    +0 Vote Up -0Vote Down

    Steve Hardy of Zarafa.

    Work that has been done to make Zarafa better. Why do you optimise your buffer pool? To decrease your I/O load. How can you do it? Buy more RAM, page compression, less (smaller) data, rearrange data.

    MariaDB or Percona Server allows you to inspect your buffer pool (unsure if this is now available in MySQL 5.6). Giuseppe in the audience says this is available in MySQL 5.6, but Steve used this on MariaDB 5.2.

    Strategies to fix it: Make records smaller. Remove indexes if you can use others almost as efficiently. Make records that are accessed around the same time have a higher chance of being on the same page. Use page compression. Buy more RAM. Try Batched Key Access

      [Read more...]
    Practical MySQL Indexing guidelines by Stéphane Combaudon
    +0 Vote Up -0Vote Down

    Stéphane Combaudon of Dailymotion.

    Index: separate data structure to speed up SELECTs. Think of index in a book. In MySQL, key=index. Consider that indexes are trees.

    InnoDB’s clustered index – data is stored with the Primary Key (PK) so PK lookups are fast. Secondary keys hold the PK values. Designing InnoDB PK’s with care is critical for performance.

    An index can filter and/or sort values. An index can contain all the fields needed for the query you don’t need to go to the table (a covering index).

    MySQL only uses 1 index per table per query (not 100% true – OR clauses), so think of a composite index when you can. Can’t index TEXT fields (use a prefix). Same for BLOBs and long VARCHARs.

    Indexes: speed up queries, increases the size of your dataset, slows down writes. How

      [Read more...]
    MySQL synchronous replication in practice with Galera by Oli Sennhauser
    +1 Vote Up -0Vote Down

    Oli Sennhauser of FromDual.

    Synchronous multi-master replication with the Galera plugin. Your application connects to the load balancer and it redirects read/write traffic to the various MySQL Galera nodes. Tested a setup with 17 SQL nodes and you can have even more. Scaling reads and also a little bit for scaling writes is what Galera is good for.

    If one node fails, the other two nodes still communicates with each other and the load balancer is aware of the failed node.

    Why Galera? There is master-slave replication but its not multi-master, and its asynchronous and you can get inconsistencies. There is master-master replication but its asynchronous and can have inconsistencies and conflicts if you write on both nodes. MHA/MMM/Tungsten are

      [Read more...]
    Optimising SQL applications by using client side tools by Mark Riddoch
    +0 Vote Up -0Vote Down

    Mark Riddoch of SkySQL.

    This was a talk about the future in general. What people would like. Etc. Not about something that exists yet, hence the sparse notes.

    Trace statements are good for the “why”. You move on to the debugger, but what is a useful SQL debugger? Profilers addresses the “when”.

    SQL developer tools: manually run queries (traditional route for development, effective way to test SQL statements, some indication of performance), server logs (alerts developers of serious issues like the slow query log – identify poorly written queries, requires server access, not effective in a cloud environment (?)), external monitoring (network sniffing of connection packets, Ethereal dissectors – allow individual connections to be traced, no

      [Read more...]
    MySQL Cluster by Ralf Gebhardt
    +0 Vote Up -0Vote Down

    Ralf Gebhardt of SkySQL.

    Cluster: shared nothing architecture (no single point of failure), synchronous replication between nodes, ACID transactions, row level locking. In-memory storage (some data can be stored on disk, but indexes must be in-memory). Checkpointing to disk for durability. It supports two types of indexes – ordered T-trees, unique hash indexes. Online operations like adding node groups, software upgrades, table alterations. Quick standard architecture diagram displayed about MySQL Cluster.

    Network partitioning protocol is designed to avoid a split brain scenario. Is there at least one node from each node group? If not then this part cannot continue – graceful shutdown. Are all nodes present from any node group? If so, then this is the only viable cluster – continue to operate. Ask the

      [Read more...]
    Showing entries 1 to 30 of 99 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.