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 790 Next 30 Older Entries

Displaying posts with tag: community (reset)

SET GLOBAL sql_log_bin - We need your feedback!
Employee +2 Vote Up -0Vote Down

Jeremy Cole recently blogged about the feature SET GLOBAL sql_log_bin. In his blog post, Jeremy suggested that there is no strong use-case for this feature, and that it is too easy to run accidentally (i.e. SET GLOBAL instead of SET [SESSION]). The result of this incorrect usage is that slaves will drift out of sync from masters.

We discussed Jeremy's request in the MySQL team, and we agree that the syntax should produce an error in MySQL 5.7. However, we have not yet determined which steps should be taken for MySQL 5.5 and MySQL 5.6. The two proposals we would like to float are:

  • The statement SET GLOBAL sql_log_bin=N produces a warning.
  • The statement SET GLOBAL sql_log_bin=N produces an error.
  •   [Read more...]
    MySQL 5.6.20 Community Release Notes
    Employee +5 Vote Up -0Vote Down

    Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.20.

    In particular:

    • Thank you to Jeremy Cole for reporting a case where InnoDB's redo log could become corrupt with externally stored blobs. Jeremy also provided a testcase to demonstrate the problem. Bug #69477.
    • Thank you to Ronald Bradford for identifying that MySQL would continue to operate even though the binary log could not be written. Our team picked up Ronald's blog post, and filed a bug in response. Bug #51014.
    • Thank you to Daniël van Eeden, Andrew Garner, Detlef Ulherr and Bjoern
      [Read more...]
    The InnoDB Team is looking for your feedback!
    Employee +3 Vote Up -0Vote Down

    Restarting production database servers with gigabytes of memory is difficult. It can lead to cold caches and other operational complexities.

    The InnoDB team is looking to make improvements so that restarting MySQL is required as little as possible. Please help them out by answering which configuration settings you are most eager to see made dynamic.

    Thanks!

    MariaDB 10.0.13 now available
    +0 Vote Up -0Vote Down

    Download MariaDB 10.0.13

    Release Notes Changelog What is MariaDB 10.0?

    MariaDB APT and YUM Repository Configuration Generator

    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.13. This is a Stable (GA) release.

    See the Release Notes and

      [Read more...]
    MySQL Connector/Python on GitHub
    Employee +1 Vote Up -0Vote Down

    Last week we released Connector/Python v2.0 (alpha); today we publish the source on GitHub. Yes, we are using Git internally and are now able to push it out on each release. Previous versions are still available through LaunchPad.

    Here is the full process to get Connector/Python installed in a virtual environment. You’ll need Git installed of course.

    shell> git clone https://github.com/oracle/mysql-connector-python.git cpy
    shell> virtualenv ENVCPY
    shell> source ENVCPY/bin/activate
    (ENVCPY)shell> cd cpy
    (ENVCPY)shell> python setup.py install
    (ENVCPY)shell> python
    >>> import
      [Read more...]
    Beyond the FRM: ideas for a native MySQL Data Dictionary
    Employee +4 Vote Up -0Vote Down

    The frm file has provided long service since the earliest days of MySQL. Now, it is time to replace it with a native InnoDB-based Data Dictionary.

    This is a change that has been on our wish list for a long time, as well as others in the MySQL development community:

      [Read more...]
    MySQL Community Dinner 2014
    +1 Vote Up -0Vote Down
    Hello all,

    I hope you're doing well. After the successful event last year it's a no brainer to arrange another community dinner when we're all together again in London this November. We had a fantastic turn-out for the meal last year, seating over 100 MySQLers in a venue whom were expecting only 60. So this year join the MySQL community again for a bite to eat and a beverage or two and discuss life, love and data.

    The When
    Monday, November 3rd 2014

    The Where 
    Masala Zone, Covent Garden

    The Why
    We have a vibrant community surrounding the MySQL ecosystem. Whether you want to talk about the meaning of life with Colin Charles or find out how Facebook take their logical backups even quiz Shlomi Noach about where thinks up his latest and greatest MySQL tools; why not do it










      [Read more...]
    MySQL User Camp - Bangalore, India
    Employee_Team +2 Vote Up -0Vote Down

    Another MySQL User Group meeting called "MySQL User Camp-Bangalore" is announced for Jun 20 in Bangalore, India!! Please find more details below:

    • Date and time: June 20, 2014 at 3PM IST
    • Place: Bangalore, Kalyani Magnum campus
    • Registration: Registration is needed, please contact mysql.bangalore@gmail.com
    • URL

    Agenda:

    • MySQL 5.7 New Features and NoSQL support in MySQL
    • Sharding as implemented in MySQL Fabric
    • Open discussion with MySQL developers
    We are looking forward to seeing you on Jun 20!!
    Upcoming EMEA, APAC & US Events with MySQL in 2014
    Employee_Team +1 Vote Up -0Vote Down

    As an update to the previous announcement from Mar 25, 2014 please find below the updated list of events where MySQL Community team is attending and/or supporting. This time you can find not only EMEA & APAC ones but also conferences & events we are covering in the US & Canada. You are invited to meet our engineers at the events below.  

    EMEA 

    • NEW!! BGOUG, Sandanski, Bulgaria, June 13, 2014
      •  Georgi Kodinov will attend and speak at this local Oracle User Group event. Feel free to come.
    • PHP Tour Lyon, Lyon, France, June 23-24, 2014
        [Read more...]
      MySQL 5.6.19 Community Release Notes
      Employee +4 Vote Up -0Vote Down

      Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.19.

      In particular:

      • Thank you to Daniël van Eeden for reporting that the utility charset2html was unmaintained and obsolete. We followed Daniël's suggestion and removed it from MySQL distributions. Bug #71897.
      • Thank you to Dario Kampkaspar for reporting that upgrading from 5.6.10 to a more recent 5.6 release would fail. Bug #72079.
      • Thank you to Fangxin Flou for reporting that InnoDB would call memset too often. Fangxin also provided a suggested patch to fix the issue. Bug #71014.
      • Thank you to Daniël van Eeden for reporting
        [Read more...]
      The MySQL Community talks in Japan, Tokyo
      Employee_Team +1 Vote Up -0Vote Down

      There will be 2 community meetups in Tokyo in Japan scheduled for June 2014. Please check and join following: 

        [Read more...]
      MySQL User Group Meeting in Madrid, Spain
      Employee_Team +1 Vote Up -0Vote Down

      We are pleased to announce another MySQL User Group meeting scheduled for June 5 in Madrid, Spain. Keith Hollman, the MySQL Principal Sales Consultant will be talking about MySQL & Oracle strategy and MySQL Cluster. A small demo of MySQL Cluster will be part of the presentation. 

      Details about the event: Date: June 5, 2014 Time: 7:00 pm-8:30 pm Place: Edificio Telefonica, Gran via 28, Madrid, Entrada por C/ Valverde 2
      We are looking forward to seeing you in Madrid!
      See more information & registration.
      MariaDB moves development to Github
      +0 Vote Up -0Vote Down

      Today marks a milestone in terms of the MariaDB project – going forward, the MariaDB project plans to use Github and git for source code management. The migration happens from Launchpad and the bzr tool.

      The 10.1 server development (under heavy development now) will happen on Github. You can check it out here: https://github.com/MariaDB/server. Feel free to watch, star or even fork the code, and send us contributions!

      Previous maria-captains should now provide their Github IDs so that they can be accorded similar status. Send the IDs to the maria-developers mailing list.

      The project eventually wants to move the 10.0, 5.5, 5.3, 5.2, and

        [Read more...]
      Since now on github is the place for MariaDB new dev !
      +3 Vote Up -0Vote Down

      Today while browsing through my emails I was very happy to read this email from Sergei Golubchik :

      Hi! I'm happy to announce that MariaDB-10.1 tree has been completely migrated to github. Since now on we'll use github for the new development in MariaDB. It's https://github.com/MariaDB/server, go on, fork it, hack around, submit pull requests. [...]
      MySQL soon to store system tables in InnoDB
      Employee +5 Vote Up -0Vote Down

      In the MySQL team, we are changing the system tables currently located in the mysql schema from MyISAM to InnoDB.

      Looking at this historically:

      • MyISAM was the default storage engine up until MySQL 5.5.
      • In 5.5 almost 4 years ago, the default storage engine changed to InnoDB, however system tables used for features such as storing privileges and timezones remained as MyISAM.

      Unlike MyISAM, InnoDB is an ACID compliant storage engine, with the behaviour that once a transaction commits, modifications are able to survive power-loss or other failures. This is a solid foundation to build applications on, since developers will need to handle fewer failures. To use an example:

    • Customer places an order
    • A confirmation email is sent
    • Power is lost
    • Without durability, (2) could occur with no record of (1)

        [Read more...]
      MariaDB & MySQL Community Event videos & slides now up
      +0 Vote Up -0Vote Down

      If you couldn’t attend the MariaDB & MySQL Community Event in April 2014, held at the Hilton Santa Clara, fret not as there are slides and videos uploaded for you to watch at your leisure. There is likely to be at least one more community event later this year, so watch the space.

      Currently on the page, you’ll find most of the talks with slides and the videos are professionally done – with slide overlays. The audio could be better on some, but for an event that was pulled together by Monty in less than 3 weeks, it’s not too shabby. You can learn What’s new in MariaDB 10, a little more about the SPIDER storage engine,

        [Read more...]
      Proposal to deprecate COM_REFRESH packet
      Employee +0 Vote Up -0Vote Down

      In the MySQL team we are proposing to deprecate the COM_REFRESH packet in favor of specific queries to execute FLUSH commands. To provide a bit of context:

      • The MySQL server protocol allows for clients to speak API commands via both a query and binary protocol interface. The set of the API commands can be seen in the MySQL Client/Server Protocol internals documentation, or very simply as they appear in a single switch statement:
        # ./sql/sql_parse.cc:1009 (simplified view)
        
          switch (command) {
        
          case COM_REGISTER_SLAVE:
          {
            /* do stuff */
            break;
          }
          case COM_QUERY:
          {
            /* parse query, do stuff */
            break;
          }
          case COM_REFRESH:
          {
           /* equivalent to running a FLUSH command */
            break;
          }
          case COM_SHUTDOWN:
          {
            kill_mysql();
            break;
          }
        }
        [Read more...]
      Proposal to deprecate the old password format
      Employee +1 Vote Up -0Vote Down

      Improving security has been a high priority for MySQL 5.7. To give you an idea of some of the changes to date, I recommend reading Todd Farmer's blog: Redefining --ssl option, Password expiration policy, AES256 encryption.

      In MySQL 5.7, we are also proposing to remove the 'old' format for saving passwords. To provide some historical context:

      • The old password format is a 16-byte hash and considered to be cryptographically weak. Code appears online (I won't link to it) which allows the hash
        [Read more...]
      MySQL at PHP UnConference on Island of Majorka & Solutions Linux & Open Source Conference Paris
      Employee_Team +1 Vote Up -0Vote Down

      The PHP UnConference is taking place on May 17-18, 2014 on the Island of Majorka. MySQL team is going to be presented by Ulf Wendel at this event. As usual for all UnConferences there is no sessions/talks schedule announced prior the conference, attendees might vote for the most interesting topics at the event. So, do not miss to come to PHP UnConference at lovely Island of Majorka!! (in the case you still do not know whether come or not, maybe the price of tickets, weather forecast and/or flight ticket from several locations might convince you...). 

      The Solutions Linux & OpenSource

        [Read more...]
      GUUG Frühjahrsfachgespräch 2014: CfP ends on May 31st!
      Employee +0 Vote Up -0Vote Down

      The German Unix User Group (GUUG) will hold their annual conference "Frühjahrsfachgespräch" on September 23-26 this year (I know, not really "Frühjahr" anymore, but this is how it is).

      The Call for Presentations is still open until May 31st. Talks can be proposed in German and English, and there are slots for longer tutorials as well.

      The range of possible topics is broad, so if you think you have anything interesting to share with a very passionate and technical audience of sysadmins and developers, here are some suggestions:

      • Operating Systems/Applications: architectures, privilege concepts, new developments, administration, mobile systems
      • Relevant new OS Kernel
        [Read more...]
      Calling for all mysql_install_db feature requests
      Employee +2 Vote Up -0Vote Down

      mysql_install_db is the program that is responsible for bootstrapping a fresh copy of MySQL and making sure all of the system tables are setup correctly. This program is usually invoked by other programs as part of installation, but in the case of .tar.gz downloads will need to be executed manually.

      As part of our ongoing efforts to refactor and improve MySQL, we are looking at converting mysql_install_db from its current Perl script to a program written in C++. The aim of this change is to reduce external dependencies (Perl + a set of modules) and improve our cross-platform experience.

      We plan for this transition to be mostly function neutral, but are open to feature requests for additional improvements as well.

      Have you worked in packaging MySQL?
      Do you have any suggestions on how mysql_install_db can be improved?
      Please leave a comment, or get in touch!

      MySQL User Group Meeting in Korea
      Employee_Team +1 Vote Up -0Vote Down

      This month another MySQL User Group meeting is scheduled, this time in Seoul, Korea on May 20, 2014 @ 6:30pm. Please mark your calendar for this day if you are local... It's a great opportunity to hear news about delivering MySQL 5.7.4 as well as we saved some time for a MySQL User Group discussion. Please see details below:

      Name: MySQL User Group Meeting

      Date: May 20th, 2014

      Time: 6:30pm

      Place: 15fl. ASEM Tower, (Oracle Korea office), Samsung-dong, Seoul, Korea

      For more details see the MySQL Korea User Group Facebook page

      MySQL defaults evolution
      +1 Vote Up -0Vote Down

      MySQL, the original brand, the one developed by the MySQL team at Oracle, is steadily evolving. You can feel it if you try every new release that comes out of the milestone release cycle. Or even if you don’t try all of them, just testing a release once in a while gives you something to think about.

      The engineers at Oracle are trying hard to improve the defaults. If you are the out-of-the-box type, and just install the new version on top of the previous one, leaving the same setup in place, you may be up for a for a few surprises. It’s the marketing, see? They tell you that just by replacing your old MySQL (5.1 or 5.5) with MySQL 5.6 you get 30% to 70% performance improvement. Which happens to be true, not only because the server is better, but also because they have changed the defaults. However, this change in

        [Read more...]
      We're looking to improve PlanetMySQL
      Employee +1 Vote Up -0Vote Down

      We are looking for community feedback on how improve the Signal-to-Noise ratio of PlanetMySQL, and reduce the amount of irrelevant and off-topic posts.

      To give you a sense of where we are at today, we currently approve most [all?] blogs for aggregation, provided they have some existing technical content. We then apply a naive regular expression to make sure that all posts are on topic (MySQL).

      The sorts of ideas we are looking for are:

      • What content are you interested in seeing more or less of?
      • What posts do you deem as acceptable or unacceptable?
      • Do we need to change the balance between technical, marketing, event, or business-related posts?
      • Are there any tools or features we could introduce to better serve readers and authors?

      If you have any suggestions - please send them my way!

      MySQL Tech Day, Paris France on May 22, 2014
      Employee_Team +2 Vote Up -0Vote Down

      Want to know more about recent MySQL ads? If so, and if you are closed to Paris, join us for the MySQL Tech Day scheduled for May 22nd, 2014

      You will have an opportunity to hear the latest MySQL news, InnoDB new features and MySQL Performance Schema given by the key MySQL experts. Also this event is constructed as the interactive one, so you will have a chance to discuss and ask questions at this free event. Please review the detailed agenda below and here (in French).

      Event Details:

      Date: May 22, 2014

      Time: 10:00 - 17:30 

      Place: Oracle France, 15 Boulevard Charles de Gaulle, 92715 Colombes Cedex, Paris, France

      Entrance fee: Free of charge

        [Read more...]
      MySQL at OpenSUSE Conference, Dubrovnik, Croatia & JavaScript UnConference, Hamburg, Germany
      Employee_Team +2 Vote Up -0Vote Down

      The OpenSUSE Conference in Dubrovnik, Croatia started today and will continue till Monday April 28, 2014. MySQL team is going to be part of this event. Do not miss to visit our booth, which will be located on the ground floor as well as come to listen 2 MySQL talks (see OpenSUSE schedule):

      • Georgi Kodinov is going to have a talk about "Protect your MySQL server". His talk is scheduled for Friday, April 25, 2014 @ 13:00 in Ragusa mtg.room 
      • Norvald Ryeng will talk about "The upstream view" - Package maintenance as seen from MySQL Engineering. His talk is scheduled for Sunday, April 27, 2014 @ 13:00 in Ragusa mtg.room

      For the whole conference plan you can check the

        [Read more...]
      Proposal to deprecate mysqlhotcopy
      Employee +0 Vote Up -0Vote Down

      In the MySQL team, we are considering deprecating the mysqlhotcopy utility. To provide some background, here is an excerpt from the MySQL manual:

      mysqlhotcopy is a Perl script that was originally written and contributed by Tim Bunce. It uses FLUSH TABLES, LOCK TABLES, and cp or scp to make a database backup. It is a fast way to make a backup of the database or single tables, but it can be run only on the same machine where the database directories are located. mysqlhotcopy works only for backing up MyISAM and ARCHIVE tables. It runs on Unix.

      And now let me explain the motivations leading to our proposal:

      • The name implies that this utility will work for 'MySQL' and is hot, but actually neither are true:
      • Only MyISAM and ARCHIVE
        [Read more...]
      MySQL 5.6.17 Community Release Notes
      Employee +2 Vote Up -0Vote Down

      Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.17.

      In particular:

      • Thanks to Anthony Pong for reporting a confusing error message when mysql_install_db could not locate the required Perl modules. Bug #69844.
      • Thanks to Jervin Real for reporting a recently introduced performance regression with compressed InnoDB tables. Bug #71436.
      • Thanks to Laurynas Biveinis for reporting a race condition in InnoDB on shutdown. Bug #70430.
      • Thanks to Jervin Real for reporting that innodb_data_file_path could not be specified in
        [Read more...]
      MySQL Community Awards 2014: the Winners
      +3 Vote Up -0Vote Down

      The MySQL Community Awards initiative is an effort to acknowledge and thank individuals and corporates for their contributions to the MySQL ecosystem. It is a from-the-community, by-the-community and for-the-community effort. The committee is composed of an independent group of community members of different orientation and opinion, themselves past winners or known contributors to the community.

      The 2014 community awards were presented on April 3rd, 2014, during the community event at the Percona Live conference. The winners are:

      MySQL Community Awards: Community Contributor of the year 2014

      • Colin Charles
        Colin's list of service to the MySQL Community goes back almost 10 years. He was a community engineer starting in 2005, chaired some of the O'Reilly MySQL conferences, ran the MySQL projects for Google Summer of Code. As a
        [Read more...]
      MySQL at OpenSource Developer Conference, Taiwan (Apr 11-12, 2014)
      Employee_Team +0 Vote Up -0Vote Down

      It is our pleasure to announce MySQL presence at the OpenSource Developer Conference in Taipei, Taiwan next week. MySQL has secured 2 talks and the booth where you can meet our MySQL experts. Please mark your calendars for April 11-12, 2014, especially for following MySQL talks:

      • Sharding and Scale-out Using MySQL Fabric by Ryusuke Kajiyama, the OSS specialist with over 10 years of experience in system design utilizing MySQL and Open Source solutions. His talk is scheduled for Apr 11 @ 10:20-10:50.
      • MySQL Utilities by Ivan Tu, the MySQL Sales Consultant in Taipei. Ivan has Java programming background and is experienced in both, MySQL and Oracle database. His talk is scheduled for Apr 11 @ 11:50-12:20.
      We are looking forward to talking to you at the OSDC next week!

      Showing entries 1 to 30 of 790 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.