'Opinions' Tag

  • New statements I'd like to see in MySQL 5.8

    October 8, 2015

    Following up on New features I'd like to see in MySQL 5.8, here are statements I would like to see in MySQL 5.8: ENABLE EVENTS; When promoting a slave to master, I want to be able to enable all those events that are in SLAVESIDE_DISABLED state. Today I script an iteration over the events an constructing […]

  • New features I'd like to see in MySQL 5.8

    October 7, 2015

    Following up on Morgan Tocker's What would you like to see in MySQL 5.8?, having attended and participated at the brainstorming at Percona Live Amsterdam, and publishing this post while failing to comply with any of Morgan's suggested media, these are the features I would like to see in MySQL 5.8: Dynamicly enable/disable log-bin and log-slave-updates Today, when […]

  • Baffling 5.7 global/status variables issues, unclean migration path

    August 7, 2015

    MySQL 5.7 introduces a change in the way we query for global variables and status variables: the INFORMATION_SCHEMA.(GLOBAL|SESSION)_(VARIABLES|STATUS) tables are now deprecated and empty. Instead, we are to use the respective performance_schema.(global|session)_(variables|status) tables. But the change goes farther than that; there is also a security change. Oracle created a pitfall of 2 changes at the same time: […]

  • Percona Live 2015: Reflections

    April 18, 2015

    Some personal reflections on PerconaLive 2015: Percona acquires Tokutek Well done! Tokutek develops the TokuDB storage engine for MySQL and TokuMX engine for MongoDB. I will discuss the MySQL aspect only. TokuDB was released as open source in 2013. It has attained a lot of traction and I have used it myself for some time. […]

  • Percona Live 2015: Reflections; the Apache CCLA offer

    April 18, 2015

    Facebook, Google, Twitter, LinkedIn, Alibaba, MariaDB, Percona team up and offer Oracle all public changes under the Apache CCLA Read again please. My one word summary of this is: Romantic. In the most positive sense. Disclaimer: I am not a lawyer; this is my understanding of the current status and of the offer. Summarizing the […]

  • Three wishes for a new year

    September 23, 2014

    Another new year by Jewish calendar. What do I wish for the following year? World peace Good health to all Multi-core execution for queries After having evaluated a few columnar databases, and having seen how a single query gets 24 cores busy, I can't look at MySQL the same way again. The fact that a […]

  • Some anecdotes I learned at Percona Live

    April 8, 2014

    While on the plane back home I wrote down all my impressions from Percona Live 2014. Have lots of TODOs and great ideas to implement. Among all my impressions, there were a few anecdotes worth noting. 5.6 GTID is still unfriendly. It will require complete shutdown & reconfiguration of your entire replication topology; and some […]

  • Why delegating code to MySQL Stored Routines is poor engineering practice

    February 6, 2014

    I happen to use stored routines with MySQL. In fact, my open source project common_schema heavily utilizes them. DBA-wise, I think they provide with a lot of power (alas, the ANSI:SQL 2003 syntax feels more like COBOL than a sane programming language, which is why I use QueryScript instead). However I wish to discuss the […]

  • Why a professional conference must have a committee, and what that committee does

    December 14, 2013

    What exactly is it that a conference committee does? This post comes as response to a comment on A sneak peek at the Percona Live MySQL Conference & Expo 2014, reading: Why the same committee each year? Community should vote on proposals and committee should just work schedule,etc. I'll pick the glove and shed some […]

  • 5 years of blogging

    October 22, 2013

    openark.org blog is now five years old. Hurrah! Throughout these five years I posted almost exclusively MySQL oriented blogs, though I had every intention of writing on various engineering topics. I still see blogging as one of the most important forms of knowledge sharing, and indeed for me the blogs aggregated at Planet MySQL are […]

Powered by Wordpress and MySQL. Theme by openark.org