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

Displaying posts with tag: community (reset)

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!

    MySQL at LOADays Conference in Antwerp, Belgium (Apr 5-6, 2014)
    Employee_Team +0 Vote Up -0Vote Down

    This weekend we are going to be part of the LOADays Conference (Linux Open Administration Day) a free open source event hold in Antwerp, Belgium, followed by the tutorial on Monday, April 7th.

    Do not miss to attend this small but friendly event hold in Antwerp, the second biggest city in Belgium and the capital of the Antwerp province. So, you can join the sightseeing with attending LOADays and getting in touch not only with a Linux people but also with MySQL!!

    MySQL is represented by our colleague Carsten Thalheimer who is going to have a talk about "Why MySQL in a Business critical environment". His talk is planned for Sunday, April 6, 2014 @ 13:30.

    For the whole conference plan you can check the Schedule section of the LOADays website.

    See you there! 

    Annual EMEA User Group Leaders' Summit - May 21-22, 2014
    Employee_Team +1 Vote Up -0Vote Down

    Are you already a MySQL User Group Leader?

    or

    Are you thinking about taking this role in the near future?

    If yes, please let me invite you to the Annual User Group Leaders' Summit organized by Oracle User Group team. The purpose of this 2 days meeting is sharing the expertise, knowledge and share experience with leading the UG as well as learning of the new ways how to handle groups by using new technologies & tools (i.e. Cloud..).

    It is great opportunity to talk to other User Group leaders and share the experience and knowledge with them. There will be Java User Group, Oracle User Group and of course MySQL User Group Leaders!

    Find details about this event below and if you are interested and/or want to know more, please do not hesitate to contact

      [Read more...]
    MariaDB and WebScaleSQL
    +2 Vote Up -0Vote Down

    On Thursday MySQL technology saw a huge boost. It’s hard for anyone now to argue that MySQL isn’t in the game of extreme scalability and performance, which some NoSQL vendors have been using as a tagline for the last years. To see four of the largest MySQL and MariaDB users come together to bootstrap a branch of MySQL for extreme scaling needs is simply fantastic. The improvements done inside these companies will now be available to the rest of the community. In all fairness Facebook and Twitter, in particular, have been making their improvements publicly available also before. Google has also made some improvements available publicly over the years and have lately been active in the MariaDB project with code reviews, bug fixes and other patches. But broadening the public contributions further and combining it all, is new.

    Engineering of MySQL technology happens in many places. Aside from

      [Read more...]
    MariaDB in Google Summer of Code 2014
    +1 Vote Up -0Vote Down

    MariaDB is participating in the Google Summer of Code 2014. Students are encouraged to propose a project before the deadline (this Friday!).

    This is our second year participating, and as always we have an ideas page available. We also have a list of things we think are achievable in JIRA – check out our gsoc14 tag.

    In 2013, we had three projects, of which two are in MariaDB 10.0: PCRE regular expressions and Roles. The other will be targeted towards MariaDB 10.1. There’s nothing like having GSoC students participate and have their code

      [Read more...]
    Snippet: Fetching results after calling stored procedures using MySQL Connector/Python
    Employee +3 Vote Up -0Vote Down

    Problem

    Using MySQL Connector/Python, you are calling a stored procedure which is also selecting data and you would like to fetch the rows of the result.

    Solution

    For this example we create a stored procedure which is executing SHOW SLAVE STATUS.

    cnx = mysql.connector.connect(user='scott', password='tiger',
                                  database='mining')
    cur = cnx.cursor()
    cur.execute("DROP PROCEDURE IF EXISTS slave_status")
    proc = "CREATE PROCEDURE slave_status () BEGIN SHOW SLAVE STATUS; END"
    cur.execute()
    cur.call("slave_status")
    
    for result_cursor in cur.stored_results():
     for row in result_cursor:
       print(row[0])
    

    The result from the above would be:

    shell> python foo.py
    Waiting for master to send event
    

    Discussion

    The

      [Read more...]
    Showing entries 1 to 30 of 785 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.