X

MySQL and MySQL Community information

Recent Posts

Announcements

Where's the MySQL Team in October & November 2019

As follow up to the previous blog announcement we would like to inform you about where you can find MySQL & MySQL Community Team during October & November 2019. Please find the list below: October 2019: PerconaLive, Amsterdam, Holland, September 30-October 2, 2019 For detailed information see the blog post from last week. OpenTech Summit, Bangkok, Thailand, October 1-2, 2019 MySQL becomes a Gold sponsor with a Gold booth in the expo area and four MySQL talks as follows: "MySQL Overview for Oracle DBAs" given by Ryan Kuan, the MySQL Master Principal Solution Engineer. Talk scheduled for Oct 1 @14:00. "The Secret of MySQL InnoDB cluster Deployment" given by Ivan Ma, the MySQL Principal Solution Engineer. Talk scheduled for Oct 1 @14:30 "Unleasing the power of NoSQL using MySQL 8.0" given by Ryan Kuan. Talks scheduled for Oct 1 @ 16:00. "MySQL Troubleshooting and Performance Analysis" given by Ivan Ma. Talk scheduled for Oct 1 @16:30. Come to visit our booth to talk to our MySQL experts!  JCConf, Taipei, Taiwan (October 4, 2019) As a tradition MySQL is a Silver sponsor of this Java conference. This year you can find our team at the MySQL booth in the expo area as well as find a MySQL talk in the schedule as follows:  "How Java Leverage MySQL Cluster To Build Application with 99.9999% Availability" given by Ivan Tu, the MySQL Solution Engineering Manager. His talk is scheduled for 13:55-14:40. There is also a 3 minutes MySQL talk before sessions scheduled. We are looking forward to talking to you at JCConf this year! Gitex, Dubai, United Arab Emirates, October 6-10, 2019 As usual our MySQL representatives are present at Gitex in Dubai. You can find us at Oracle booth or around if you are present.  OpenSource Conference Enterprise, Tokyo, Japan, October 10, 2019 MySQL is a Gold sponsor of this OS Enterprise conference in Tokyo. You can find our team at MySQL booth in the expo area as well as find MySQL talk in the schedule. We are looking forward to talking to you in Tokyo! Little Rock Tech Fest, Little Rock, AR, US, October 10-11, 2019 As a Silver sponsor MySQL will get a booth in the expo area and this time also with a MySQL talk on: "Windowing Functions in MySQL" given by David Stokes, the MySQL Community Manager. His talk is scheduled for Oct 10 @3pm. Come to talk to us! UbuCon Europe, Sintra, Portugal, October 10-13, 2019 MySQL team is supporting this Ubuntu conference as Silver sponsor. This time you can find us talking about:  "Introduction to the new Oracle DBA: MySQL & Oracle." given by Keith Hollman, the MySQL Principal Sales Consultant. "MySQL 8.0: Highly Available, JSON, NOSQL & Document Store Straight out-of-the-box" given by Keith Hollman. See schedule for more details about both Keith's talks. Tiago Jorge talk approved: "MySQL 8.0: The New Replication Features" given by Tiago Jorge, the MySQL Software Architect. His talk is scheduled for Oct 12 @15:30 in Auditório Ubuntu. Zabbix Summit, Riga, Latvia, October 11-12, 2019 MySQL as as Silver sponsor will be available at the MySQL booth in the expo area as well as have following talk: "Scaling Zabbix with MySQL InnoDB Cluster" given by Vittorio Cioe, the MySQL Senior Sales Consultant. Please do not miss the opportunity to come and stop by at our booth and listen Vittorio's talk at Zabbix Summit 2019! All Things Open 2019, Raleigh, NC, October 13-15, 2019 MySQL is a Bronze sponsor of ATO 2019. You can find us at the MySQL booth #64 as well as attend the MySQL talk as follows:  "MySQL 8.0 New Features" scheduled for October 14 @1pm in the room 204. The speaker is David Stokes, the MySQL Community Manger. OpenSource Conference India (OSI Days), Bangalore, India, October 17-18, 2019 MySQL is becoming Associate Partner of OSI Days this year. You can see & talk to us at our MySQL booth in the expo area as well as attend the MySQL Keynote given by Sanjay Manwani, the MySQL India Sr. Director. The topic is "NoSQL + SQL = MySQL 8.0", the talk is scheduled for October 18 @9:30-10:15 am.  MOPCON, Taipei, Taiwan, October 19-20, 2019 We are happy to announce that this year again MySQL is a sponsoring partner of MOPCON 2019 in Taiwan. This year with a MySQL talk as follows:  "MySQL 8.0 的地理資訊系統 (GIS) 支援新世代行動應用" given by Ivan Tu, the MySQL Solution Engineering Manager. The talk is scheduled for October 19 @10:15 - 10:55am in a room 2, 4F. PHP[World], WDC, US, October 23-24, 2019 MySQL as a Bronze level sponsor this year at PHP[World] will be available at MySQL booth as well as got a talk accepted as follows: "MySQL's InnoDB Cluster" given by David Stokes, the MySQL Community Manager. Forum PHP, Paris, France October 24-25, 2019 MySQL is supporting Forum PHP this year as Bronze sponsor. There is going to be a MySQL representative around, unfortunately without a booth this year. November 2019: Big Mountain Data and Dev Conference, Salt Lake City, UT, USA, November 1-2, 2019 David Stokes, the MySQL Community Manager will have following talks at this free Data & Dev conference: "'When boring tech is better than too exciting tech" "MySQL Without the SQL - Oh My!" Highload++, Moscow, RF, November 7-8, 2019 Same as last year MySQL is a sponsorship partner of Highload++ conference in Moscow this year again. You can find our MySQL experts at the MySQL booth in the expo area as well as find two MySQL talks in the schedule (schedule is not fully announced yet). Both talks are given by Vittorio Cioe, the MySQL Senior Technical Sales Consultant, Oracle MySQL GBU ant their topics are: "Раскрытие секретов Group Replication в MySQL" "Новая инфраструктура компонентов в MySQL 8.0".  OpenSource Conference Fukuoka, Japan, November 9, 2019 MySQL is a Gold sponsor of this OS conference in Fukuoka. You will be able to find our team at our Gold MySQL booth in the expo area as well find our talk in the schedule, as follows: "MySQL開発最新動向-Oracle MySQL Cloud Serviceの最新情報もご紹介-" given by Yoshiaki Yamasaki, the MySQL Senior Solution Engineer, Asia Pacific and Japan We are looking forward to talking to you in Fukuoka! Next Generation Data Technology Development Forum, Zhenzhou, China, November 15-16, 2019 MySQL team is a partner of this Annual conference. Further details will be provided soon. BGOUG, Pravets, Bulgaria, November 15-17, 2019 As tradition MySQL is a partner of this Bulgarian Oracle User Group event in Pravets. This time you can find the MySQL talk given by Georgi Kodinov, the MySQL Software Development Director. Georgi's talk as follows: "MySQL Clone: A better way to migrate your data across MySQL servers", for timing please check the agenda. DOAG Conference 2019 – (Oracle User Group in Germany), Nuremberg, Germany, November 19-22, 2019 DOAG is the largest Oracle User Group conference in Germany, stretching over 3 days plus 1 day of trainings for those interested and we are happy to announce that MySQL is again part of it. You can find MySQL at the Oracle booth as well as find a MySQL talk in the schedule as follows:   "Oracle MySQL the “other” database from Oracle” given by Carsten Thalheimer and Henry Kröger. The talk delivers a brief overview over the different MySQL versions, as well as presenting a live demo on how to set up a MySQL database on Linux with some basic optimizations. Additionally, a comparison is made to other existing database technologies. This is followed by a short section on how the software is integrated with existing Oracle infrastructures utilizing for example OEM 13c. Last but not least the talk concludes with a couple of practical examples on how MySQL is managed in professional contexts and what additional tools (TDE, backup/recovery, data-masking, auditing, etc.) are available for these use cases. The talk is scheduled for Nov 21 @10:00-10:45.  Carsten & Henry will be part of the larger Oracle booth in which each subsection will have their own table, representing the different aspects of the Oracle technology portfolio.             

As follow up to the previous blog announcement we would like to inform you about where you can find MySQL & MySQL Community Team during October & November 2019. Please find the list below: October...

MySQL

OOW 2019 – MySQL Highlights

We just wrapped up what was a very exciting OOW 2019 - San Francisco for MySQL.  Our MySQL track included 29 sessions, a keynote with 2 customer testimonials (Mercari and WePay), 1 tutorial, 1 Hands-on lab, 1 Birds of a Feather, and our always fun and enjoyable MySQL Community Reception.   A BIG Thank You to the companies who came to share their experience and testimonial about how MySQL helps scale their company such as Facebook, JP Morgan Chase WePay, Credorax, Mercari, Zuora, and more. Our focus this year: SECURITY.  With 3,800 breaches and over 4 Billion Records Stolen in just H1 2019, securing data has become a priority for any business. The first part of the keynote covers the new security features from Oracle and MySQL implemented in our latest version of the Enterprise Edition. Other highlights for MySQL: MySQL 8.0,  fastest adoption of any version with over 26% in a year New MySQL Analytics Service, faster than Google BigQuery says Mercari HA with MySQL InnoDB Cluster Microservices with MySQL and Vitesse on Kubernetes NoSQL with NodeJS and MySQL Document Store Many of the sessions are now available online: Keynote: State of the Dolphin with: Rich Mason,, MySQL General Manager Tomas Ulin, MySQL VP of Engineering Nipun Agarwal, Oracle Labs, VP of R&D Kenichi Sasaki, Mercari Rich Steenburg, WePay Recorded sessions: MySQL 8.0 at Facebook Managing MySQL at Scale in Facebook Python and MySQL 8.0 Document Store Running MySQL on Kubernetes the Easy Way MySQL with ProxySQL at Zuora What’s New in MySQL Optimizer and Executor? Using MySQL as a Document Store with Native APIs Building Carefree Data-Driven Applications with the MySQL X DevAPI Foreign Key Support in MySQL 8.0: Change, Opportunities, and More...   If you’d like to participate at one of our Oracle Open World events, or at a MySQL event, to share your experience and knowledge of MySQL and how MySQL helps scale your company, contact us through Chat or through your Sales representative. 

We just wrapped up what was a very exciting OOW 2019 - San Francisco for MySQL.  Our MySQL track included 29 sessions, a keynote with 2 customer testimonials (Mercari and WePay), 1 tutorial, 1...

Announcements

Where is the MySQL team this and next week?!

This week you can find our MySQL & MySQL Community experts at following shows: db tech showcase, Tokyo, Japan, September 25-27, 2019 MySQL team as Silver sponsor will have a booth in the expo area and in total 5 speaking slots related to MySQL as follows:  Two User Case Studies of MySQL Two Technical Sessions by MySQL User Community members (MyNA) MySQL Server, MySQL Workbench and MySQL Shell by MySQL GBU  Please watch organizers' website for more details. PerconaLive, Amsterdam, Holland, September 30-October 2, 2019 MySQL team is going to become Silver partner of PerconaLive Amsterdam this year. Do not miss the chance to talk to our experts at MySQL booth in the expo area & come to multiple MySQL talks which were accepted, see below: "MySQL 8.0: The New Replication Features" given by Luis Soares, the MySQL SW Development Director. "MySQL 8.0 InnoDB Cluster - Easiest Tutorial!" given by Kenny Gryp, the MySQL Principal Product Manager & Frédéric Descamps (lefred), the MySQL Community Manager. "MySQL InnoDB Cluster - Advanced configuration & operation" given by Pedro Gomez, the MySQL Senior Software Developer & Frédéric Descamps (lefred), the MySQL Community Manager. "InnoDB management and scalability improvements in MySQL 8." given by Sunny Bains, the Senior Software Development Director. "MySQL Shell : the best DBA tool ? - Extend the Shell with the new plugin infrastructure" given by Frédéric Descamps (lefred), the MySQL Community Manager. "MySQL 8.0 Performance: Scalability & Benchmarks" given by Dimitri Kravtchuk, the Performance Architect. "Automatic Upgrade and New Error Logging in MySQL 8.0" given by Stale Deraas, the Software Development Director. "JSON Array Indexes in MySQL" given by Norvald Ryeng, the Software Development Sr. Manager. "How to Instrument Your Code in Performance Schema" given by Georgi Kodinov, the MySQL Software Development Director.  "MySQL 8.0.18: Latest Updates" by Norvald Ryeng, the Software Development Sr. Manager. This is the very first presentation about HASH JOINS and EXPAIN ANALYZE, two major new features. We are looking forward to seeing and talking to you at PL 2019! JCConf, Taipei, Taiwan, October 4, 2019 As tradition MySQL is a Silver sponsor of this Java conference. This year you can find our team at the MySQL booth in the expo area as well as find a MySQL talk as follows: "How Java Leverage MySQL Cluster To Build Application with 99.9999% Availability" given by Ivan Tu, the MySQL Solution Engineering Manager. His talk is scheduled for 13:55-14:40. There is also a 3 minutes talk before sessions. We are looking forward to talking to you at JCConf this year!

This week you can find our MySQL & MySQL Community experts at following shows: db tech showcase, Tokyo, Japan, September 25-27, 2019 MySQL team as Silver sponsor will have a booth in the expo area and...

Announcements

Where's the MySQL Team in August & September 2019

As follow up to the previous blog announcement about the conferences and events MySQL Team is attending, we would like to inform you about where you can find us during August & September 2019. Please find the list below. August 2019: Mid-Atlantic Developer Conference, Baltimore, US, August 1-2, 2019 MySQL Community team is a Bronze sponsor of this Developer conference. Our MySQL Community Manager, David Stokes will be giving 2 sessions as follows: "MySQL & GIS" scheduled for Aug 1 @11:30-12:30pm "MySQL without the SQL — Oh My!" Aug 2 @10:15-11:15am Please do not forget to attend the MySQL sessions as well as stop by at our MySQL both in the expo area! OpenSource Conference Kyoto, Japan, August 2-3, 2019 As tradition MySQL is a Gold sponsor of this OS show in Japan. This time you can find us at the MySQL booth in the expo area as well as you can find a MySQL talk in the schedule as follows: "MySQL Development Trends-Introducing the Latest Information on Oracle/MySQL Cloud Service" given by Yuki Yamazaki. The talk is scheduled for Aug 3, @15:15-16:00. ​Kansas Linux Fest (KLF), Wichita, Kansas City, US, August 9-11, 2019 MySQL Community team became a Silver sponsor of this Linux event. You can find our MySQL Community Manager, David Stokes there talking about MySQL during his two accepted sessions. The schedule is not yet done, so please watch the conference's website for further updates on timing and place: "MySQL Without the SQL - Oh My!" "The Proper Care and Feeding of a MySQL Database for Busy Linux Administrators".  ​FrOSCon 2019, Snkt. Augustin, Germany, August 10-11, 2019 As tradition MySQL is part of this OS show in Germany. You can visit our MySQL experts at the MySQL booth in the expo area as well as you can attend a MySQL session given by Carsten Thalheimer, the MySQL Master Principal Sales Consultant. The session is: "MySQL Best Practices - In 8 Schritten zur optimierten Datenbank!", scheduled for Sun, Aug 11 @14:00-15:00. ​COSCUP, Taipei, Taiwan, August 17-18, 2019 MySQL is, same as last year, Gold sponsor of COSCUP Conference. You can find our team at the MySQL booth in the expo area as well as find multiple MySQL related talks in the schedule, see some of them below. The full schedule can be found here (Day 1) & here (Day 2). "MySQL InnoDB Custer" given by Ivan Ma, the MySQL Principal Solution Engineer. Ivan's talk is scheduled for Aug 17 @10:45-11:25am. "MySQL Performance - the Dos and Don'ts" given by Yoshiaki Yamasaki, the MySQL Senior Solution Engineer. His talk is scheduled for Aug 17 @13:25-14:05. "MySQL 8.0有那些值得注意的新發展" given by Ryusuke Kajiyama, the MySQL Sales Consulting Senior Manager. His talk is scheduled for Aug 17 @14:55-15:35. ... other MySQL related talks are scheduled for Day 2 (Aug 18) from 10:00-16:00 in IB302 room. ​FOSS4G, Tokai, Japan, August 23-24, 2019 MySQL is a partner of OSGeo.JP group which is organizing FOSS4G events. The previous FOSS4G event we also attended took place in Hokkaido last month. MySQL got an opportunity to run MySQL seminar at this show. At this moment we do not know more details, please check organizers' website for further updates. OpenSource Developer Conference, Tokyo, Japan, August 24, 2019 Same as last year we are glad to inform you that MySQL is Gold sponsor of this one day show. This year you could be again able to find our team at the MySQL booth in the expo area as well as attend the MySQL session as follows: "Not only MySQL Server, there is also MySQL Shell" given by Ikoma Tomoko. The talk is scheduled for 15:15-16:00. We are looking forward talking to you in Tokyo! September 2019: SwanseaCon, Swansea, UK, September 9, 2019 We are happy to announce that MySQL is again back in the UK for the lovely SwanseaCon event! This year our new colleague will staff the MySQL booth as well as run the MySQL talk. We are looking forward seeing you there! Please do not miss the talk as follows: "NoSQL + SQL = MySQL" given by Stuart Davey, the MySQL Principal Sales Consultant. His talk is scheduled for 11:15-12:00 FOSS4G Niigata, Japan, September 13-14, 2019 MySQL is a partner of OSGeo.JP group which is organizing FOSS4G events. MySQL got an opportunity to run MySQL seminar at this show. At this moment we do not know more details, please check organizers' website for further updates. OpenSource Conference, Hiroshima, Japan, September 15, 2019 As usual MySQL is a Gold sponsor of this OS show, this time in Hiroshima. Do not miss to stop by at our MySQL booth in the expo area as well as come to listen the MySQL talk as follows:  "Finally released! MySQL 8.0 Latest information" given by Yuka Yamazaki from Oracle/MySQL Community. The talk is scheduled for 16:10-16:55. Oracle Open World / MySQL Reception, San Francisco, US, September 16-19, 2019 Same as last year MySQL will be part of OOW in San Francisco. Right now we are planning to hold a MySQL Reception on the Sep 17, 2019 as the evening with all MySQLers coming to OOW. More details will be published once the place is fully booked. Just please mark your calendars for the date and more details will come soon! WebExpo, Prague, CZ, September 20-22, 2019 This is the fifth time MySQL is partner of WebExpo, the biggest technology conference in the Czech republic! This year, same as last year you will be able to find two teams at Oracle booth in the expo area, NetSuite (Bronto) team & MySQL. Do not forget to stop by! You can also attend the MySQL talk given by Vittorio Cioe, the Senior MySQL Sales Consultant as follows: "Modern Data Security with MySQL 8.0", scheduled for Sat, Sep 21 @14:00-14:40pm. db tech showcase, Tokyo, Japan, September 25-27, 2019 We are happy to announce that MySQL is again part of this DB show in Tokyo. We became Silver sponsor with a MySQL booth and speaking opportunity. MySQL got 2 speaking slots as well as 2 MySQL case study sessions and one session for MySQL User Group. Please watch organizers' website for further updates. PerconaLive, Amsterdam, Holland, September 30-October 2, 2019 MySQL team is going to become Silver partner of PerconaLive Amsterdam this September. The schedule and planning is not yet done, but we assume to have multiple MySQL talks as well as MySQL booth in the expo area. Do not miss to come to talk to us! We are looking forward talking to you!​​

As follow up to the previous blog announcement about the conferences and events MySQL Team is attending, we would like to inform you about where you can find us during August & September 2019. Please...

Announcements

Jun 17: Events with MySQL this week!

Just a reminder for the shows where you can find MySQL at this week, please find them below: GigaCon - OS Business, Warsaw, Poland, Jun 18, 2019 Vittorio Cioe, the Sr. MySQL Sales Consultant will talk about MySQL Enterprise during the shared slot with Linux/Cloud team. Talk is scheduled for 10:05-10:25 on Jun 18. OpenExpo Europe, Madrid, Spain, Jun 20, 2019 Find MySQL & Linux team at our shared booth at OpenExpo Europe as Gold sponsor. Planned MySQL talk: "MySQL 8.0: Highly Available, JSON , NoSQL & Document Store" by Keith Hollman, the MySQL Principal Sales Consultant. Time: 16:40-17:10. DataOps Barcelona, Spain, Jun 20-21, 2019 Do not miss the MySQL talk on: "Deep dive into MySQL Group Replication: the magic explained" given by Frederick Descamps, the MySQL Community Manager. His talk is scheduled for June 20 @11:30 in the Room A-4. RootConf 2019, Bangalore, India, Jun 21-22, 2019 There should be a MySQL 8 talk, but for some reason it is not in the official schedule. Come to our booth to ask for the talk location, hearing about the news in MySQL and talking to our MySQL experts! We are looking forward seeing you there. DevConf, Moscow, RF, Jun 21-22, 2019 Do not. miss the MySQL talk on: "NoSQL + SQL = MySQL 8 Document Store!" given by Vittorio Cioe, the Sr. MySQL Sales Consultant. Vittorio's talk is scheduled for Jun 26th @12:30pm. 

Just a reminder for the shows where you can find MySQL at this week, please find them below: GigaCon - OS Business, Warsaw, Poland, Jun 18, 2019 Vittorio Cioe, the Sr. MySQL Sales Consultant will talk...

Announcements

Where you can find MySQL this week

Our pleasure to remind everyone about three events which are happening this week and MySQL is part of. Please find them below. PerconaLive, Austin, TX, US, May 28-30, 2019 as we previously announced MySQL is Silver sponsor w/ booth and several MySQL related talks as follows: Tuesday, May 28, 2019: MySQL Tutorial on: "MySQL InnoDB Cluster in a Nutshell: The Saga Continues with 8.0, the full guide" by Frederic Descamps & Kenny Gryp. Time: 9:30-12:30pm. Wednesday, May 29: 11:00-11:50, Room: Hill Country A: "Complex Stateful Applications Made Easier with Kubernetes" by Patrick Galbraith, the Principal Member of MySQL development 11:00-11:50, Room: Texas 1: "InnoDB Management and Scalability Improvements in MySQL 8.0" by Sunny Bains, the MySQL SW Development Director 11:55-12:45, Room: Texas 1: "New Features in MySQL 8.0 Replication" by Luis Soares, the MySQL SW/Replication Development Director   14:00-14:50, Room: Texas 1: "MySQL 8.0 Performance: Scalability & Benchmarks" by Dimitri Kravtchuk, the MySQL Performance Architect 17:10-17:35, Room: Texas 7: "LATERAL Derived Tables in MySQL 8.0" by Norvald Ryeng, the Senior SW/Optimizer Development Manager 17:40-18:05, Room: Texas 7: "MySQL Shell: The Best DBA tool? How to Use the MySQL Shell as a Framework for DBAs" by Frederic Descamps, the MySQL Community Manager Thursday, May 30: 14:00-14:50, Room: Texas 1: "Automatic Upgrade and New Error Logging in MySQL 8.0" by Stale Deraas, the MySQL SW Development Director 14:55-15:45, Room: Texas 1: "MySQL Group Replication: The Magic Explained v2" by Frederic Descamps, the MySQL Community Manager. ​​Texas Linux Fest, Austin, TX, US, May 31-Jun 1, 2019 MySQL is a Silver sponsor with a booth & MySQL talks (below) given by David Stokes, the MySQL Community Manager "An Intro to MySQL", scheduled for Friday, May 31 @2:00-5:00pm, "New Features in MySQL for Developers", scheduled for Saturday, June 1 @10:00-10:45am "How to give back to Open Source", scheduled for Saturday, June 1 @4:30-5:15 ​OpenSource Conference, Hokkaido, Japan, May 31-Jun1, 2019 As we already announced MySQL is a Gold sponsor of this OS show. Our MySQL local team is going to staff the MySQL booth in the expo area as well having a MySQL talks as follows:   "MySQL Update + MySQL InnoDB Cluster" given by Daisuke Inagaki, the MySQL Principal Solutions Engineer. His talk is being hold on May 31 @13:55. "MySQL - latest information & peripheral information by Kei Skai & Yoku0825" this talk is given by MyNA (MySQL Nippon Association) by Kei Sakai & Yoku0825, the Vice Presidents of MyNA. The talk is scheduled for June 1 @11:00.​  

Our pleasure to remind everyone about three events which are happening this week and MySQL is part of. Please find them below. PerconaLive, Austin, TX, US, May 28-30, 2019 as we previously announced...

Announcements

Where you can find MySQL in June-July 2019

As continue of our previous announcement from March 14, please find below a list of shows & conferences where you can find MySQL team at: June 2019: OpenSource Conference, Hokkaido, Japan, May 31-June 1, 2019 As we already announced MySQL is a Gold sponsor of this OS show. Our MySQL local team is going to staff the MySQL booth in the expo area as well having a MySQL talks as follows: "MySQL Update + MySQL InnoDB Cluster" given by Daisuke Inagaki, the MySQL Principal Solutions Engineer. His talk is being hold on May 31 @13:55. "MySQL - latest information & peripheral information by Kei Skai & Yoku0825" this talk is given by MyNA(MySQL Nippon Association) by Kei Sakai & Yoku0825, the Vice Presidents of MyNA. The talk is scheduled for June 1 @11:00.  DOAG - Databanken, Dusseldorf, Germany, June 3-4, 2019 MySQL Community Team is Gold sponsor of this Oracle User Community event in June. We are having a booth in the expo area as well as approved MySQL talk on "MySQL Cloud/MySQL Analytic" given by Carsten Thalheimer, the MySQL Master Principal Sales Consultant. See in German DevTalks Romania, Bucharest, Romania, June 6-7, 2019 MySQL Community Team is a Silver sponsor of this show with a MySQL talks & booth in the expo area. This year we are going to share the booth with a Oracle Bronto (NetSuite Development) team. You can find two MySQL talks in the agenda, both given by Georgi Kodinov, the Team Lead, MySQL Server General Team: "What's New in MySQL 8.0 Security" scheduled for June 7 @15:40-16:20 & "MySQL Enterprise Data Masking" scheduled for June 6 @15:40-16:20. We are looking forward seeing & talking to you at DevTalks this year! BGOUG, Pravets, Bulgaria, June 7-9, 2019 As tradition MySQL Community Team & Oracle are the partners of this Bulgarian Oracle User Community event in Pravets. This year the Sr. MySQL Sales Consultant, Vittorio Cioe will be talking about "MySQL InnoDB Cluster: High availability with no stress!". Hong Kong Open Source Conference, Hong Kong, June 14-15, 2019 Again this year we are part of this biggest OS show in Hong Kong. We are Silver sponsor with a MySQL booth in the expo area. Also you can find three MySQL related talks & one talk from Oracle GraalVM on the second day morning MySQL track. We are looking forward talking to you at HKOS this year! SouthEast Linux Fest (SELF), Charlotte, US, June 14-16, 2019 We are again back at SELF as Diamond sponsor this year. We are going to have MySQL booth in the expo area as well as MySQL talk(s) hopefully to be approved. We have submitted several proposals, so please watch organizers website for schedule update to see when & where our talks will be hold. We are looking forward talking to you @SELF 2019! GigaCon - OpenSource Business, Warsaw, Poland, June 18, 2019 For the first time MySQL got an opportunity to share a talking slot with Oracle Linux/Cloud team. Vittorio Cioe, the Sr. MySQL Sales Consultant who represents MySQL will talk about MySQL Enterprise. The joined talking slot is scheduled for Jun 18 @ 10:05-10:25. OpenExpo Europe, Madrid, Spain, June 20, 2019 MySQL Community Team in cooperation with Oracle Linux team are Gold sponsor of OpenExpo Europe this year. You can find our staff at MySQL/Linux booth in the expo area as well as find MySQL & Linux talks in the schedule. For MySQL the talk will be given by Keith Hollman, the MySQL Principal Sales Consultant. Keith's talk on "MySQL 8.0: Highly Available, JSON, NoSQL & Document Store straight out-of-the-box!" is scheduled for Jun 20 @16:40-17:10. DataOps Barcelona, Barcelona, Spain, June 20-21, 2019 MySQL Community Team is a Community sponsor of DataOps Barcelona with a talk on: "Deep dive into MySQL Group Replication: the magic explained" given by Frederick Descamps, the MySQL Community Manager. His talk is scheduled for June 20 @11:30 in the Room A-4. RootConf 2019, Bangalore, India, June 21-22, 2019 MySQL Community team with the local MySQL team are Bronze partner of RootConf this year. We are going to have a MySQL booth in the expo area. We should also have an approved MySQL talk which is not yet in the schedule. Please watch organizers' website for further updates. DevConf, Moscow, RF, June 21-22, 2019 It is our pleasure to announce that one of submitted MySQL talk was accepted by DevConf conference Moscow this year! Please do not miss the opportunity to hear more about "NoSQL + SQL = MySQL 8 Document Store!" given by Vittorio Cioe, the Sr. MySQL Sales Consultant. Vittorio's talk is scheduled for Jun 26th @12:30pm.  Devoxx, Krakow, Poland, June 24-26, 2019 Oracle is a sponsor of this show and MySQL will be part of the central Oracle booth in the expo area among the Java, Graal VM, Fn & Linux teams. We are going to run MySQL demo at the demo station and our MySQL expert, Vittorio Cioe, the Sr. MySQL Sales Consultant will be there to answer your questions and discuss the MySQL topics.  MySQL User Group Frankfurt - Meetup, Germany, June 27, 2019 MySQL User Group Frankfurt organizes a Meetup with Carsten Thalheimer, the MySQL Master Principal Sales Consultant as a speaker. Carsten will talk about "MySQL 8 - The Next big Thing!" and the talk should start @7pm. Please find more details here. July 2019: Oracle Global Partnership Summit, Munich, Germany, July 9-11, 2019 Oracle University is hosting its first ever Global Partner Summit July 9-11 in Munich, Germany. Partners will have the opportunity to hear directly from Oracle Product and Oracle University leadership on FY20 strategy and product roadmaps, helping partners identify new market opportunities and also learn ways grow their business with Oracle. Rich Mason, the Senior VP and General Manager for MySQL will have a keynote & Carsten Thalheimer, the MySQL Master Principal Sales Consultant will run a technical session during this 3 day Oracle event. Learn more about the event and register now! MySQL User Group Munich - Meetup, Germany, July 11, 2019 MySQL User Group Munich organizes a Meetup with Carsten Thalheimer, the MySQL Master Principal Sales Consultant as a speaker. Carsten will talk about "MySQL 8 - The Next big Thing!" and the talk should start @7:30pm.  OpenSource Conference, Nagoya, Japan, July 13, 2019 MySQL Community team in cooperation with local MySQL are Gold sponsor of this OS show in Nagyoa. You can find us at the MySQL booth in the expo area as well as find MySQL talk in the schedule as follows: "MySQL Update" by Machiko Ikoma, the MySQL Principal Solution Engineer. We look forward talking to you at OSC Nagyoa! FOSS4G Hokkaido, Japan, July 12-13, 2019 MySQL is a partner of OSGeo.JP group which is organizing FOSS4G event. At this moment we are working on the seminar topic as well as on other benefits MySQL will get. Please stay tuned for further updates.​

As continue of our previous announcement from March 14, please find below a list of shows & conferences where you can find MySQL team at: June 2019: OpenSource Conference, Hokkaido, Japan, May 31-June...

MySQL Community Contributor Award Program 2019

We would like to announce that MySQL Community Team 2019 MySQL Contributor Reward Program winners. This award started in 2015 to identify & reward the most active community members from the MySQL Community world. MySQL Community Team let printed a limited edition of “MySQL Community Contributor” t-shirts which were already distributed to almost all winners. Same as in 2015 also now specific criteria for the nominations were wet as follows: The most active code contributor Bug reporter The most active MySQL blogger People who plays very active role in translation/documentation of MySQL articles People who provides feedback on DMR releases, Labs releases, or change proposals Anyone in the community who worked their butt off or did really useful work that you feel should be thanks publicly We are happy to announce that the people below successfully met one or more criteria above, were nominated by MySQL group and approved by our committee, please join us to congratulate to them! Laurynas Biveinis for a lot of code contributions & bug submissions Daniel Black for multiple of his code contributions & bug submissions René Cannaò for ProxySQL & for his continuous support of it Vin Chen @Tencent Games CROS DBA Team for the Instant Add Column as a main contribution to MySQL 8.0 Daniel Van Eeden, the MySQL ACE for a lot of code contributions in a lot of areas (connectors, the server, etc.), and the detailed feedback for the bugs or issues he found Gabriela D'Ávila Ferrara for interesting blogs about MySQL Bill Karwin for his active role on many MySQL forums (MySQL, Stack Overflow, Quora, &c.), as well as for multiple speeches focusing on all things SQL Alexey Kopytov for the new Sysbench code (the #1 tool for MySQL Performance evaluation) Felix Liang @Tencent Games CROS DBA Team for his active role in ACMUG (Chinese MySQL User Group) and contributions to the Instant Add Column in MySQL 8.0  Tomita Masahiro for supporting MySQL community and for the MySQL Parameters tool Giuseppe Maxia for the amazing feedback provided to us, for his blog posts & for dbdeployer Simon Mudd for his active role in Madrid MySQL UG and, for a number of bugs submitted, for contributing the original logging to syslog, and other tools such ps-top Shlomi Noach for delivering open source solutions to solve cases around MySQL and for multiple MySQL talks as well as for the tooling within the MySQL space, such as MySQL orchestrator and ghOST Zsolt Parragi for a lot of code contributions & bug submissions Alex Rubin for extensive testing of our new DD code and for bug submissions Sveta Smirnova for popularization of MySQL Performance Schema, general MySQL troubleshooting and promoting new mysql features Yura Sorokin for a lot of code contributions & bug submissions Sugu Sougoumarane for running Vitess.io and helping the users on multiple places Peter Zaitsev for his active role in MySQL world as well as for his contributions to MySQL Community Please join us to congratulate to all above!   

We would like to announce that MySQL Community Team 2019 MySQL Contributor Reward Program winners. This award started in 2015 to identify & reward the most active community members from the MySQL...

Announcements

Shows w/ MySQL this week

Just a friendly reminder for the busy week we have ahead of us... Please find below the shows you can find our MySQL staff at: First show where you can fid us at is the Oracle Code in Shenzen, China 2019, April 16, 2019  ​JSON is one of the flexible data for data exchange and storage today. MySQL X-DevAPI introduces a new modern and easy-to-learn way to work with JSON and Relational data.  Do not miss the MySQL session scheduled for 4:05pm - 4:50pm as follows: "NoSQL @ MySQL - Managing JSON Data with reliable and secured MySQL Database" by Ivan Ma, from Oracle MySQL Team & Zhou Yin Wei - Oracle MySQL ACE Director ​Second show is OpenSource 101, Columbia, SC, US, April 18, 2019 ​MySQL & Oracle Back-end IT solutions group are together attending this show. Find us at the shared booth in the expo area as well as do not miss following MySQL talk: "MySQL 8.0 New Features" by David Stokes, the MySQL Community Manager (Apr 16@1:30-2:15pm, 1C Conference Room) ​Last conference with MySQL is OpenSource Conference Okinawa, Japan, April 20, 2019 ​Do not miss the MySQL talk focused on the newest trends in MySQL development and demonstration of MySQL Document Store with Java App. The talk is given by Yoshiaki Yamasaki, the MySQL GBU. Come to talk to us at our MySQL booth in the expo area as well!  

Just a friendly reminder for the busy week we have ahead of us... Please find below the shows you can find our MySQL staff at: First show where you can fid us at is the Oracle Code in Shenzen, China...

Announcements

Where you can find MySQL in April & May 2019

.As a continue of the blog post submitted on Jan 31, we would like to share with you the list of events & conferences where you can find MySQL Community team and/or MySQL experts at. Please find below the list with all known details we have right now.  April 2019: Oracle Code, Rome, Italy, April 4, 2019 A MySQL talk was accepted for this Oracle show. Please find a talk on "NoSQL+SQL=MySQL" given by Frederick Descamps, the MySQL Community Manager. DrupalCon, Seattle, US, April 8-10, 2019 This time you can find a talk of "MySQL 8 Features for Developers" given by David Stokes, the MySQL Community Manager. PyTexas, Austin, TX, April 13-14, 2019 We are again proud to sponsor PyTexas and will have a booth there, so you can see new features in MySQL 8.0 and MySQL Document Store. FOSS4G, San Dieago, US, April 15-18, 2019 We are happy to inform you that a MySQL talk was accepted for FOSS4G-NA conference! Please find following session in the agenda: MySQL & GIS" by David Stokes, the MySQL Community Manager. His talk is scheduled for Apr 17 @11:30-12:00pm. Oracle Code, Shenzhen, China, April 16, 2019 "How to Write an Efficient SQL" by Ting Yu Yang, the MySQL SE. The talk is scheduled for 12:20-13:05. OpenSource 101, Columbia, SC, US, April 18, 2019 We are happy to announce that MySQL together with the Oracle back-end IT solutions group are going to be part of this show. You can find both groups at the Oracle/MySQL stand as well as attend MySQL talk as follows: "MySQL 8.0 New Features" given by David Stokes, the MySQL Community Manager. Talk is scheduled for 1:30-2:15pm in the 1C Conference Room We are looking forward talking to you at OS 101! OpenSource Conference Okinawa, Japan, April 20, 2019 As a tradition we are again Gold sponsor of this OS show this time in Okinawa. As usual you can find our team at MySQL booth in the expo area as well as find our MySQL talk in the schedule. We are looking forward to talking to you and seeing you at the MySQL session! Great Indian Developer Summit (GIDS), Bangalore, India, April 22-26, 2018 Oracle is going to be a sponsor of GIDS and MySQL is invited to be part of the Oracle's booth in the expo area.  Since the schedule is not yet done, please watch the organizer's website for the update on the MySQL talk in DATA track on "MySQLaaS and RAPID". We are looking forward to talking to you at GIDS this year! LinuxFest Northwest, Bellingham, US,  April 26-28, 2019 We are happy to be part of of this Linux show again. This year we are again Gold sponsor with a MySQL booth in the expo area and the talk as follows: "7 Database Mistakes You Are Making and MySQL 8 Features for Developers" given by David Stokes, the MySQL Community Manager. Since the schedule is not yet announced, please watch organizer's website for further updates. We are looking forward seeing you again and talking to you @LinuxFest Northwest! ​May 2019: Longhorn PHP, Austin, TX, US, May 2-4, 2019 This year for the second time we are Gold sponsor of Longhorn PHP show in Austin, Texas. Same as last year you can find us at MySQL booth in the expo area as well as you can find MySQL talk in the schedule as follows: "MySQL 8 Features for Developers" given by David Stokes, the MySQL Community Manager. His talk is scheduled for May 3, 2019 @2:15-3:15pm. Please do not forget to stop by at our booth, we are looking forward to talking to you there! PyConX, Florence, Italia, May 2-5, 2019 This year MySQL Community team is a Patron sponsor of this Python conference in Florence. This time without a booth but you can find a MySQL session in the schedule as follows: "Python and the MySQL Document Store" given by Frederic Descamps, the MySQL Community Manager. His talk is scheduled for Friday, May 3 @11:15 - 12:00. OpenSource Day, Warsaw, Poland, May 14, 2019 This is our third time participating and sponsoring OpenSource Day in Warsaw Poland. This year again MySQL is having a booth as well as a talk given by Vittorio Cioe, the MySQL Senior Sales Consultant. Vittorio will hold a session on "MySQL InnoDB Cluster: High Availability with no stress!" topic. Please watch organizer's website for further updates, We are looking forward to seeing & talking to you at OS Day Poland this year! PHPTek19, Atlanta, US, May 21-23, 2019 The MySQL Community team is again a proud sponsor of this great event. OpenSUSE, Nuremberg, Germany, May 24-26, 2019 As a tradition MySQL is part of the OpenSUSE conferences. This year we are again Silver sponsor but unfortunately without any talk. You can find us at the MySQL booth in the expo area. Please do not hesitate to come to our booth to discuss MySQL questions & news! PerconaLive, Austin, TX, US, May 28-30, 2019 MySQL Community team is a Silver sponsor of PerconaLive in Austin. You can find our staff at the MySQL booth in the expo area as well as find plenty of MySQL talks there. Below you can find just the ones given by our team members: Tuesday, May 28: MySQL Tutorial on: "MySQL InnoDB Cluster in a Nutshell: The Saga Continues with 8.0, the full guide", given by Frederic Descamps, the MySQL Community Manager & Kenny Gryp. The room & time is still not confirmed. Please watch organizer's website for further updates. Wednesday, May 29: 11:00-11:50: "Complex Stateful Applications Made Easier with Kubernetes" by Patrick Galbraith, the Principal Member of MySQL development 11:00-11:50: "InnoDB Management and Scalability Improvements in MySQL 8.0" by Sunny Bains, the MySQL SW Development Director 11:55-12:45: "New Features in MySQL 8.0 Replication" by Luis Soares, the MySQL SW/Replication Development Director  14:00-14:50: "MySQL 8.0 Performance: Scalability & Benchmarks" by Dimitri Kravtchuk, the MySQL Performance Architect 17:10-17:35: "LATERAL Derived Tables in MySQL 8.0" by Norvald Ryeng, the Senior SW/Optimizer Development Manager 17:40-18:05: "MySQL Shell: The Best DBA tool? How to Use the MySQL Shell as a Framework for DBAs" by Frederic Descamps, the MySQL Community Manager Thursday, May 30: 14:00-14:50: "Automatic Upgrade and New Error Logging in MySQL 8.0" by Stale Deraas, the MySQL SW Development Director 14:550-15:45: "MySQL Group Replication: The Magic Explained v2" by Frederic Descamps, the MySQL Community Manager. We are looking forward being part of this show and invite you to come to talk to our team at PerconaLive Austin! Texas Linux Fest, Austin, TX, US, May 31-June 1, 2019 We are happy to announce that MySQL is going to be a Silver sponsor of this show & hopefully we will get at least one speaking slot approved by organizers. The schedule is not yet done, so please watch organizers website for further updates. OpenSource Conference, Hokkaido, Japan, May 31-June 1, 2019 As a tradition MySQL is a Gold sponsor of this OS show in Japan. Our local MySQL team is going to staff & hold the MySQL booth as well as the MySQL session. Please watch the organizer's website for further updates. More will come soon...  

.As a continue of the blog post submitted on Jan 31, we would like to share with you the list of events & conferences where you can find MySQL Community team and/or MySQL experts at. Please find...

Announcements

FOSSASIA Summit 2019 with MySQL

MySQL Community with an APAC MySQL team are going to be part of the FOSSASIA Summit this week. We are a Bronze sponsor with a MySQL booth in the exhibition area. We are also having several talks in the Database track on Saturday, March 16, please see some of them below together with the details about the show: Name: FOSSASIA Summit 2019 Place: Singapore Date: March 14-17, 2019 MySQL talks in Database Track on Mar 16 in Training Room 2-1: "Replication: What's New in MySQL 8.0" by Narendra S Chauhan, the Principal Technical Staff @Replication Development team. The talk is scheduled for 10:55-11:20. "Upgrading to MySQL 8.0+, a more automated experience" by Nisha Gopalakrishnan, the Principal Technical Staff @MySQL Server Development team. The talk is scheduled for 11:25-11:50. "Performance Schema - A great insight of running MySQL Server" by Mayank Prasad, the Principal Technical Staff @MySQL Development team. The talk is scheduled for 14:00-14:25 "Docker Compose Setup for MySQL InnoDB Cluster" by Balasubramanian Kandasamy, the Senior Software Development Manager in MySQL Release Engineering team. Talk is scheduled for 14:30-14:55. "Utilize and take advantage of Optimizer Features in MySQL 8.0" by Amit Bhattacharya, the Senior SW Development Manager @MySQL Optimizer, InnoDB, Runtime & Server Testing team. Talk is scheduled for 15:00-15:25. "MySQL NDB Cluster: Set up a shared nothing high availability cluster in 15 minutes" by Saroj Tripathy, the QA Architect for MySQL Cluster team. Talk is scheduled for 15:45-16:10. "Using JSON in MySQL to get the best of both worlds (JSON + SQL)" by Chaithra Gopalareddy, the Senior Principal Member Technical Staff @MySQL Development. Talk is scheduled for 16:15-16:40. "Improving Database Security with MySQL 8.0" by Harin Nalin Vadodaria, the Principal MTS with MySQL engineering team. Talk is scheduled for 16:45-17:10. and more in the Database track... We are looking forward to meeting & talking to you @FOSSASIA Summit 2019!!!

MySQL Community with an APAC MySQL team are going to be part of the FOSSASIA Summit this week. We are a Bronze sponsor with a MySQL booth in the exhibition area. We are also having several talks...

Announcements

Where you can find MySQL in February & March 2019!

We continue with announcing the upcoming shows & conferences where you can find MySQL Community or MySQL Experts at. Please find the list of events with details below.  February 2019: FOSDEM 2019, Brussels, Belgium, February 1& 2-3, 2019 MySQL is again part of FOSDEM. Again this year with a MySQL booth & the whole day of MySQL dedicated talks in the MySQL track, see schedule here. There is also MySQL Pre-Fosdem Day followed by MySQL Pre-Fosdem Dinner, both planned for February 1, 2019. See more details in Fred Descamps' blog. We are really looking to meeting you at this biggest OS show in Europe! ​SunShine PHP, Miami, FL, US, February 7-9, 2019 MySQL Community team is going to be Bronze sponsor of this show with a MySQL table, MySQL tutorial and session given by David Stokes, the MySQL Community Manager & Kathy Forthe, the Solutions Architect for MySQL. Please do not miss the opportunity to talk to Dave & Kathy, attend the tutorial and sessions as follows: Tutorial: "The MySQL Document Store", scheduled for Feb 7th, 2019 @9:00-12:00 (Dave Stokes) Session: "The MySQL Document Store", scheduled for Feb 8th, 2019 @16:00-17:00 (Dave Stokes) Session: "Driving Innovation with MySQL 8.0 and Docker" scheduled for Feb 9th, 2019 @11:30-12:30 (Kathy Forte) We are looking forward to meeting you at SunShine PHP! PHP UK, London, UK, February 20-22, 2019 MySQL Community team took the opportunity to become a Silver sponsor here. This time we have no booth but a talk on "Hybrid Databases - How De-normalizing Your Data with JSON Can Boost Query Performance" given by David Stokes, the MySQL Community Manager. Please do not miss Dave's talk @PHP UK! PyCon Philippines, Makati, PH, February 23-24, 2019 MySQL is a Gold sponsor of this show with a MySQL booth & session allocated to us. You can find our booth in the expo area, please meet there MySQL staff & our local Partner IT Group there to discuss MySQL related topics. You can also find a MySQL talk on "NoSQL+SQL=MySQL" in the schedule. Talk is given by Ronen Baram, the MySQL Principal Solution Consultant.  March 2019: Southern California Linux Expo 2019 (ScaLE), Pasadena, US, March 7-10, 2019 As a tradition we are again part of ScaLE 2019 as Gold sponsor with booth & MySQL talks. Please stop by at our MySQL booth and do not miss the MySQL talks which all are scheduled for March 8th, Room 101. You can find there multiple presenters, from MySQL/Oracle team, you can find following presentations: "MySQL Document Store - A NoSQL JSON Document Database" given by David Stokes, the MySQL Community Manager. His talk is scheduled for Mar 8th, 2019 @10:00-11:30 "MySQL Security - Avoid Getting on the Front Page!" given by Michael Marx, the MySQL Senior Sales Consultant. His talk is scheduled for Mar 8th, 2019 @16:30-17:30. FOSSASIA, Singapore, March 14-17, 2019 MySQL Community with an APAC MySQL team are going to become a Bronze sponsor of this OS show in Singapore. We are going to have a MySQL booth at this show as well as several talks in the MySQL dedicated track. The schedule is not yet done, but in general there are already 9 MySQL related talks accepted and much more will come. Please watch organizers' website as well as further more details announcement about our involvement in FOSSASIA. Further events will come up later on.

We continue with announcing the upcoming shows & conferences where you can find MySQL Community or MySQL Experts at. Please find the list of events with details below.  February 2019: FOSDEM 2019,...

Announcements

MySQL Enterprise Monitor 8.0.14 has been released

The MySQL Enterprise Tools Development Team is pleased to announce the maintenance release of MySQL Enterprise Monitor 8.0.14 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. If you are not familiar with MySQL Enterprise Monitor, it is the best-in-class tool for monitoring and management of your MySQL assets and is part of MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition subscriptions. You are invited to give it a try using our 30-day free customer trial. Go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Highlights Redesigned Query Analyzer The user interface of the Query Analyzer has been redesigned, improving navigation and introducing advanced configuration options. It is now possible to customize the Query Analyzer graph and data visualization, sorting and filtering by clicking on Configure View button. When you click on a SQL statement, the Statement Details page now lets you browse all example statements in the specified time range (rather than just being shown the one with the worst run time). Drill into any of these examples to see their individual statistics, literals used, and EXPLAIN plan. Scrolling down the page, graphs show you the execution pattern of the selected query during the specified time period.  MySQL Enterprise Monitor collects non-normalized examples of statement executions each minute when collecting aggregate statement statistics. You can visualize the latency of these Examples over the specified time period in the new Statement Distribution Chart. Each point on the chart represents a specific example statement execution time. Statements with an associated EXPLAIN plan are represented by a circle in the Distribution Chart. Points which are a square had no EXPLAIN plan captured for them. The red circle or square is the SQL statement that had the longest execution time for the specified period. Clicking on a Statement Example within the Distribution Chart shows its query text in the original form, some additional execution context information, and its EXPLAIN plan.     Deleting Assets from the Inventory The MySQL Enterprise Monitor Inventory user interface got a new functionality to remove assets. Now you can select and delete one or multiple entries for clusters, topologies, agents, hosts, and instances which were monitored, but are no longer in use. Note deleting assets only removes them from the inventory, and it does not remove or uninstall assets from their installed locations.  New Views for Agents and Hosts You can now examine the configuration and current status of Agents and Hosts in great detail. The Agents view shows the MySQL Enterprise Monitor Agents currently registered with the MySQL Enterprise Service Manager. On a single screen, you see relevant information about the health of multiple agents, their versions, the number of assets monitored by each agent, last contact time, MySQL instances uptimes, versions, and data dir. You can go further and check more details of a specific agent by selecting its More Info button. The Agent details view displays JVM configuration and status, details on all MySQL connections, processes, instances, and detailed information on the host's operating system. The Hosts view shows all currently monitored hosts and their configuration. The Hosts view allows you to quickly inspect different hosts hardware configurations, their Operating Systems, number of filesystems, and number of monitored MySQL instances. To drill-down and see more details of a host, select its corresponding More Info button. In the Host detail view, you see all the filesystems, the MySQL instances, and greater detail of the hardware configuration such as RAM, CPUs, and network interfaces. Additional NDB Clusters Views The new NDB Clusters configuration view complements the NDB Cluster monitoring with the visualization of all currently monitored clusters, their membership, and configurations. The top-level list summarizes the NDB Cluster topology by displaying the number of Management, API and Data Nodes with their number of replicas. It also shows if the cluster is running on diskless mode. To inspect the status and configuration details of the NDB Cluster nodes, select the More Info button. Memory Usage The Global Memory Usage report builds upon the Memory instrumentation exposed within Performance Schema to provide greater insight into where memory is being allocated within the MySQL Instance - not just at the InnoDB Buffer Pool level, but for all memory allocations, across all connections and threads within MySQL. The report breaks down memory by allocation types, such as memory allocated for sorting, the buffer pool, or various other internal buffers used for statement processing. MySQL Server 8 MySQL Enterprise Monitor 8.0 supports monitoring MySQL Server 8.0.11+, so you can monitor MySQL Server from version 5.5 onwards. MySQL Enterprise Monitor 8.0 also has MySQL Server 8.0 as its bundled repository or you can also use MySQL Server 8.0 as an external data repository.  Download To download MySQL Enterprise Monitor, go to My Oracle Support, choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon. Type "MySQL Enterprise Monitor 8.0.14" in the search box. More info and feedback You can find more on the "What's New" section of the manual and more information on the contents of the 8.0.14 maintenance release in the changelog. Please open a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. Thanks and Happy Monitoring! Useful links What's New in 8.0 Changelog Installation documentation Product information Frequently Asked Questions

The MySQL Enterprise Tools Development Team is pleased to announce the maintenance release of MySQL Enterprise Monitor 8.0.14 is now available for download on the My Oracle Support (MOS) web site. It...

Announcements

Where you can find MySQL in January 2019!

We would like to continue with announcing the shows where you can find & meet MySQL Community members or MySQL experts. Please find the list below (this time only for January 2019). Further events will come up later on. Oracle OpenWorld UK/EMEA, London, UK, Jan 16-17, 2019 MySQL team is going to be part of this Oracle show in London. You can visit Oracle/MySQL booth in the Zone 2-O and you can attend a talk given by Mark Swarbrick, the MySQL Principle Presales Consultant as follows: MySQL 8.0: Top 10 Features for DBAs and Developers scheduled for Wed, Jan 16, 2019, 15:10-15:55, @Arena 6 (level 3) - ExCeL London We are really looking forward to talking to you there! MySQL Innovation Day, Stockholm, Sweden, Jan 23, 2019 If you are local, do not miss this one-day Innovation MySQL Day which main topic is: MySQL supports SQL & NoSQL! At this Innovation event you can experience first-hand how innovations, such as MySQL Document Store, InnoDB Cluster or Replication enable businesses to reach new levels of agility while embracing a database platform that delivers industry leading performance, reliability, and scalability... Since it is "invitation" only event and space is limited, please register as soon as possible! Whole agenda is available here. PHP Benelux, Edegem, Belgium, Antwerp, Jan 25-26, 2019 This year a MySQL talk was approved and will be presented by Dave Stokes, the MySQL Community Manager. His talk is on "PHP, The X Devapi, and the MySQL Document Store". Dave's talk is scheduled for Friday, Jan 25th @17:10-18:10 in Track B. Do not miss the opportunity to listen Dave's talk @PHP Benelux! OpenSource Conference Osaka, Japan, jan 25-26, 2019 as tradition MySQL is a Gold sponsor with a booth and MySQL talk. Do not miss the opportunity to discuss news about MySQL at our booth in the expo area and please check the organizer's website for the MySQL talk!  

We would like to continue with announcing the shows where you can find & meet MySQL Community members or MySQL experts. Please find the list below (this time only for January 2019). Further events...

Announcements

Nov 5 -> Busy week for MySQL: where you can find us now?

as announced in the blog posted on Oct 18, 2018 we would like to just remind you about places and shows where you can find us this really busy week... We are ready for following shows: PerconaLive in Frankfurt, Germany on November 5-7, 2018 as previously announced there are plenty of our MySQL experts, our friends from sales & Fred Descamps representing MySQL community at PerconaLive, Frankfurt which started today. Right now Fred Descamps & Kenny Grip are having a tutorial on "MySQL InnoDB Cluster in a Nutshell : The Saga Continues with 8.0" which ends before noon. Also there are plenty of MySQL talks (you can check them either on the previous blog post or directly at PerconaLive website). From today's noon the expo is also open. MySQL is having a new designed booth there with our staff. Come to talk to us! We are looking forward to meeting you there! PHP.RUHR, Dortmund, Germany on November 8, 2018 Next show where you can find us is PHP.RUHR. This is the third time we are supporting this one-day show and same as last year we are having a MySQL talk (in Mainstage: Developer on "MySQL 8.0 - The new Developer API") & Q&A session in the expo area where you can come to ask our MySQL speaker, Mario Beck MySQL related questions.  Come to listen the news in MySQL 8.0 & talk to Mario at PHP.RUHR! ​​Highload++, Moscow, Russia on November 8-9, 2018 We are really excited about being part of this big technology show in Russia. Last week we finally got a notification about that our MySQL talk was accepted so, you can find that talk in the conference schedule as follows: "MySQL 8.0: SQL and NoSQL Scalability" given by Vittorio Cioe. Talk is scheduled for Nov 8th @14:00 Do not forget to stop by at our MySQL booth in the expo area. We are planning to have quiz for a MySQL prizes as well as InnoDB Cluster demo given by Vittorio on the first day and quiz followed by MEM demo given by Vittorio on the second day at our booth. Check the organizers' website & schedule for further updates & for sure come to our booth and MySQL session to get the latest MySQL updates and news. We are looking forward to talking to you at Highload++!!        

as announced in the blog posted on Oct 18, 2018 we would like to just remind you about places and shows where you can find us this really busy week... We are ready for following shows: PerconaLive in F...

Where you can find MySQL in October - December 2018 - part 2.

As a continue of the previous blog announcement posted on Oct 16, please find below a list of conferences & events where you can find MySQL team &/or MySQL Community during the period of Oct-Dec 2018: November 2018 - cont. PerconaLive, Frankfrurt Germany, November 5-7, 2018 We are happy to inform that MySQL is going to be Silver sponsor of PerconaLive Europe 2018! You will be able to find us on the MySQL booth in the expo hall as well as attend multiple MySQL talks given by our colleagues. The talks are scheduled as follows: Tutorial on: "MySQL InnoDB Cluster in a Nutshell : The Saga Continues with 8.0" by Frédéric Descamps, the MySQL Community Manager, scheduled for Monday, @9:00am-12:00pm. "MySQL 8.0 Performance: Scalability & Benchmarks" by Dimitri KRAVTCHUK, the Performance Architect, talk is scheduled for Tuesday @12:20-13:10. "MySQL Group Replication: the magic explained" by Frédéric Descamps, the MySQL Community Manager, scheduled for Tuesday @14:20-15:10. "Upgrading to MySQL 8.0 and a More Automated Experience" by Dmitry Lenev, the Senior Software Developer, scheduled for Tuesday @ 15:20-16:10. "More SQL in MySQL 8.0" by Norvald Ryeng, the Senior Developer Manager - Optimizer Team, scheduled for Tuesday 17:25-17:50. "The Latest MySQL Replication Features" by Jorge Tiago, the Senior Software Developer, scheduled for Wednesday @14:20-15:10. "Developing Applications with Node.js and the MySQL Document Store" by Johannes Schlüter, the Principal Software Developer, scheduled for Wednesday @17:00-17:25. Come to listen MySQL sessions & stop at our booth to talk to our staff at PerconaLive 2018! PHP.RUHR, Dortmund, Germany, November 8, 2018 MySQL team is going to be part of this technical/PHP show. You can come to listen a MySQL talk in the Mainstage: Developer as: "MySQL 8.0 - The new Developer API" given by Mario Beck, the MySQL Sales Consulting Manger for EMEA. There also will be a Q&A session in the expo area about MySQL, where you can come to ask questions. Highload++, Moscow, Russia, November 8-9, 2018 MySQL team is going to be part of this technical conference in Moscow. You can find us on our MySQL booth in the expo area as well as you should be able to find MySQL talk in the schedule (still not heard about its acceptance). We are looking forward to talking to you @ Highload++ this year!!! SeaGL, Seattle, US, November 9-10, 2018 MySQL community team supports this GNU/Linux conference in Seattle.  PHP[World], Washington DC, US, November 14-15, 2018  MySQL is a Workshop sponsor this year. Unfortunately no talk this year, but we are in the waiting list for lightening talk. Please watch the organizers' website. BGOUG, Pravets, Bulgaria, November 14-15, 2018 As a tradition MySQL is a conference sponsor of this Bulgarian Oracle User Group regular conference. This time with a following talk: "Data Masking in MySQL Enterprise 5.7 and 8" given by Georgi Kodinov, the Senior Software Developer Manager for MySQL.  Please come to listen Georgi's talk as well as ask him questions. DOAG, Nuremberg, Germany, November 20-23, 2018 Same as in previous years we are going to be part of this conference organized by German Oracle User Group. You can find MySQL staff at the Oracle booth (Place 320) as well as attend several MySQL talks. You can find the talks here. Feira do Conhecimento, Fortaleza, Brazil, November 21-24, 2018 The Science, Technology and Higher Education Secretariat (Secitece) will hold the second edition of the Knowledge Fair - Science, Technology, Innovation and Business at the Ceará Event Center (East Pavilion) and we are happy to be part of this event!! A Local MySQL Sales representative will be there to answer all MySQL related questions as well as a MySQL talk on "Innovation, Business & Technology" is approved. Please watch the organizers' website for further updates. PyCon HK, Hong Kong, November 23-24, 2018 MySQL is a Bronze sponsor of this Python show and again this year without booth, but with a MySQL talk on "NoSQL Development for MySQL Document Store using Python" by Ivan Ma, the MySQL Principal Sales Consultant. December 2018 Tech18, UKOUG, Liverpool, UK, December 3-5, 2018 As a tradition MySQL will be part of this Oracle User Group Conference in the UK. You will be able to find our staff at the Oracle booth in the expo area. IT.Tage 2018, Frankfurt, Germany, December 10-13, 2018 Our pleasure to announce that this year MySQL is again part of the IT.Tage event. This time together with Oracle Developer & Linux team. You will have an opportunity to find us all at the shared Oracle booth as well as attend several Oracle's talks.  For MySQL do not miss the opportunity to listen what is new in MySQL 8 during following session: "MySQL 8 - MySQL as a Document Store Database" given by Carsten Thalheimer, the MySQL Principal Sales Consultant, scheduled for December 12, 2018 @ 14:30-15:15 in the Database track.  We are looking forward to talking to you there! OpenSource Conference Fukuoka, Fukuoka, Japan (December 8, 2018) MySQL is Gold sponsor here. You will be able to find us at MySQL booth in expo area as well as find a MySQL talk on "State of Dolphin" given by Yoshiaki Yamasaki, the MySQL Senior Sales Consultant Asia Pacific and Japan region, during the talk general product updates will be covered. OpenSource Enterprise, Tokyo, Japan, (December 14, 2018) Again, MySQL is a Gold sponsor with MySQL booth & talk on the same topic: "State of Dolphin" by Yoshiaki Yamasaki.  We will continue updating you about upcoming events & conferences where you can find MySQL team at.       

As a continue of the previous blog announcement posted on Oct 16, please find below a list of conferences & events where you can find MySQL team &/or MySQL Community during the period of Oct-Dec 2018: N...

Announcements

MySQL Enterprise Monitor 8.0.3 has been released

The MySQL Enterprise Tools Development Team is pleased to announce the maintenance release of MySQL Enterprise Monitor 8.0.3 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. If you are not familiar with MySQL Enterprise Monitor, it is the best-in-class tool for monitoring and management of your MySQL assets and is part of MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition subscriptions. You are invited to give it a try using our 30-day free customer trial. Go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. To download MySQL Enterprise Monitor, go to My Oracle Support, choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon. Type "MySQL Enterprise Monitor 8.0.3" in the search box. You can find the highlights of MySQL Enterprise Monitor 8.0 on the "What's New" section of the manual and more information on the contents of the 8.0.3 maintenance release in the change log. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. Thanks and Happy Monitoring! Useful links What's New in 8.0 Change log Installation documentation Product information Frequently Asked Questions

The MySQL Enterprise Tools Development Team is pleased to announce the maintenance release of MySQL Enterprise Monitor 8.0.3 is now available for download on the My Oracle Support (MOS) web site. It...

Where you can find MySQL in October - December 2018 - part 1.

We would like to announce the shows & conferences where you can find MySQL Community Team or MySQL representatives at. Please be aware that the list below could be subject of change. October 2018 GITEX, Dubai, United Arab Emirates, October 14-18, 2018 Same as last year Oracle & MySQL are part of GITEX converence. There is an Oracle booth (Stand A5-01, Hall 5) as well as MySQL one (POD2, Hall 5) where you can find us.  ZendCon, Las Vegas, US, October 15-17, 2018 We are Exhibitor sponsor same as last year, however newly this year we are going to have a new very cool booth design! Come to check and talk to us there! Also if you are around, do not miss the sessions by David Stokes, The MySQL Community Manager as follows:  "MySQL without the SQL -- Oh my!" scheduled for today @11:30-12:30pm "MySQL 8 performance tuning" scheduled for tomorrow, Oct 17 @4:00-5:00pm We are looking forward to seeing and talking to you at ZendCon! JCConf, Taipei, Taiwan, October 19, 2018 Same as last year we are again supporting Java Community Conference (JCConf) in Taiwan. This year you can find our staff at Oracle/MySQL booth in expo area and listen following MySQL & Oracle talks: "How MySQL support NoSQL with Java applications" by Ivan Tu, the Principal Sales consultant, MySQL APAC. "GraalVM (polyglot environment supports Oracle, MySQL and Java)" given by Yudi Zheng, Senior researcher at Oracle Lab organization. We are looking forward to talking to you there! Oracle Open World & MySQL Community Reception, San Francisco, October 22-25, 2018 MySQL is again part of the OOW show, please check the website for a MySQL talks in the agenda. And same as last year MySQL Community organizes a MySQL Reception. It is an evening event organized by MySQL Community on October 23rd at Samovar Tea Lounge at 730 Howard St., San Francisco, CA from 7-9 pm.  Join the MySQL team at the MySQL Reception to celebrate the dynamics and growth of the MySQL community! Forum PHP, Paris, France, October 25-26, 2018 We are a Bronze sponsor of Forum PHP this year with an approved talk on: "MySQL 8.0: What's new". Please check the organizers' website for further details JSFoo, Bangalore, India October 26-27, 2018 This is the first time we are attending this JavaScript conference, this year we are having just a talk there. The talk is scheduled for Sat, Oct 27, 2018 @13:40-14:10 with the topic of: "MySQL 8 loves JavaScript". The speaker is Sanjay Manwani, Developer Evangelism at Oracle. November 2018 Madison PHP, Madison, US, November 2-3, 2018 MySQL Community Team is a Community Sponsor of Madison PHP conference this year again. MOPCON 2018, Taipei, Taiwan, November 3-4, 2018 This year for the first time we are going to have a talk at MOPCON 2018. Please do not miss the opportunity to listen the talk given by Ivan Tu, the MySQL Principal Consultant Manager as follows: "The mobile application supported by new generation MySQL 8.0" scheduled for Nov 4, @11:05-11:45am in BigData track. ​​We are looking forward to meeting & talking to you there! ..More shows to be announced soon....

We would like to announce the shows & conferences where you can find MySQL Community Team or MySQL representatives at. Please be aware that the list below could be subject of change. October 2018 GITEX,...

MySQL Enterprise

MySQL Enterprise Monitor 8.0.1 has been released

We are pleased to announce that MySQL Enterprise Monitor 8.0.1 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Enterprise Carrier Grade subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 8.0 include: MySQL Enterprise Monitor 8.0 supports monitoring MySQL Server 8.0.11 and later. You can also use MySQL Server 8.0 as an external data repository for MySQL Enterprise Monitor 8.0. Significant improvements have been made to the performance and user interface of the Query Analyzer. When you click on a SQL statement, the new Statement Details page enables you to browse all example statements in the specified time range, rather than just the one with the worst run time. Drill into any of these examples to see their individual statistics, literals used, and EXPLAIN plan. Graphs display the execution pattern of the selected query during the specified time period. For more information, see Section 30.3.1, "Detailed Query Information". The new Global Memory Usage report builds upon the Memory instrumentation exposed within Performance Schema to provide greater insight into where memory is being allocated within the MySQL Instance - not just at the InnoDB Buffer Pool level, but for all memory allocations, across all connections and threads within MySQL. The report breaks down memory by allocation type, such as memory allocated for sorting, the buffer pool, or various other internal buffers used for statement processing. For more information, see Section 28.6, "Memory Usage Report". You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon.  Type "MySQL Enterprise Monitor 8.0.1" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 8.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 8.0.1 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software...

MySQL Enterprise

MySQL Enterprise Monitor 4.0.5 has been released

We are pleased to announce that MySQL Enterprise Monitor 4.0.5 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 8.0 offers many significant improvements over MEM 3.4 and 4.0 and we highly recommend that you consider upgrading. More information on MEM 8.0 is available here: What's new in MySQL Enterprise Monitor 8.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 4.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 4.0.5 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.4.8 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.4.8 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 8.0 offers many significant improvements over MEM 3.4 and 4.0 and we highly recommend that you consider upgrading. More information on MEM 8.0 is available here: What's new in MySQL Enterprise Monitor 8.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.4 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.4.8 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

Where you can find MySQL in June

As follow up to the previous message posted on June 4, 2018 please find below the shows where you can find MySQL during June this year: DataOps in June 21-22, 2018 in Barcelona, Spain ​MySQL is a Community sponsor of this event where our colleague Fred Descamps, the MySQL Community Manager is having following talk: "MySQL 8.0 Document Store: NoSQL with all the benefits of a RDBMS", scheduled for Jun 21, 2018 @​12:20pm ​​There are also other talks on MySQL which I would really recommend you to attend: ​"A quick tour of MySQL 8.0 roles" by Giuseppe Maxia, scheduled for June 21@11:00 "MySQL High Availability at GitHub" by Shlomi Noach, scheduled for June 21@14:50 "MySQL Group Replication - Ready For Production?" by Kenny Gryp, scheduled for June 21@16:50 "dbdeployer: the future of MySQL sandboxes" by Giusepe Maxia, scheduled for June 22@11:00 ...and much more, see the full schedule here. Hong Kong Open Source Conference, June 16-17, 2018, Hong Kong ​See details in Fred Descamps' blog OpenSource Developer Conference Okinawa, Japan, June 16, 2018, Okinawa, Japan MySQL team is a Gold sponsor of this OS conference with a following MySQL talk given by Yoshiaki Yamasaki, the MySQL Senior Sales Consultant, Asia Pacific & Japan: What's new in MySQL 8.0 PyCon Thailand, Bangkok, June 16-17, 2018, Bangkok, Thailand We are currently Silver sponsor of this PyCon with an approved talk by Ronen Baram, the MySQL Principle Sales Consultant as follows:  "​Build dynamically scaled highly available python application with MySQL", scheduled for Jun 16, 2018 @11:55am. Please find Ronen there for any kind of MySQL discussion. Ronen is always happy to help!  

As follow up to the previous message posted on June 4, 2018 please find below the shows where you can find MySQL during June this year: DataOps in June 21-22, 2018 in Barcelona, Spain ​MySQL is a...

Busy week for MySQL - where you can find us!

This week is going to be a bit busy for MySQL team. We are going to be present at four conferences in Europe and two in the US. Please find them below: ​International PHP Conference, Berlin Germany, June 4-8, 2018 This time we are going to have a booth on the Bronze level in the expo area. The exhibition is only on Jun 5-6, 2018. You can find our colleague Mario Beck, the MySQL Sales Consulting Manager for EMEA at the stand. Come to our MySQL booth!! OpenExpo Europe, Madrid, Spain, June 6-7, 2018 Do not miss to come to the biggest OS show in Madrid! MySQL and Linux team will be there at the shared MySQL&Linux booth in the expo area. Also you can find our talks as follows in the schedule: "The Revolutionary MySQL 8.0" by Abel Florez, the MySQL Technical Account Manager. His talk is scheduled for June 6, 2018 @16:05-16:35. "Operating on your Choice of Hardware, in your Data Center or in the Cloud" by Simon Coter, the Director of Product Management, Oracle VM & VirtualBox. "Oracle Cloud Infrastructure for Cloud Native Applications" by Vittorio Garbuglio, the Cloud Solutions Architect. Come to talk to our experts, we are looking forward to meeting you there! Bulgarian Oracle User Group Conference (BGOUG), Borovets, Bulgaria, June 8-10, 2018 As a tradition we are supporting and actively attending this User Group event organized by the local Oracle User Group. Please do not miss the MySQL talk given by Georgi Kodinov, the MySQL Senior SW Development Manager as follows: "The New Data Dictionary in MySQL 8.0: what does it mean to you?" June 9, 2018 @14:30-15:15 in the Hall Rila 1.  ​DevTalks Bucharest, Romania, June 8, 2018 We got to this show on the last minute! You can find our MySQL staff at MySQL booth in the exhibition area as well as find the MySQL talk given by Vittorio Cioe, the Sr. Sales Consultant, Oracle, MySQL: "Better DevOps with MySQL 8.0", scheduled for June 8, 2018 @14:05-14:50 in the DevOps track We are looking forward to meeting & talking to you there! SyntaxCon, Charlestown, SC, US, June 6-8, 2018 We are attending and speaking at the SyntaxCon conference this year. You can find the MySQL talk in the schedule as follows: "MySQL 8 -- A New Beginning" given by Dave Stokes, the MySQL Community Manager. The talk is scheduled for June 7, 2018 @11:15-12:15pm. Come to listen the MySQL 8.0 news and discuss your questions with Dave @SyntaxCon! Southeast Linux Fest (SELF), Charlotte, US, June 8-10, 2018 As tradition we are going to attend SELF! This year we become Diamond sponsor and you will be able to find us at MySQL booth in the expo hall as well as find following MySQL talks in the two day Zero to DBA Hero track: "20 Years of MySQL, 20 Years of PHP, and 10 Years of SELF - What the heck has been going on?" given by Dave Stokes, the MySQL Community Manager. The talk is scheduled for June 8, 2018 @ 9:00-10:00am. "MySQL Without the SQL - Oh My!" by Dave Stokes, talk is scheduled for June 8 @1:30-2:30 pm. The next shows in June we are attending are: DataOps in June 21-22, 2018 in Barcelona,Spain, Hong Kong Open Source Conference, June 16-17, 2018, OpenSource Conference Okinawa, Japan, June 16, 2018, PyCon Thailand, Bankok, June 16-17, 2018.

This week is going to be a bit busy for MySQL team. We are going to be present at four conferences in Europe and two in the US. Please find them below: ​International PHP Conference, Berlin Germany,...

Announcements

MySQL Cluster 7.6 is now Generally Available

      Bernd Ocklin | MySQL Cluster Engineering Director It gives us great pleasure to announce that the 7.6 release of MySQL Cluster is GA and now ready for prime time.  MySQL Cluster is a distributed database combining linear scalability and high availability. An ultra-high speed database, MySQL Cluster provides in-memory real-time access with transactional consistency across partitioned and distributed data sets designed for highly available mission critical applications. MySQL Cluster’s shared nothing architecture delivers an incredible 99.9999% availability and is used within the core of systems that serve billions of mobile phone users, leading online-games and high demand web services.  This new MySQL Cluster 7.6 version is all about supporting and optimizing performance on the latest off the shelf hardware, increasing its ability to both scale up on ever performant hardware and scale out within and across data centers, while at the same time increasing ease of use and lowering maintenance overhead. MySQL Cluster 7.6 now enables databases sizes beyond tens of Terabytes on modern hardware and with awareness and optimization for cloud infrastructures.  MySQL Cluster’s disk recovery system has undergone a complete redesign, dramatically improving restart and recovery times by up to 4x. A host of algorithms in version 7.6 have greatly improved concurrency and load balancing making optimized use of all hardware resources available. New and improved parallel query processing runs distributed cross-shard (partitioned) joins often doubling performance.  To make it simpler to move data into the MySQL Cluster we have added a new import tool, designed to load massive data files in cluster at maximum parallel speed, increases your ability to blast data into your MySQL Cluster Databases. New inter node connectors move traffic between co-located nodes from the network stack to faster shared memory, significantly improving performance by lowering latency. Availability domains now make cluster cloud infrastructure topology aware allowing for seamless optimal query routing. To learn more about the features added please check  https://mysqlhighavailability.com/mysql-cluster-7-6-is-ga  Download Now >>  https://dev.mysql.com/downloads/cluster/ 

      Bernd Ocklin | MySQL Cluster Engineering Director It gives us great pleasure to announce that the 7.6 release of MySQL Cluster is GA and now ready for prime time.  MySQL Cluster is a distributed...

MySQL Enterprise

MySQL Enterprise Monitor 4.0.4 has been released

We are pleased to announce that MySQL Enterprise Monitor 4.0.4 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 8.0 offers many significant improvements over MEM 3.3, 3.4, and 4.0 and we highly recommend that you consider upgrading. More information on MEM 8.0 is available here: What's new in MySQL Enterprise Monitor 8.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 4.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 4.0.4 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.4.7 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.4.7 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 8.0 offers many significant improvements over MEM 3.3, 3.4, and 4.0 and we highly recommend that you consider upgrading. More information on MEM 8.0 is available here: What's new in MySQL Enterprise Monitor 8.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.4 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.4.7 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.3.9 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.3.9 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 8.0 offers many significant improvements over MEM 3.3, 3.4, and 4.0 and we highly recommend that you consider upgrading. More information on MEM 8.0 is available here: What's new in MySQL Enterprise Monitor 8.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.3 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.3.9 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

List of Conferences & Events w/ MySQL, April - June 2018! - continued

As an update to the blog posted on April 4, 2018 we would like to update the list of events where you can find MySQL. Please see the four new conferences below:  DevTalks, Cluj-Napoca, Romania, May 16, 2018 MySQL became a customized sponsor of this show. We will have  MySQL keynote given by Georgi Kodinov, the MySQL Senior SW Development Manager. We are still working on the topic, please watch the organizers’ website for further updates.  SyntaxCon,  Charleston, SC, US, June 6-8, 2018   MySQL Community team is going to be Bronze sponsor of SyntaxCon conference. This time we are going without booth, but with already approved MySQL talk. Please find the talk in the schedule, David Stokes, the MySQL Community Manager will be talking about “MySQL 8 - A New Beginning”. Talk is scheduled for Thursday, June 7 @1:15pm   PyCon Thailand, Bangkok, Thailand, June 16-17, 2018  MySQL is going to support & attend this conference. This time we are going without booth, but with "on site" staffing by Ronen Baram, the Principal Sales Consultant. Ronen also submitted a MySQL talk and we hope it will be approved. Please watch organizers website for further updates.   DataOps Barcelona, Spain, June 21-22, 2018 We are happy to announce that MySQL Community team is going to be Community sponsor of DataOps Barcelona. The MySQL Community Manager, Fred Descamps will be talking about MySQL 8.0, Cluster & Document store. Please do not miss his and others' well known MySQL speakers's talks which will be announced in the schedule section of the conference website. Please be aware that the list does not have to be final, during the time more events could be added or some of them removed. We will keep you informed!    

As an update to the blog posted on April 4, 2018 we would like to update the list of events where you can find MySQL. Please see the four new conferences below:  DevTalks, Cluj-Napoca, Romania, May...

MySQL Enterprise

Backup of External Tablespaces in MySQL 8.0

Introduction We can categorize the InnoDB tablespaces created by users, broadly in following categories. File-per-table Tablespace - A single, file-per-table tablespace created in the datadir, which contains only one table. General Tablespace   - A shared tablespace created in the datadir, which may contain multiple tables. External File-per-table Tablespace - A single, file-per-table tablespace created outside of the datadir, which contains only one table. External General Tablespace - A shared tablespace created outside of the datadir, which may contain multiple tables. External tablespaces are sometimes called remote tablespaces, but both refer to a single or shared, file-per-table tablespace outside of the datadir. Prior to MySQL 8.0, the server creates an InnoDB Symbolic Link (*.isl) file in the datadir to locate the external tablespaces. MEB copies the *.isl files as *.bl files into the backup for those MySQL server versions.  At the time of copy back, MEB copies the *.bl files to the target datadir as the *.isl files. It then copies the corresponding external tablespaces to the location pointed by the *.isl files. In MySQL 8.0, the use of *.isl files has been removed for InnoDB, as per WL#6416. This change raises the question: how would MEB find the external tablespaces and copy them back to their respective locations? This article attempts to answer these questions. tablespaces_tracker file MEB has introduced a new file in the backup named 'tablespaces_tracker'. It is a JSON file that is created only if at least one external tablespace is included in the backup. The file contains metadata about the backed-up external tablespaces.  The file contains an array named "tablespace_list", which contains a list of the external tablespace objects and the following properties for each external tablespace. "server_file_path" : External tablespace location at the sever "backup_file_path" :  External tablespace location in the backup "space_id”: A tablespace identifier. "Flags”:  As of now these are the possible flag values. GENERAL: If it is a shared tablespace. SINGLE: If it is a file-per-table tablespace. REMOTE: If it is an external tablespace. The file is present in the datadir of the backup. At the time of copy-back operation, it is copied to the server datadir. Backup of external tablespaces In MySQL 8.0, the only source of truth for tablespace information is the transactional data dictionary.  InnoDB keeps the metadata about all tablespaces in the data dictionary tables. Thanks to the new data dictionary, querying of the INFORMATION_SCHEMA has also improved tremendously. MEB queries the information schema to find out the information about all tablespaces to be backed up.  It then locates all tablespaces on the server and copies them to the backup. Now, how will MEB be able to copy back the external tablespaces to their respective target locations given that copy-back is an offline operation (except the TTS backups)?  Well, the answer is, with the help of 'tablespaces_tracker' file. The following is a discussion of a backup of external tablespaces. Start the MySQL server with an external directory explicitly specified with the --innodb_directories option. Refer to the server manual for information on this option.  mysqld.exe --no-defaults --datadir=D:\trunk_datadir  --console --innodb_directories='D:\rsisondi\80' Create the following two external tablespaces: mysql> CREATE TABLESPACE 80_rem_gen_ddl_ts1  ADD DATAFILE  'D:/rsisondi/80/80_rem_gents1.ibd'; Query OK, 0 rows affected (0.14 sec) mysql> CREATE TABLE 80_extern_table (c1 INT) ENGINE=InnoDB  DATA DIRECTORY = 'D:/rsisondi/80'; Query OK, 0 rows affected (0.11 sec) Take a simple directory backup: > mysqlbackup.exe -ubackup_user --backup-dir=D:\rsisondi\backup backup MySQL Enterprise Backup version 8.0.12-tr Windows-10.0.14393-AMD64 [2018-04-02  09:01:58] Copyright (c) 2003, 2018, Oracle and/or its affiliates. All Rights Reserved. A thread created with Id '38700' Starting with following command line ...  mysqlbackup.exe –ubackup_user --backup-dir=D:\rsisondi\backup backup   <snip>   -------------------------------------------------------------    Parameters Summary         -------------------------------------------------------------    Start LSN                  : 19189248    End LSN                    : 19189656 -------------------------------------------------------------   mysqlbackup completed OK! Navigate to the backup directory and notice the file 'tablespaces_tracker'. It has the metadata about the external tablespaces JSON format as shown below: {     "version": 1.0,     "HowTo": "Update server_file_path if and only if it is needed for each tablespace to restore an external tablespace to a different location; make sure correct database folder is given for each per-table tablespace.",     "tablespace_list": [         {             "server_file_path": "D:/rsisondi/80/80_rem_gents1.ibd",             "backup_file_path": "D:/rsisondi/backup/datadir/meb#8_80_rem_gents1.ibd",             "space_id": 8,             "Flags": [                 "GENERAL",                 "REMOTE"             ]         },         {             "server_file_path": "D:/rsisondi/80/test_80/80_extern_table.ibd",             "backup_file_path": "D:/rsisondi/backup/datadir/test_80/80_extern_table.ibd",             "space_id": 9,             "Flags": [                 "SINGLE",                 "REMOTE"             ]         }     ] Notice from above that the file name on the server is 80_remote_gents1.ibd but it has been renamed in the backup. InnoDB allows creation of shared tablespaces with the same name at different locations. This could cause conflicts during directory backups as MEB copies all shared tablespaces into the datadir inside backup. Therefore, a prefix meb#<space_id>_ is appended to the general tablespaces file names in the backup. Next, drop an existing external tablespace and create a new. mysql> DROP TABLE 80_extern_table; Query OK, 0 rows affected (0.17 sec)   mysql> CREATE TABLE 80_new_extern_table (c1 INT) ENGINE=InnoDB DATA DIRECTORY = 'D:/rsisondi/80'; Query OK, 0 rows affected (0.07 sec)   Take a simple incremental directory backup >  mysqlbackup.exe -ubackup_user backup --incremental --incremental-backup-dir=D:\rsisondi\incr --incremental-base=history:last_backup MySQL Enterprise Backup version 8.0.12-tr Windows-10.0.14393-AMD64 [2018-04-02  09:01:58] Copyright (c) 2003, 2018, Oracle and/or its affiliates. All Rights Reserved. A thread created with Id '36608' Starting with following command line ...  mysqlbackup.exe -ubackup  backup --incremental         --incremental-backup-dir=D:\rsisondi\incr         --incremental-base=history:last_backup               <snip>   -------------------------------------------------------------    Parameters Summary         -------------------------------------------------------------    Start LSN                  : 19189657    End LSN                    : 19218134 -------------------------------------------------------------              mysqlbackup completed OK!  Navigate to the datadir in the backup directory and notice the file 'tablespaces_tracker’.  Notice that the information about the dropped table is not present in the tracker file while the information about the newly added file is present. {     "version": 1.0,     "HowTo": "Update server_file_path if and only if it is needed for each tablespace to restore an external tablespace to a different         location; make sure correct database folder is given for each per-table tablespace.",     "tablespace_list": [         {             "server_file_path": "D:/rsisondi/80/80_rem_gents1.ibd",             "backup_file_path": "D:/rsisondi/incr/datadir/meb#8_80_rem_gents1.ibd",             "space_id": 8,             "Flags": [                 "GENERAL",                 "REMOTE"             ]         },         {             "server_file_path": "D:/rsisondi/80/test_80/80_new_extern_table.ibd",             "backup_file_path": "D:/rsisondi/incr/datadir/test_80/80_new_extern_table.ibd",             "space_id": 10,             "Flags": [                 "SINGLE",                 "REMOTE"             ]         }     ] } Copy-back of external tablespaces The copy-back operation of external tablespaces relies solely on the ‘tablespaces_tracker’ file.  As mentioned before, the ‘tablespaces_tracker’ file is copied into the target datadir as well. It helps MEB to resolve external tablespaces conflicts during the copy-back operation from the incremental backups into the target datadir. For instance, some external tablespaces could have been created/renamed/dropped after the previous backup and before the incremental backup. Therefore, you should never delete the 'tablesapces_tracker' file from either the backup or datadir after a copy-back operation. Let us perform a copy-back operation with the backups taken in the previous section. Stop the server and move/rename the previous external tablespaces directories in case they are still present. Restore the full backup: > mysqlbackup.exe -ubackup_user  --backup-dir=D:\rsisondi\backup copy-back-and-apply-log --datadir=D:\rsisondi\datadir MySQL Enterprise Backup version 8.0.12-tr Windows-10.0.14393-AMD64 [2018-04-02  09:01:58] Copyright (c) 2003, 2018, Oracle and/or its affiliates. All Rights Reserved. A thread created with Id '27600' Starting with following command line ... mysqlbackup.exe –ubackup_user --backup-dir=D:\rsisondi\backup          copy-back-and-apply-log --datadir=D:\rsisondi\datadir   <snip>   180402 20:52:32 MAIN    INFO: Apply-log operation completed successfully. 180402 20:52:32 MAIN    INFO: Full Backup has been restored successfully.   mysqlbackup completed OK! Notice the ‘tablespaces_tracker’ file in the target datadir. It has the same content as it does in the backup. {     "version": 1.0,     "HowTo": "Update server_file_path if and only if it is needed for each tablespace to restore an external tablespace to a different         location; make sure correct database folder is given for each per-table tablespace.",     "tablespace_list": [         {             "server_file_path": "D:/rsisondi/backup/datadir/meb#8_80_rem_gents1.ibd",             "backup_file_path": "D:/rsisondi/80/80_rem_gents1.ibd",             "space_id": 8,             "Flags": [                 "GENERAL",                 "REMOTE"             ]         },         {             "server_file_path": "D:/rsisondi/backup/datadir/test_80/80_extern_table.ibd",             "backup_file_path": "D:/rsisondi/80/test_80/80_extern_table.ibd",             "space_id": 9,             "Flags": [                 "SINGLE",                 "REMOTE"             ]         }     ] } Now, restore the incremental backup that was taken in the above step. > mysqlbackup.exe --defaults-file=D:\rsisondi\incr\backup-my.cnf -ubackup_user --backup-dir=D:\rsisondi\incr copy-back-and-apply-log --datadir=D:\rsisondi\datadir --incremental   MySQL Enterprise Backup version 8.0.12-tr Windows-10.0.14393-AMD64 [2018-04-02  09:01:58] Copyright (c) 2003, 2018, Oracle and/or its affiliates. All Rights Reserved.   A thread created with Id '33576' Starting with following command line ...  mysqlbackup.exe --defaults-file=D:\rsisondi\incr\backup-my.cnf –ubackup_user         --backup-dir=D:\rsisondi\incr copy-back-and-apply-log         --datadir=D:\rsisondi\datadir --incremental   <snip>   180402 20:52:37 MAIN    INFO: Apply-log operation completed successfully. 180402 20:52:37 MAIN    INFO: Incremental backup applied successfully.   mysqlbackup completed OK! Check the contents of the ‘tablespaces_tracker’ file in the datadir. In this case, it is the same as it was in the incremental backup.  But the contents could be an aggregation of the tracker files that is in the target datadir and tracker file that is in the backup directory. It really depends on what external tablespaces are included in the incremental backup. {     "version": 1.0,     "HowTo": "Update server_file_path if and only if it is needed for each tablespace to restore an external tablespace to a different         location; make sure correct database folder is given for each per-table tablespace.",     "tablespace_list": [         {             "server_file_path": "D:/rsisondi/incr/datadir/meb#8_80_rem_gents1.ibd",             "backup_file_path": "D:/rsisondi/80/80_rem_gents1.ibd",             "space_id": 8,             "Flags": [                 "GENERAL",                 "REMOTE"             ]         },         {             "server_file_path": "D:/rsisondi/incr/datadir/test_80/80_new_extern_table.ibd",             "backup_file_path": "D:/rsisondi/80/test_80/80_new_extern_table.ibd",             "space_id": 10,             "Flags": [                 "SINGLE",                 "REMOTE"             ]         }     ] } Copy-back of external tablespaces to non-default location There could be a situation in which you want to restore the external tablespace to some other location than its original location. For instance, you are restoring the backup to a new location or preparing a clone. In such cases, you would want to copy the external tablespaces to a different location. It is possible to achieve the same using the following steps. Modify the value of "server_file_path" property of the tablespace that you wish to change in the ‘tablespaces_tracker’ file in backup. Make sure that the proper directory hierarchy exists on the target server for the tablespace to be restored. Start server with the --innodb-directories option. Specify the directories pertaining to all external tablespaces to this option. For more information refer to the server manual. Conclusion With the previous versions of server, the external tablespaces metadata is scattered around the server datadir and also in the backup.  Restoring multiple external tablespaces to the non-default location is cumbersome as you have to modify the .isl files corresponding to the tablespaces. With 8.0 version, server keeps all tablespaces information in the transactional data dictionary and, MEB keeps all external tablespaces information in one metadata file. Also, it is easier to modify the restore location of the external tablespaces because it is at one place. We encourage you to give this a try and provide us feedback on how it works for your data. For more details, please see the MySQL Enterprise Backup Guide

Introduction We can categorize the InnoDB tablespaces created by users, broadly in following categories. File-per-table Tablespace - A single, file-per-table tablespace created in the datadir,...

MySQL Enterprise

MySQL Enterprise Monitor 8.0.0 GA has been released

We are very happy to announce the general availability of MySQL Enterprise Monitor, Version 8.0. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Enterprise Carrier Grade subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 8.0 include: MySQL Enterprise Monitor 8.0 supports monitoring MySQL Server 8.0.11 and later. You can also use MySQL Server 8.0 as an external data repository for MySQL Enterprise Monitor 8.0. Significant improvements have been made to the performance and user interface of the Query Analyzer. When you click on a SQL statement, the new Statement Details page enables you to browse all example statements in the specified time range, rather than just the one with the worst run time. Drill into any of these examples to see their individual statistics, literals used, and EXPLAIN plan. Graphs display the execution pattern of the selected query during the specified time period. For more information, see Section 30.3.1, "Detailed Query Information". The new Global Memory Usage report builds upon the Memory instrumentation exposed within Performance Schema to provide greater insight into where memory is being allocated within the MySQL Instance - not just at the InnoDB Buffer Pool level, but for all memory allocations, across all connections and threads within MySQL. The report breaks down memory by allocation type, such as memory allocated for sorting, the buffer pool, or various other internal buffers used for statement processing. For more information, see Section 28.6, "Memory Usage Report". You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon.  Type "MySQL Enterprise Monitor 8.0.0" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 8.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are very happy to announce the general availability of MySQL Enterprise Monitor, Version 8.0. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets...

MySQL

Announcing General Availability of MySQL 8.0

MySQL adds NoSQL and many new enhancements to the world’s most popular open source database: NoSQL Document Store gives developers the flexibility of developing traditional SQL relational applications and NoSQL, schema-free document database applications.  This eliminates the need for a separate NoSQL document database.  SQL Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes, Grouping, Regular Expressions, Character Sets, Cost Model, and Histograms. JSON Extended syntax, new functions, improved sorting, and partial updates. With JSON table functions you can use the SQL machinery for JSON data. GIS Geography support. Spatial Reference Systems (SRS), as well as SRS aware spatial datatypes,  spatial indexes,  and spatial functions. Reliability DDL statements have become atomic and crash safe, meta-data is stored in a single, transactional data dictionary  Observability Performance Schema, Information Schema, Invisible Indexes,  Error Logging. Manageability Persistent Configuration Variables, Undo tablespace management, Restart command, and New DDL. High Availability InnoDB Cluster delivers an integrated, native, HA solution for your databases. Security OpenSSL improvements, new default authentication, SQL Roles, breaking up the super privilege, password strength, authorization. Performance Up to 2x faster than MySQL 5.7. Developer Features MySQL 8.0 delivers many new features requested by developers in areas such as SQL, JSON and GIS. Developers also want to be able to store Emojis, thus UTF8MB4 is now the default character set in 8.0. NoSQL Document Store MySQL Document Store gives developers maximum flexibility developing traditional SQL relational applications and NoSQL, schema-free document database applications.  This eliminates the need for a separate NoSQL document database.  The MySQL Document Store provides multi-document transaction support and full ACID compliance for schema-less JSON documents. SQL Window Functions MySQL 8.0 delivers SQL window functions in MySQL.   Similar to grouped aggregate functions, window functions perform some calculation on a set of rows, e.g. COUNT or SUM. But where a grouped aggregate collapses this set of rows into a single row, a window function will perform the aggregation for each row in the result set. Window functions come in two flavors: SQL aggregate functions used as window functions and specialized window functions. Common Table Expression MySQL 8.0 delivers [Recursive] Common Table Expressions (CTEs) in MySQL.  Non-recursive CTEs can be explained as “improved derived tables” as it allow the derived table to be referenced more than once. A recursive CTE is a set of rows which is built iteratively: from an initial set of rows, a process derives new rows, which grow the set, and those new rows are fed into the process again, producing more rows, and so on, until the process produces no more rows. MySQL CTE and Window Functions in MySQL Workbench 8.0 NOWAIT and SKIP LOCKED MySQL 8.0 delivers NOWAIT and SKIP LOCKED alternatives in the SQL locking clause. Normally, when a row is locked due to an UPDATE or a SELECT ... FOR UPDATE, any other transaction will have to wait to access that locked row. In some use cases there is a need to either return immediately if a row is locked or ignore locked rows. A locking clause using NOWAIT will never wait to acquire a row lock. Instead, the query will fail with an error. A locking clause using SKIP LOCKED will never wait to acquire a row lock on the listed tables. Instead, the locked rows are skipped and not read at all. Descending Indexes MySQL 8.0 delivers support for indexes in descending order. Values in such an index are arranged in descending order, and we scan it forward. Before 8.0, when a user create a descending index, we created an ascending index and scanned it backwards. One benefit is that forward index scans are faster than backward index scans. GROUPING MySQL 8.0  delivers GROUPING(), SQL_FEATURE T433. The GROUPING() function distinguishes super-aggregate rows from regular grouped rows. GROUP BY extensions such as ROLLUP produce super-aggregate rows where the set of all values is represented by null. Using the GROUPING()function, you can distinguish a null representing the set of all values in a super-aggregate row from a NULL in a regular row. JSON MySQL 8.0 adds new JSON functions and improves performance for sorting and grouping JSON values. Extended Syntax for Ranges in JSON path expressions MySQL 8.0 extends the syntax for ranges in JSON path expressions. For example SELECT JSON_EXTRACT('[1, 2, 3, 4, 5]', '$[1 to 3]');results in [2, 3, 4]. The new syntax introduced is a subset of the SQL standard syntax, described in SQL:2016, 9.39 SQL/JSON path language: syntax and semantics. JSON Table Functions MySQL 8.0 adds JSON table functions which enables the use of the SQL machinery for JSON data. JSON_TABLE() creates a relational view of JSON  data. It maps the result of a JSON data evaluation into relational rows and columns. The user can query the result returned by the function as a regular relational table using SQL, e.g. join, project, and aggregate. JSON Aggregation Functions MySQL 8.0 adds the aggregation functions JSON_ARRAYAGG() to generate JSON arrays and JSON_OBJECTAGG() to generate JSON objects . This makes it possible to combine JSON documents in multiple rows into a JSON array or a JSON object. JSON Merge Functions The JSON_MERGE_PATCH() function implements the semantics of JavaScript (and other scripting languages) specified by RFC7396, i.e. it removes duplicates by precedence of the second document. For example, JSON_MERGE('{"a":1,"b":2 }','{"a":3,"c":4 }'); # returns {"a":3,"b":2,"c":4}. JSON Improved Sorting MySQL 8.0 gives better performance for sorting/grouping JSON values by using variable length sort keys. Preliminary benchmarks shows from 1.2 to 18 times improvement in sorting, depending on use case. JSON Partial Update MySQL 8.0 adds support for partial update for the JSON_REMOVE(), JSON_SET() and JSON_REPLACE() functions.  If only some parts of a JSON document are updated, we want to give information to the handler about what was changed, so that the storage engine and replication don’t need to write the full document. GIS MySQL 8.0 delivers geography support. This includes meta-data support for Spatial Reference System (SRS), as well as SRS aware spatial datatypes,  spatial indexes,  and spatial functions. Character Sets MySQL 8.0 makes UTF8MB4 the default character set. UTF8MB4 is the dominating character encoding for the web, and this move will make life easier for the vast majority of MySQL users. Cost Model Query Optimizer Takes Data Buffering into Account MySQL 8.0 chooses query plans based on knowledge about whether data resides in-memory or on-disk. This happens automatically, as seen from the end user there is no configuration involved. Historically, the MySQL cost model has assumed data to reside on spinning disks. The cost constants associated with looking up data in-memory and on-disk are now different, thus, the optimizer will choose more optimal access methods for the two cases, based on knowledge of the location of data. Optimizer Histograms MySQL 8.0 implements histogram statistics. With Histograms, the user can create statistics on the data distribution for a column in a table, typically done for non-indexed columns, which then will be used by the query optimizer in finding the optimal query plan. The primary use case for histogram statistics is for calculating the selectivity (filter effect) of predicates of the form “COLUMN operator CONSTANT”. Reliability Transactional Data Dictionary MySQL 8.0 increases reliability by ensuring atomic, crash safe DDL, with the transactional data dictionary. With this the user is guaranteed that any DDL statement will either be executed fully or not at all. This is particularly important in a replicated environment, otherwise there can be scenarios where masters and slaves (nodes) get out of sync, causing data-drift. Observability Information Schema (speed up) MySQL 8.0 reimplements Information Schema. In the new implementation the Information Schema tables are simple views on data dictionary tables stored in InnoDB. This is by far more efficient than the old implementation with up to 100 times speedup. Performance Schema (speed up) MySQL 8.0 speeds up performance schema queries by adding more than 100 indexes on performance schema tables.  Manageability INVISIBLE Indexes MySQL 8.0 adds the capability of toggling the visibility of an index (visible/invisible). An invisible index is not considered by the optimizer when it makes the query execution plan. However, the index is still maintained in the background so it is cheap to make it visible again. The purpose of this is for a DBA / DevOp to determine whether an index can be dropped or not. If you suspect an index of not being used you first make it invisible, then monitor query performance, and finally remove the index if no query slow down is experienced. High Availability MySQL InnoDB Cluster delivers an integrated, native, HA solution for your databases. It tightly integrates MySQL Server with Group Replication, MySQL Router, and MySQL Shell, so you don’t have to rely on external tools, scripts or other components. Security features OpenSSL by Default in Community Edition MySQL 8.0 is unifying on OpenSSL as the default TLS/SSL library for both MySQL Enterprise Edition and MySQL Community Edition.  SQL roles MySQL 8.0 implements SQL Roles. A role is a named collection of privileges. The purpose is to simplify the user access right management. One can grant roles to users, grant privileges to roles, create roles, drop roles, and decide what roles are applicable during a session. Performance MySQL 8.0 is up to 2x faster than MySQL 5.7.  MySQL 8.0 comes with better performance for Read/Write workloads, IO bound workloads, and high contention “hot spot” workloads. Scaling Read/Write Workloads MySQL 8.0 scales well on RW and heavy write workloads. On intensive RW workloads we observe better performance already from 4 concurrent users  and more than 2 times better performance on high loads comparing to MySQL 5.7. We can say that while 5.7 significantly improved scalability for Read Only workloads, 8.0 significantly improves scalability for Read/Write workloads.  The effect is that MySQL improves  hardware utilization (efficiency) for standard server side hardware (like systems with 2 CPU sockets). This improvement is due to re-designing how InnoDB writes to the REDO log. In contrast to the historical implementation where user threads were constantly fighting to log their data changes, in the new REDO log solution user threads are now lock-free, REDO writing and flushing is managed by dedicated background threads, and the whole REDO processing becomes event-driven.  Utilizing IO Capacity (Fast Storage) MySQL 8.0 allows users to use every storage device to its full power. For example, testing with Intel Optane flash devices we were able to deliver 1M Point-Select QPS in a fully IO-bound workload. Better Performance upon High Contention Loads (“hot rows”) MySQL 8.0 significantly improves the performance for high contention workloads. A high contention workload occurs when multiple transactions are waiting for a lock on the same row in a table,  causing queues of waiting transactions. Many real world workloads are not smooth over for example a day but might have bursts at certain hours. MySQL 8.0 deals much better with such bursts both in terms of transactions per second, mean latency, and 95th percentile latency. The benefit to the end user is better hardware utilization (efficiency) because the system needs less spare capacity and can thus run with a higher average load. MySQL 8.0 Enterprise Edition For mission critical applications, MySQL Enterprise Edition provides the following additional capabilities: MySQL Enterprise Backup for full, incremental and partial backups, Point-in-Time Recovery and backup compression. MySQL Enterprise High Availability for integrated, native, HA with InnoDB Cluster. MySQL Enterprise Transparent Data Encryption (TDE) for data-at-rest encryption. MySQL Enterprise Encryption for encryption, key generation, digital signatures and other cryptographic features. MySQL Enterprise Authentication for integration with existing security infrastructures including PAM and Windows Active Directory. MySQL Enterprise Firewall for real-time protection against database specific attacks, such as an SQL Injection. MySQL Enterprise Audit for adding policy-based auditing compliance to new and existing applications. MySQL Enterprise Monitor for managing your database infrastructure. Oracle Enterprise Manager for monitoring MySQL databases from existing OEM implementations. MySQL Cloud Service Oracle MySQL Cloud Service is built on MySQL Enterprise Edition and powered by Oracle Cloud, providing an enterprise-grade MySQL database service. It delivers the best in class management tools, self service provisioning, elastic scalability and multi-layer security. Resources MySQL Documentation MySQL Downloads

MySQL adds NoSQL and many new enhancements to the world’s most popular open source database: NoSQL Document Store gives developers the flexibility of developing traditional SQL relational...

Announcements

List of Conferences & Events w/ MySQL, April - June 2018!

We are happy to announce a list of events which we - MySQL &/or MySQL Community Team - are attending and speaking at during the period of time of April to June 2018. Please be aware that the list does not have to be final, during the time more events could be added or some of them removed.  April 2018: PHP Yorkshire, Yorkshire, UK, April 13-Workshop, April 14-Conference, 2018 Same as last year we are sponsoring and attending this conference as Silver sponsor. You can find us at MySQL booth in expo area. Darkmira PHP Tour, Brasilia/DF, April 14-15, 2018 Do not miss the Keynote given by Sheeri K. Cabral, who is the leader of MySQL Community.  Sheeri will be talking about "On being a Senior Engineer" and her talk is scheduled for April 14 @2:00-2:45 pm. You can then find Sheeri at our MySQL booth in the expo area to discuss the MySQL related topics. Longhorn PHP, Austin, TX, US, April 19-21, 2018 We are going to attend and speak at this pretty new show replacing Lonestar PHP and organized by Austin PHP Meetup group. Please do not miss the talk given by David Stokes, the MySQL Community Manager on "MySQL Without The SQL -- Oh My!", scheduled for Friday, April 20 @2:00-2:50pm. You can also find Dave at MySQL booth in the expo area. PyCon NOVE IT, Florence, Italy, April 19-22, 2018 As a tradition we are going to attend the PyCon IT. This year Marco Carlessi, the MySQL Principal Sales Consultant is going to have a talk on MySQL 8 ("MySQL 8: un database SQL/NoSQL semplice da usare"), scheduled for Friday, April 20 @12:30pm. LOADays, Antwerp, Belgium, April 21-22, 2018 This show is still in the process since we are waiting for confirmed speaker. Please stay turned or watch the website for more details. COLLABORATE18, Las Vegas, US, April 22-26, 2018 Our participation at this conference will be confirmed soon. Percona Live, Santa Clara, CA, US, April 23-25, 2018 MySQL is again attending and participating PerconaLive conference. This time there are multiple Oracle's MySQL talks as well as talks given by MySQL community members, partners & customers. See the full list of MySQL sessions here. Great Indian Developer Summit (GIDS), Bangalore, India, April 24-27, 2018 MySQL, same as other groups, is part of the central Oracle booth at GIDS. Oracle is Platinum sponsor this year and you would be able to find our staff at the booth or after the several Oracle's talks. For MySQL, the speaker is Sanjay Manwani, the MySQL Senior Director responsible for all the India MySQL development. Sanjay will be speaking on "MySQL 8.0 : The best gets even better" and his talk will be announced in the GIDS.DATA day, scheduled for April 26, 2018. Ruby Conference, Taipei, Taiwan, April 27-28, 2018 We are a Silver sponsor of this conference. This time unfortunately without a booth but with very active staff on site. Our colleague Ivan Tu, the Principal Sales Consultant for APAC will be representing MySQL. LinuxFest NorthWest, Bellingham, US, April 28-29, 2018 MySQL is a Gold sponsor of this conference. You can find our colleague David Stokes, the MySQL Community Manager at our MySQL booth in expo area as well as attend any of his approved MySQL talks as follows: "Database Programming Basics or Why Database Queries Stink!!!" scheduled for April 28 @3:30-4:15pm. "Presentation Skills for Open Source Folks" scheduled for April 29 @12:30-1:15pm. May 2018: RootConf, Bangalore, India, May 10-11, 2018 We are going to be a Bronze sponsor of RootConf this year. You can find our MySQL staff at the booth in expo area as well as listen the MySQL talk given by Bhupinder Singh on "Database monitoring for performance and availability". Please watch the schedule for the further updates. OpenSource Conference, Nagoya, Japan, May 19, 2018 As a tradition you can find us as Gold sponsor at the OSC event, this time in Nagoya. Find our MySQL talk in the schedule on the website and our staff in the exhibition area at the MySQL booth. OpenSource Day, Warszawa, Poland, May 23, 2018 This year our colleagues from Linux team joined MySQL and we both will be together presenting our products & technologies at OS Day in Poland. Please do not miss to come to our booth to talk about Linux and / or MySQL topics as well as do not miss the MySQL & Linux talks which are still not yet announced. Please keep watching the organizers website for further updates! OpenSUSE, Prague, Czech republic, May 25-27, 2018 MySQL is going to be Silver sponsor of this SUSE annual conference. We are going to have a small MySQL booth and hopefully also a talk accepted. Please watch organizers website for further updates on the submitted MySQL talk. PHPtek18, Atlanta, US, May 31-June 1, 2018  MySQL Community team is a Workshop sponsor this year. Do not miss two accepted MySQL talks given by David Stokes, the MySQL Community Manager. They are: "MySQL Without the SQL -- Oh My!", scheduled for Jun 1st @3:45-4:45pm "MySQL 8 - A New Beginning", scheduled for May 31 @2:30-3:30pm. June 2018: PyCon Taiwan, Taipei, Taiwan, Jun 1-2, 2018 MySQL is a Bronze sponsor. We are hoping to get a MySQL talk approved by the committee. Please watch the organizers' website for further updates. OpenSource Conference Hong Kong (HK OS), Hong Kong, Jun 2-3, 2018 We are going to be Silver sponsor of this OS conference. Please find us at MySQL booth in the expo area as well as attend our MySQL session - topic and timing will be announced later on, please watch the organizers' website for further updates on it. International PHP Conference, Berlin, Germany, Jun 4-8, 2018 MySQL will be supporting this event on the special level including a talk opportunity (not announced yet) and a booth. So, please come to talk to our staff and watch organizers website for the talk announcement. OpenExpo Europe, Madrid, Spain, Jun 6-7, 2018 MySQL team is going to be Bronze sponsor of this show. Please do not miss to visit our booth and talk to our local staff on MySQL topic. Bulgarian Oracle User Group Conference (BGOUG), Broadest, Bulgaria, Jun 8-10, 2018 As a tradition we are supporting and attending this User Group event organized by the BGOUG in Bulgaria. Please do not miss the MySQL talk given by Georgi Kodinov, the MySQL Senior SW Development Manager on "The new data dictionary in MySQL 8.0: what does it mean to you?". Southeast Linux Fest (SELF), Charlotte, US, Jun 8-10, 2018 We are planning to become a Diamond sponsor of this show. You will be able to find us at the MySQL booth in the expo hall... Watch the organizers' website for further updates on the schedule in order to find the timing for MySQL talk. Developer World @CEBIT, Hannover, Germany, Jun 11-15, 2018 MySQL is going only to attend this conference.

We are happy to announce a list of events which we - MySQL &/or MySQL Community Team - are attending and speaking at during the period of time of April to June 2018. Please be aware that the list does...

Announcements

MySQL @ FOSSASIA 2018!

MySQL is again a part of the FOSSASIA - Free Open Source Summit Asia  2018 which will be hold on March 22-25, 2018 in Singapore. Do not miss to come to our booth in exhibition area as well as do not miss MySQL related talks in Database track... See some of them below and at Fossasia schedule: Saturday, March 24, 2018: 10:00-11:00 MySQL Community Gathering - come to join to the MySQL meetup or other community! Come to Lounge area of the Summit to meet Ricky Setyawan. 11:30-11:55 Database Lightning Talk by Ricky Setyawan, the Principal Sales Consultant 17:00-17:25 Breaking through with MySQL 8.0, by Ricky Setyawan, the Principal Sales Consultant Sunday, March 25, 2018: 10:00-10:25 Atomic DDL in MySQL 8.0 by Shipra Jain, the Principal Software Engineer 10:30-10:55 MySQL for Distributed transaction and Usage of JSON as a fusion between SQL & NOSQL by Ajo Robert, the Principal Member Technical Staff  11:00-11:25 Histograms and the way we use it in MySQL 8.0 by Amit Bhattacharya, the Senior SW Development Manager  13:00-13:25 What's new in MySQL Optimizer 8.0 by Chaithra M G the Principal MySQL SW Developer 13:30-13:55 MySQL : Improving Connection Security by Harin Nalin Vadodara the Principal MTS 14:00-14:25 New Replication Features in MySQL 8.0 by Venkatesh Duggirala the Senior Principal Member of Technical Staff 14:30-14:55 Improved Error Logging in MySQL 8.0 by Praveenkumar Hulakund the SW Developer 15:00-15:25 The State of the Art on MySQL Group Replication by Hemant Dangi the Senior Technical Staff 15:30-15:55 Enhanced XA Support for Replication in MySQL-5.7 by Nisha Gopalakrishnan the Principal Member of Technical Staff 16:00-16:25 MySQL Performance Schema - A great insight of running MySQL Server by Manyank Prasad the Principal Member of Technical Staff We are looking forward to talking to you at our booth in expo area or at the Training room 2-1 where the Database track is hold. 

MySQL is again a part of the FOSSASIA - Free Open Source Summit Asia  2018 which will be hold on March 22-25, 2018 in Singapore. Do not miss to come to our booth in exhibition area as well as do not...

MySQL Enterprise

Oracle Enterprise Manager for MySQL Database 13.2.2.0.0 has been released

The MySQL development team is pleased to announce that Oracle Enterprise Manager for MySQL Database 13.2.2.0.0 has been released. Oracle Enterprise Manager for MySQL Database is the official MySQL plug-in that provides comprehensive performance, availability, and configuration information for Oracle's integrated enterprise IT management product line, Oracle Enterprise Manager (13c or later). This is a maintenance release that includes a few enhancements and fixes a number of bugs. You can find more information on the contents of this release in the change log. Use Self-Update to deploy Oracle Enterprise Manager for MySQL Database 13.2.2.0.0. Or use My Oracle Support to download and install manually. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find binaries on the Oracle Software Delivery Cloud.  Type "MySQL Enterprise Monitor" in the search box, or enter a license name to find Oracle Enterprise Monitor for MySQL Database along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition". Then select your platform. Please open a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs My Oracle Support Installation Documentation Complete Documentation Product Information Release Notes

The MySQL development team is pleased to announce that Oracle Enterprise Manager for MySQL Database 13.2.2.0.0 has been released. Oracle Enterprise Manager for MySQL Database is the official MySQL...

MySQL Enterprise

Oracle Enterprise Manager for MySQL Database 13.2.1.0.0 has been released

The MySQL development team is pleased to announce that the fifth release of Oracle Enterprise Manager for MySQL Database is now Generally Available (GA). Oracle Enterprise Manager for MySQL Database is the official MySQL plug-in that provides comprehensive performance, availability, and configuration information for Oracle's integrated enterprise IT management product line, Oracle Enterprise Manager (13c or later). This is a maintenance release that includes a few enhancements and fixes a number of bugs. You can find more information on the contents of this release in the change log. Use Self-Update to deploy Oracle Enterprise Manager for MySQL Database 13.2.1.0.0 Or use My Oracle Support to download and install manually. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find binaries on the Oracle Software Delivery Cloud.  Type "MySQL Enterprise Monitor" in the search box, or enter a license name to find Oracle Enterprise Monitor for MySQL Database along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs My Oracle Support Installation Documentation Complete Documentation Product Information Release Notes

The MySQL development team is pleased to announce that the fifth release of Oracle Enterprise Manager for MySQL Database is now Generally Available (GA). Oracle Enterprise Manager for MySQL Database is...

MySQL Enterprise

MySQL Enterprise Monitor 4.0.3 has been released

We are pleased to announce that MySQL Enterprise Monitor 4.0.3 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Enterprise Carrier Grade subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 4.0 include: Modern look and feel: a redesigned user interface delivers a vastly improved overall user experience. The visible changes--the layout, the icons, the and the overall aesthetics--provide a more natural and intuitive experience. Views dynamically change and adjust to your current context and the assets you've selected, everything from individual MySQL instances or hosts to your custom Groups, to your complex replication and clustered topologies. Additional enhancements include a much more responsive UI and a greater capacity to scale, allowing you to more effectively manage thousands of MySQL related assets. MySQL Cluster monitoring: we now auto-discover your MySQL Cluster installations and give you visibility into the performance, availability, and health of each MySQL instance and NDB process, as well as the health of the MySQL Cluster instance as a single logical system. The Overview dashboard displays detailed instrumentation available for each MySQL Cluster and the Topology dashboard displays the current configuration of your MySQL Cluster enabling you to quickly see the status of the MySQL Cluster instance as a whole and each individual process. The Topology dashboard allows you to easily see how your MySQL Cluster installations are currently functioning. A User Statistics report: which provides an easy way to monitor MySQL resource utilization broken down by user. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon.  Type "MySQL Enterprise Monitor" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 4.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 4.0.3 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software...

MySQL Enterprise

MySQL Enterprise Monitor 3.4.6 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.4.6 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 4.0 offers many significant improvements over MEM 3.4 and we highly recommend that you consider upgrading. More information on MEM 4.0 is available here: What's new in MySQL Enterprise Monitor 4.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.4 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.4.6 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.3.8 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.3.8 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 4.0 offers many significant improvements over MEM 3.3 and 3.4, and we highly recommend that you consider upgrading. More information on MEM 4.0 is available here: What's new in MySQL Enterprise Monitor 4.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.3 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.3.8 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

Announcements

List of Conferences & Events w/ MySQL, January - March 2018!

As a tradition (and follow up of the previous announcement posted on Oct 23, & Sep 15, 2017) we would like to inform you about a conferences & events we - MySQL Community Team - are attending together with MySQL experts in the first quarter of 2018. Please be aware that the list does not have to be final, during the time more events could be added or some of them removed.   January 2018:   OpenSource Conference (OSC) Osaka, Japan, January 26-27, 2018 We are happy to announce MySQL attendance and MySQL session at the OSC event in Osaka, Japan. Please do not miss to find us at MySQL boot in the exhibition area as well as find the MySQL talk. Please find more information at the OSC website. February 2018:   FOSDEM 2018, Brussels, Belgium, February 3-4, 2018 MySQL Community Team is going to be again part of FOSDEM this year. Please mark your calendars. There will be the second edition of the "MySQL Day" just before FOSDEM as well as “MySQL and Friends” dev room scheduled as part of FOSDEM conference & also the "MySQL Community Dinner" which is still TBC. Please find more details/schedule/content & logistics below:     "MySQL Day", Friday, February 2nd, 2018 "MySQL & Friends" dev room, Sunday, Feb 9, 2018. See schedule "MySQL Community dinner" - please stay tuned for more details which will follow soon. SunShine PHP, Miami, Florida, February 8-10, 2018 We are happy to announce our attendance on SunShine PHP this year again. Please do not miss a MySQL talk (listed below) & visit our booth.  Talk: "MySQL 8.0" by David Stokes, scheduled for Fri, Feb 9, 2018 @10:15-11:15am, see the schedule. PHP UK, London, UK, February 14-16, 2018 We are happy to announce that we are having a talk at PHP UK this February. Please find more details below. "MySQL 8 - A New Beginning", given by David Stokes, the MySQL Community Manager, scheduled for Fri, Feb 16, 2018 @11:30 - 12:30pm in Side Track 1, see more details in the schedule.   ​​Korean Community Day (KCD), Seoul, Korea, February 24, 2018   We are happy to announce MySQL Community Team's involvement in the Korean Community Day as Session sponsor. Please find our local staff there to talk about MySQL topics.​ ​PyCon Philippines, Manila, Phgilippines, February 24-25, 2018   ​MySQL Community team is going to become a Premium partner of this conference with a talk on "MySQL 8.0 and InnoDB Cluster live demo" given by Ronen Baram, the MySQL Principal Sales Consultant. Please watch the official PyCon schedule for potential changes/more details.​ March 2018: ConFoo Montreal, CA, March 7-9, 2018 We are happy to announce that we have two accepted MySQL related topics at ConFoo Montreal, both given by David Stokes, the MySQL Community Manager, see details below: “Advance MySQL Query Tuning” scheduled for Thu, March 8, 2018 @15:00-15:45 pm    “MyQL Without The SQL” scheduled for Fri, March 9, 2018 @11:00-11:45 am. ​Southern California Linux Expo (SCaLE), Pasadena, US, March 8-11, 2018​ We are going to be set as Gold sponsor of this show. Do not miss the opportunity to talk to our MySQL Community Manager, David Stokes in the exhibition area at MySQL booth.  FOSSASIA, Singapore, March 22-25, 2018 As a tradition we are going to be part of the biggest Free Open Source Summit in Asia as Bronze sponsor. Come to visit our MySQL booth in expo area as well as do not miss session(s) on MySQL topic which we strongly believe will be accepted. For further updates watch the conference website.  ... to be continued...  

As a tradition (and follow up of the previous announcement posted on Oct 23, & Sep 15, 2017) we would like to inform you about a conferences & events we - MySQL Community Team - are attending...

MySQL Enterprise

MySQL Enterprise Monitor 3.4.5 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.4.5 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 4.0 offers many significant improvements over MEM 3.4 and we highly recommend that you consider upgrading. More information on MEM 4.0 is available here: What's new in MySQL Enterprise Monitor 4.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.4 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.4.5 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.3.7 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.3.7 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 4.0 offers many significant improvements over MEM 3.3 and 3.4, and we highly recommend that you consider upgrading. More information on MEM 4.0 is available here: What's new in MySQL Enterprise Monitor 4.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.3 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.3.7 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 4.0.2 has been released

We are pleased to announce that MySQL Enterprise Monitor 4.0.2 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Enterprise Carrier Grade subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 4.0 include: Modern look and feel: a redesigned user interface delivers a vastly improved overall user experience. The visible changes--the layout, the icons, the and the overall aesthetics--provide a more natural and intuitive experience. Views dynamically change and adjust to your current context and the assets you've selected, everything from individual MySQL instances or hosts to your custom Groups, to your complex replication and clustered topologies. Additional enhancements include a much more responsive UI and a greater capacity to scale, allowing you to more effectively manage thousands of MySQL related assets. MySQL Cluster monitoring: we now auto-discover your MySQL Cluster installations and give you visibility into the performance, availability, and health of each MySQL instance and NDB process, as well as the health of the MySQL Cluster instance as a single logical system. The Overview dashboard displays detailed instrumentation available for each MySQL Cluster and the Topology dashboard displays the current configuration of your MySQL Cluster enabling you to quickly see the status of the MySQL Cluster instance as a whole and each individual process. The Topology dashboard allows you to easily see how your MySQL Cluster installations are currently functioning. A User Statistics report: which provides an easy way to monitor MySQL resource utilization broken down by user. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon.  Type "MySQL Enterprise Monitor" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 4.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 4.0.2 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software...

MySQL Enterprise

MySQL Enterprise Monitor 4.0.1 has been released

We are pleased to announce that MySQL Enterprise Monitor 4.0.1 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Enterprise Carrier Grade subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 4.0 include: Modern look and feel: a redesigned user interface delivers a vastly improved overall user experience. The visible changes--the layout, the icons, the and the overall aesthetics--provide a more natural and intuitive experience. Views dynamically change and adjust to your current context and the assets you've selected, everything from individual MySQL instances or hosts to your custom Groups, to your complex replication and clustered topologies. Additional enhancements include a much more responsive UI and a greater capacity to scale, allowing you to more effectively manage thousands of MySQL related assets. MySQL Cluster monitoring: we now auto-discover your MySQL Cluster installations and give you visibility into the performance, availability, and health of each MySQL instance and NDB process, as well as the health of the MySQL Cluster instance as a single logical system. The Overview dashboard displays detailed instrumentation available for each MySQL Cluster and the Topology dashboard displays the current configuration of your MySQL Cluster enabling you to quickly see the status of the MySQL Cluster instance as a whole and each individual process. The Topology dashboard allows you to easily see how your MySQL Cluster installations are currently functioning. A User Statistics report: which provides an easy way to monitor MySQL resource utilization broken down by user. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon.  Type "MySQL Enterprise Monitor 4.0.0" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 4.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 4.0.1 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software...

Announcements

More events where you can find MySQL@

Above the events announced on September 15, 2017 MySQL experts and / or MySQL Community team is going to attend following events below. Please mark your calendars for: MySQL User Camp, Bangalore, India, November 10, 2017 Next MySQL User Camp in Bangalore, India will be hold on Nov 10, see details below: Date: November 10, 2017 Time: 3-5:30 pm Agenda:   Router with Demo InnoDB Features in 5.7 MySQL Enterprise Backup: A deep dive Venue: OC0017, Block 1, B wing, Kalyani Magnum Infotech Park, J.P. Nagar, 7th Phase Bangalore - 76 We are looking forward to meeting you there!   More information & registration: Facebook, Google Group, LinkedIn Pycon HK, Hong Kong, November 4-5, 2017 MySQL Community team is supporting PyCon HK as a General sponsor. Do not miss MySQL talk on "HA capability with Document Store using MySQL Shell — running Python” topic given by MySQL Engineer, Ivan Ma.  ​ OpenFest, Sofia, Bulgaria, November 4-5, 2017 MySQL Community team in cooperation with local MySQL team are supporting and attending the OS event, OpenFest in Bulgaria. There will be a MySQL booth with our staff at. Please find the MySQL booth on -1floor where most of the workshops are organized. We are looking forward to talking to you there!

Above the events announced on September 15, 2017 MySQL experts and / or MySQL Community team is going to attend following events below. Please mark your calendars for: MySQL User Camp, Bangalore,...

MySQL Enterprise

MySQL Enterprise Monitor 3.3.6 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.3.6 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 4.0 offers many significant improvements over MEM 3.3 and 3.4, and we highly recommend that you consider upgrading. More information on MEM 4.0 is available here: What's new in MySQL Enterprise Monitor 4.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.3 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.3.6 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.2.10 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.2.10 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 4.0 offers many significant improvements over MEM 3.2, 3.3, and 3.4, and we highly recommend that you consider upgrading. More information on MEM 4.0 is available here: What's new in MySQL Enterprise Monitor 4.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs My Oracle Support What's New in 3.2 Change log Installation documentation Complete documentation Product information Frequently Asked Questions Download from My Oracle Support

We are pleased to announce that MySQL Enterprise Monitor 3.2.10 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features...

MySQL Enterprise

MySQL Enterprise Monitor 3.4.4 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.4.4 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 4.0 offers many significant improvements over MEM 3.4 and we highly recommend that you consider upgrading. More information on MEM 4.0 is available here: What's new in MySQL Enterprise Monitor 4.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.4 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.4.4 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 4.0.0 GA has been released

We are very happy to announce the general availability of MySQL Enterprise Monitor, Version 4.0. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Enterprise Carrier Grade subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 4.0 include: Modern look and feel: a redesigned user interface delivers a vastly improved overall user experience. The visible changes--the layout, the icons, the and the overall aesthetics--provide a more natural and intuitive experience. Views dynamically change and adjust to your current context and the assets you've selected, everything from individual MySQL instances or hosts to your custom Groups, to your complex replication and clustered topologies. Additional enhancements include a much more responsive UI and a greater capacity to scale, allowing you to more effectively manage thousands of MySQL related assets. MySQL Cluster monitoring: we now auto-discover your MySQL Cluster installations and give you visibility into the performance, availability, and health of each MySQL instance and NDB process, as well as the health of the MySQL Cluster instance as a single logical system. The Overview dashboard displays detailed instrumentation available for each MySQL Cluster and the Topology dashboard displays the current configuration of your MySQL Cluster enabling you to quickly see the status of the MySQL Cluster instance as a whole and each individual process. The Topology dashboard allows you to easily see how your MySQL Cluster installations are currently functioning. A User Statistics report: which provides an easy way to monitor MySQL resource utilization broken down by user. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon.  Type "MySQL Enterprise Monitor 4.0.0" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 4.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are very happy to announce the general availability of MySQL Enterprise Monitor, Version 4.0. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets...

Announcements

First MySQL Meetup in UAE

We are happy to invite you to the first MySQL Meetup of the MySQL UAE User Group! Please find more details below: Date: Wednesday, October 4th, 2018 Time: 6-8pm Agenda: MySQL Overview or Welcome to MySQL Ecosystem Abstract: MySQL is the most popular open-source database in the world and has been downloaded and/or distributed by MySQL sites over 100 million times. With its outstanding speed, reliability, and ease of use, MySQL has become the preferred choice for Web, SaaS, ISV, and telecom companies like Facebook, Uber, Paypal and many others. In this short overview we will highlight some of the MySQL use cases and will look at how booking.com use MySQL today.  Presenter: Carsten Thalheimer Bio: Carsten works as a Master Principal Sales Consultant at the Oracle MySQL business unit. He is a regular speaker during MySQL Community Events like the FrOSCon, Fosdem, LOADays, DOAG and DOAG MySQL SIG, SOAG, PHP Conferences and MySQL Tech Days. His talks usually cover MySQL architectures, MySQL Solutions and often include future directions of the MySQL database.   Place: Oracle office, 1st floor, Dubai Internet City Building 6, Dubai More details & registration: Please contact Chetan Rao for registration

We are happy to invite you to the first MySQL Meetup of the MySQL UAE User Group! Please find more details below: Date: Wednesday, October 4th, 2018 Time: 6-8pm Agenda: MySQL Overview or Welcome to...

MySQL @BuzzConf Conference, Australia, December 1-3, 2017

As we already announced in the previous blog post from September 15, 2017 we (MySQL) are part of the very unique and special event in Australia, BuzzConf 2017. This is the first time MySQL Community team in cooperation with local Australian MySQL team is part of such event as BuzzConf is. Generally it's described in short as Conference / Festival, however it's really not only this... BuzzConf is a family-friendly technology festival with a really unique atmosphere. All participants and presenters are going to spend the weekend together in country of Victoria (Phoenix Park, Australia), learning and playing with tech during the day and being entertained by live music all night! We are very happy that we can help organizers to run such event full of technologists, people with a hunger for knowledge, to learn about, create, play with emerging technologies - and party all together. Since this is not just a regular conference we asked our local colleague Ronen Baram from MySQL team in Australia for a couple of question related to this event & MySQL. Ronen will attend and represent MySQL this year at BuzzConf and we were really interested in how Ronen perceives this event and what are his plans during the festival. Please find Ronen's answers & responses below: Q: Are you presenting, and what are you presenting on? A: Actually I did not submit any talk for BuzzConf. I thought it is not the type of conference for our regular type of talks.  Q: What are you looking forward to most this year at BuzzConf? A: That's my first time in Buzzconf. I missed last year as I was overseas. I'm looking forward to meet the people who finds a different type of technology event appealing. I think it's an amazing idea and I'm sure it'll be very interesting to chat to others who will attend. The talks seems well picked to make sure we'll enjoy every moment of it. Naturally, since it's a camping type of thing, the kids will join. They are very excited to join all the different activities. Q: What is it like working on OpenSource tech in Australia? A: Australians are very smart people. Many people outside of Australia think that Australians are very laid-back farmers who loves beer and ride their own pet kangaroo. This cannot be further from the truth! I meet many people from many different countries in Asia, Japan and Europe in many different positions in the technology and I find the Aussies to be as smart if not smarter. The main difference is that Aussies enjoy what they are doing to a point they make it almost a hobby. As such they are driven by joy rather then economical reasons. OpenSource, by it's definition, is fun. That's why so many Australians are so involved in it.   Take our team as an example: we have great number of current and past development and support people in Australia. Knowing them all, they are the most fun people to be around. I'm quite sure we have the largest number of Aussies per capita then many other countries. I do tend to attend OpenSource events in Australia and always amazed by the amount of people that are coming the the involvement.  We do ride pet kangaroos though. That's not a myth. Q: I suspect that you meet a lot of MySQL users - and show them ways that they can be more efficient in what they do day-to-day.  What is your ‘aha!’ story, where a new feature was a perfect fit for a particular user? A: I have my two favourite stories, both are coming from Australia: Many years ago, when we just started Australia as MySQL territory, I got a call from a big company using MySQL community version (the free version) for their very mission critical web application. They just signed a contract with a other very big chain in Australia to provide them a service based on this system. Murphy was in a very cheeky mood that morning and the harddrive of the server that was holding MySQL decided to retire to play golf with a group of old 10Mbytes IBM harddrives. Needless to say, MySQL actually needed the said hard drive. We created an awesome software. It can do many things. We didn't, however, made it resilient to a lost of the sole harddrive that holds it's data files....  It's not all gloomy, they had backups. I do use the term "backup" very loosely here though. Since the database was 2Tbyte, running on Windows machine (back them our Windows version wasn't great. We came a long way since) and they had to run mysqldump, they would run a backup only once in 2 weeks. It's not every day you run a 2Tbyte backup that takes about 10 hours to complete. Luckily for them the replication binary log was activated, which enables to do point in time recovery, so we started by recover the mysqldump backup. That took us a good 48 hours (mysqlbackup is a very slow restore tool), then another day to "replay" the last 2 weeks and we got into business within about 3 days.  They couldn't run fast enough to purchase our subscription to get all the goodies it has but mainly for the Enterprise Backup "since they can do incremental, each day is small and quick" <which allows them now to backup quickly everyday and when they tested restore it takes them about an hour to restore the whole database; more then 3Tbytes. That was my favourite story, until I met another client who just purchased Enterprise and tested backup. They where quite happy to find a restore that used to take them 15 days (fifteen!) with mysqldump went down to 1.5 hours. They are not very happy due to the fact you can have many more coffees in 15 days waiting for the restore to complete then you can in 1.5 hours. And now they have to find what to do with all the spare time they suddenly have. Q: What advice to you have to those in IT, but looking to go more specialized into databases? A: Naturally, I'd suggest to use MySQL. But it's not only because I work for MySQL, think it's the most awesome database in the world, dream about it on a daily (or rather nightly) basis and I've been told by my boss to say that. That's not the only reason. The main reason is that MySQL is build to be easy. It was designed to give as little grief as possible when it comes to administer and use it, while being a full blown database just like any other database out there. That's why it became so popular. Now - popular in IT is good. Popular means lots of Google results and endless topics on Stackoverflow. It means you won't be alone. It will allow you grow and study very quickly. I will however emphasis: it's just a database! You can't do much with database without connecting it to something that uses the data it base. It's like an engine: by it self it can't do much. Inside a Ferrari... Well.... you get the point. But even the most amazing Ferrari won't be anything without the engine! So just go to out website (www.mysql.com) and download MySQL, look for simply "hello world" tutorial and start playing. You can't really break anything. Don't hit anything with a hammer. That WILL break some things.  ====== For further details about BuzzConf you can check following pages: Announced presentations, workshops, kinds tracks & entertainments (over 30 sessions are announced already, two main tech tracks, one for talks and the other for workshops, two tracks just for children and families) Several tickets options available (kids are for free) One-minute video summarizing the event Further full day of intensive courses on Friday, Dec 1st. Those are available for a small extra charge and are a great way of getting the latest emerging tech business or hobby off the ground The entertainment lineup details We are looking forward to meeting & talking to you at BuzzConf in December!    

As we already announced in the previous blog post from September 15, 2017 we (MySQL) are part of the very unique and special event in Australia, BuzzConf 2017. This is the first time MySQL Community...

MySQL Enterprise

MySQL Enterprise Monitor 3.4.3 GA has been released

We are pleased to announce that MySQL Enterprise Monitor 3.4.3 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 3.4 include: The Replication Dashboard is extended to provide monitoring support for Group Replication, which was introduced in MySQL Server 5.7.17. The Topology view provides a visual representation of your group replication topologies, and the Status drill downs are updated with Group Replication-specific information. The status of the entire group is reported on, also showing node failure tolerances and whether Group Replication has quorum. New Group Replication Configuration and Group Replication Status Advisors provide continuous analysis of the condition of your group replication topologies. The Configuration Advisor checks for misconfigurations which could lead to unstable or insecure installations; the Status Advisor continuously monitors for servers which go offline or fall out of sync with the other members of the cluster. The new Table Statistics report utilizes sys schema and its schema_table_statistics view to show detailed table statistics in both table and treemap forms. Available on MySQL 5.6 and above, report details include total latencies, total number of rows deleted, total I/O write requests. In general, the user interface page-loading times and page responsiveness are improved in 3.4. In addition, time series graphs are much faster in this release, particularly when you specify a long time period. This graph performance improvement is gained by continuous aggregation of time series data. If you are updating from an earlier version, a one-time aggregation of your historic time series data is performed when you first start the Service Manager (as shown by a progress indicator next to the System Status Summary). You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon.  Search "All Categories" for "MySQL" and choose from the results accordingly.  You will find the Enterprise Monitor along with other MySQL products. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.4 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.4.3 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software...

MySQL Enterprise

MySQL Enterprise Monitor 3.3.5 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.3.5 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 3.4 offers many significant improvements over MEM 3.3 and we highly recommend that you consider upgrading. More information on MEM 3.4 is available here: What's new in MySQL Enterprise Monitor 3.4? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.3 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.3.5 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.2.9 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.2.9 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 3.4 offers many significant improvements over MEM 3.2 and MEM 3.3 and we highly recommend that you consider upgrading. More information on MEM 3.4 is available here: What's new in MySQL Enterprise Monitor 3.4? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs My Oracle Support What's New in 3.1 Change log Installation documentation Complete documentation Product information Frequently Asked Questions Download from My Oracle Support

We are pleased to announce that MySQL Enterprise Monitor 3.2.9 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL & MySQL Community team @Conferences in Sep-Dec 2017

As continue of the previous blog posted on Aug 17, 2017, please find below a list conferences & events where you can find MySQL Community team or MySQL experts during the period of second half of September till end of December. The ones which are new are marked below. Please be aware that the list does not have to be final and during the time more events could be added or some of them removed.    NA&LAD Madison PHP, Madison, US, Sep 22-23, 2017​ MySQL Community team is supporting this PHP conference as Community partner. Oracle Open World, San Francisco, US, Oct 1-5, 2017 - NEW!!! MySQL is, same as in previous years part of the Oracle Open World (OOW). For the scheduled talks and information about where to find us there please watch the conference website. MySQL Community team is organizing a "MySQL Community dinner" for all MySQL fans & well-wishers. Please book the evening of Oct 3, 2017!  See more details & registration All Things Open, Raleigh, NC, USA, Oct 23-24, 2017 - NEW!!! MySQL Community team is supporting and attending this open source conference. We are going to have a booth in the expo area, where you can find our colleagues and experts ready to answer your questions.  ZendCon, Las Vegas, US, Oct 23-26, 2017 - NEW!!! You can find us at MySQL booth in expo area - come to talk to us!. You can also come to listen the "MySQL JSON Data Use Guide" session given by David Stokes, the MySQL Community Manager. This session is scheduled for Oct 24@2:45-3:45pm. ConFoo, Vancouver, Canada, Dec 4-6, 2017 - NEW!!! MySQL Community Team is going to be a Lanyard sponsor of ConFoo Vancouver. Do not miss 2 of MySQL sessions scheduled during ConFoo: "MySQL Replication - From Simple to Group Replication" scheduled for Tue, Dec 5@10:00-10:45am & "Why Your Database Query Stinks" scheduled for Wed, Dec 6@4:00-5:00pm both given by David Stokes, the MySQL Community Manager. PHP Brazil, Osasco - SP - Brazil, Dec 6-10, 2017 - NEW!!! MySQL team is part & supports this Brazilian event. You can find us at the MySQL booth (booth #2) or attend the session "MySQL as Document Store" given by Airton Lastori, the MySQL Consultant for Oracle Brazil.  EMEA WebExpo, Prague, Czech republic, Sep 22-23, 2017 MySQL Community team is supporting this technology conference as Conference Partner. SwanseaCon, Swansea, UK, Sep 25-26, 2017 You can find us at the MySQL booth in the expo area as well as you can find MySQL talk scheduled. David Stokes, the MySQL Community Manager will be talking about "Making MySQL Agile-ish". His talk is scheduled for Sep 26 @11:45-12:30pm. Percona Live, Dublin, Ireland, Sep 25-27, 2017 - NEW!!! Several MySQL engineers and MySQL Community team will be speaking at Percona Live Europe in Dublin. See more details on the MySQL talks at: MySQL Team speaking at Percona Live Dublin 2017 blog post.  MySQL is also listed as contributing sponsor, we are supporting the MySQL Community Dinner! Please watch Percona Live website for more details about the dinner timing.  Gitex, Dubai, United Arab Emirates, Oct 8-12, 2017 - NEW!!! MySQL is going to attend the 37th Gitex Technology week in Dubai World Trade Centre. You can find us at the MySQL booth in expo area. For the floor plan & possible MySQL talk please watch the Gitex website. LibreCon, Santiago de Compostela, Spain, Oct 19-20, 2017 - NEW!!! MySQL team sponsoring this conference and you should be able to find us at MySQL booth in the expo area. Our MySQL colleagues also submitted several MySQL talks which should be announced pretty soon, please watch the website for further updates. Forum PHP, Paris France, October 26-27, 2017 - NEW!!! As a tradition we are supporting this event in Paris this time as a Bronze sponsor. Our MySQL local colleagues will be there to evangelism about MySQL. Scotland PHP Conference, Edinburgh, Scotland, Nov 4, 2017 - NEW!!! MySQL Community team is set as Dram sponsor of this PHP conference. Do not miss the MySQL talk on "MySQL 8 - A New Beginning" given by David Stokes, the MySQL Community Manager. For the exact talk timing please watch the organizers' website. PHP.RUHR, Dortmund, Germany, Nov 9, 2017 - NEW!!!  MySQL is supporting the PHP.RUHR event again this year. Please attend "MySQL 8.0 – make the most of MySQL for your application" talk given by Mario Beck, the MySQL Sales Consulting Manager as well as attend the 45 mins Q&A session in the expo area in the afternoon where you can ask Mario about what you want to know about MySQL. BGOUG, Pravets, Bulgaria, Nov 17-19, 2017 - NEW!!! Bulgarian Oracle User Group organizes the BGOUG event twice a year, we are usually part of both editions. This fall edition will be staffed by Georgi Kodinov, the Senior Software Development Manager with a talk of "MySQL in docker containers".  DOAG, Nuremberg, Germany, Nov 21-24, 2017 - NEW!!! MySQL teams are going to attend this German Oracle User Group Conference as speakers as well as part of the Oracle booth. You can find us there. For the MySQL talks please see the DOAG schedule, where you can find multiple MySQL talks. ​Tech17 UKOUG, London, UK, Dec 4-6, 2017 - NEW!!! ​We are planning to be again part of this Oracle User Group Conference with talks and our presence at the Oracle's booth. Please watch the agenda & Tech17 website for more details. ​IT.Tage, Frankfurt, Germany, Dec 11-14, 2017  - NEW!!! ​MySQL is supporting this conference. You can find MySQL talks in the schedule: "MySQL 8 - Was gibt's Neues?" (scheduled for Dec 12@10:00-10:45am in Raum Stratus 2) & "Ein Einstieg in MySQL und MySQL Enterprise" (scheduled for Dec 13@3:00-3:45pm in Raum Stratus 2) both talks will be given by Carsten Thalheimer, the Technical Sales Consultant. You can also find us at the MySQL booth in the expo area. Another talk confirmed by Oracle is a Keynote on "Oracle Cloud Infrastruktur - Strategie und Ausblick im Zeitalter der Cloud" given by Paul Wehner, the Sales Consulting Senior Director for Germany. APAC JCConf, Taipei, Taiwan, Sep 29, 2017 Our pleasure to announce that MySQL Community team with a help of the local MySQL teams are going to attend and support JCConf this year again. You will be able to find us at the MySQL booth as well as find MySQL talks. For more details please check the agenda.  ​OpenSource Conference India (OSI Days), Bangalore, India, Oct 13-14, 2017 - NEW!!! MySQL team is going to attend & support OSI Days 2017! Please find a keynote talk given by Sanjay Manwani, the MySQL Development Director on "​State of Dolphin - MySQL 8.0" and also find a talk in the Database Day on "MySQL InnoDB Cluster and Group Replication”.  BuzzConf, Phoenix Park, Australia, Dec 1-3 - NEW!!! MySQL Community team is part of this special conference/festival event as Festival Partner. There will be no MySQL talk, but our local colleague Ronen Baram will attend to evangelism about MySQL.  OpenSource Enterprise Conference, Tokyo, Japan, Dec 8, 2017 - NEW!!! As a tradition we are again part of this OS Enterprise Conference as Gold sponsor. Please find our MySQL talk in the agenda and us at MySQL booth in the expo area.  

As continue of the previous blog posted on Aug 17, 2017, please find below a list conferences & events where you can find MySQL Community team or MySQL experts during the period of second half of...

Community

MySQL Community team @Conferences in Aug-Sep 2017

It's our pleasure to announce that MySQL Community team is supporting multiple shows around the world. Please find a list of conferences & events where you can find us in August & September below: NA&LAD UbuCon LA,Lima, Peru, Aug 18-19, 2017 MySQL Community team is supporting this small Ubuntu conference in LAD as Platinum sponsor.   Pacific Northwest PHP, Seattle, US, Sep 9-11, 2017 You can find our team at the MySQL Community booth in the expo area. Madison PHP, Madison, US, Sep 22-23, 2017 MySQL Community team is supporting this PHP conference as Community partner. EMEA FrOSCon, Sankt Augustin, Germany, Aug 19-20, 2017 MySQL Community team is as in previous years Silver sponsor of FrOSCon conference. Our colleague Carsten Thalheimer, the Technical Sales Consultant will have a talk on MySQL 5.7 - InnoDB Cluster [HA built in], scheduled for Saturday, Aug 19@14:00. Do not miss to come to MySQL booth at the expo area to talk to us! WebExpo, Prague, Czech republic, Sep 22-23, 2017 MySQL Community team is supporting this technology conference as Conference Partner.  SwanseaCon, Swansea, UK, Sep 25-26, 2017 You can find us at the MySQL booth in the expo area as well as you can find MySQL talk scheduled. David Stokes, the MySQL Community Manager will be talking about "Making MySQL Agile-ish". His talk is scheduled for Sep 26 @11:45-12:30pm. APAC Open Developer Conference, Tokyo, Japan, Aug 19-20, 2017 MySQL Community with a help of the local MySQL team is staffing and supporting this conference. You can find us at our MySQL booth in the expo area as well as you find the MySQL talks in the agenda. Our colleague Ryusuke Kajiyama will be talking about development team and model of MySQL and about "New way of developing MySQL app with Document Store". Check agenda for more details. Open-Source Developer Forum, Beijing, China, Aug 24-25, 2017 MySQL Community team in cooperation with the local MySQL User Group (ACMUG) are organizing a OS Developer Forum for more than 300 MySQL (and not just MySQL) users.  db tech showcase, Tokyo, Japan, Sep 5-7, 2017 As a tradition we are again part of the db tech showcase. You can find our talks in the schedule as follows: Mikiya Okuno, MySQL Support Engineer on "What's new MySQL Cluster 7.5 and beyond"   Ryusuke Kajiyama, MySQL Sales Consulting Senior Manager on "New Unicode Collations in MySQL 8.0"   Takanori Sejima, Senior Lead Engineer: Talk topic will be determined later on. Yoku0825, Oracle ACE MySQL: Talk topic will be determined later on. Open Source Conference 2017 Tokyo/Fall, Tokyo, Japan, Sep 9-10, 2017 MySQL Community team is supporting this event as Gold sponsor. You can find our team on the MySQL booth in the expo area as well as attend MySQL talks. Our colleagues Daisuke Inagaki, MySQL Sales Consultant and Ryusuke Kajiyama, MySQL Sales Consulting Senior Manager will be available at our MySQL booth and Ryusuke will be talking about news in MySQL 8.0-New feature (window function, Japanese collation...), MySQL InnoDB Cluster, MySQL Cloud Services etc.  JCConf, Taipei, Taiwan, Sep 29, 2017 Our pleasure to announce that MySQL Community team with a help of the local MySQL teams are going to attend and support JCConf this year again. You will be able to find us at the MySQL booth as well as find MySQL talks. For more details please check the agenda. Much more conferences & events will come up soon.   

It's our pleasure to announce that MySQL Community team is supporting multiple shows around the world. Please find a list of conferences & events where you can find us in August & September below: NA&LA...

Announcements

MySQL Enterprise Edition Now in Docker Store!

I'm happy to announce that in addition to the official MySQL Community Edition Docker images, we now have official MySQL Enterprise Edition Docker images available in Docker Store! Now you can easily leverage the power of Docker with MySQL Community Edition or MySQL Enterprise Edition.     What Does All of This Mean? First some context and general info to help you understand this news a bit more. Docker is a container platform which includes the following software components: The Docker Engine, which is a client-server application consisting of: The dockerd server process A REST API that client programs can use to interact with dockerd The docker command-line client Optional orchestration tooling--Compose and Swarm--that help you manage more complex container based applications The Docker SaaS platform that provides the underlying infrastructure for working with Docker containers--identity, repositories, versioning, etc. (this is the rough equivalent of what GitHub offers Git users).  The usage of container images (pull and push) through docker by default utilize Docker's public container registries, and the access to those registries is managed through your user account that you create--your Docker ID. You then use that Docker ID to login and persist an authentication token on your client machine for accessing their public registries. Docker provides two separate public registries: Docker Hub or "Docker Registry" is their registry for FOSS/Community containers. This is what the docker CLI will use by default. Example usage being: docker run -itd mysql/mysql-server Docker Store or "Docker Trusted Registry" is their registry for "Enterprise" and Commercial containers. So How Would I Use The MySQL EE Container Then? You first setup authorized access to the container for your Docker ID within the Docker Store or "Docker Trusted Registry" by subscribing to the MySQL EE image. You do that simply by "proceeding to checkout" there since you don't have to pay up front (it's a BringYourOwnLicense model). Once you specify the required info, then registered/authorized access to the content and container will be associated with your Docker ID.  Now that you have authorized access, you can use/run it with: docker run -itd store/oracle/mysql-enterprise-server:5.7 Finally, you can view all of your authorized/subscribed content in Docker Store at https://store.docker.com/profiles/{DockerID}/content and you can see what local images you have available on your host machine using the docker images command. Summary We're excited that you can now combine the power and flexibility of Docker and MySQL Enterprise! I hope that I've also helped you to understand exactly how you would go about getting started on that endeavor. If you have any questions or issues, please do let us know! Feel free to leave a comment here, reach out to me on twitter, file a bug, or file a support ticket in My Oracle Support. As always, THANK YOU for using MySQL!

I'm happy to announce that in addition to the official MySQL Community Edition Docker images, we now have official MySQL Enterprise Edition Docker images available in Docker Store! Now you can easily...

MySQL Enterprise

MySQL Enterprise Monitor 3.4.2 GA has been released

We are pleased to announce that MySQL Enterprise Monitor 3.4.2 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 3.4 include: The Replication Dashboard is extended to provide monitoring support for Group Replication, which was introduced in MySQL Server 5.7.17. The Topology view provides a visual representation of your group replication topologies, and the Status drill downs are updated with Group Replication-specific information. The status of the entire group is reported on, also showing node failure tolerances and whether Group Replication has quorum. New Group Replication Configuration and Group Replication Status Advisors provide continuous analysis of the condition of your group replication topologies. The Configuration Advisor checks for misconfigurations which could lead to unstable or insecure installations; the Status Advisor continuously monitors for servers which go offline or fall out of sync with the other members of the cluster. The new Table Statistics report utilizes sys schema and its schema_table_statistics view to show detailed table statistics in both table and treemap forms. Available on MySQL 5.6 and above, report details include total latencies, total number of rows deleted, total I/O write requests. In general, the user interface page-loading times and page responsiveness are improved in 3.4. In addition, time series graphs are much faster in this release, particularly when you specify a long time period. This graph performance improvement is gained by continuous aggregation of time series data. If you are updating from an earlier version, a one-time aggregation of your historic time series data is performed when you first start the Service Manager (as shown by a progress indicator next to the System Status Summary). You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon.  Type "MySQL Enterprise Monitor 3.4.2" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.4 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.4.2 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software...

MySQL Enterprise

MySQL Enterprise Monitor 3.3.4 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.3.4 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 3.4 offers many significant improvements over MEM 3.3 and we highly recommend that you consider upgrading. More information on MEM 3.4 is available here: What's new in MySQL Enterprise Monitor 3.4? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.3 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.3.4 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.2.8 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.2.8 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 3.4 offers many significant improvements over MEM 3.2 and MEM 3.3 and we highly recommend that you consider upgrading. More information on MEM 3.4 is available here: What's new in MySQL Enterprise Monitor 3.4? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs My Oracle Support What's New in 3.1 Change log Installation documentation Complete documentation Product information Frequently Asked Questions Download from My Oracle Support

We are pleased to announce that MySQL Enterprise Monitor 3.2.8 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.4.1 GA has been released

We are pleased to announce that MySQL Enterprise Monitor 3.4.1 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 3.4 include: The Replication Dashboard is extended to provide monitoring support for Group Replication, which was introduced in MySQL Server 5.7.17. The Topology view provides a visual representation of your group replication topologies, and the Status drill downs are updated with Group Replication-specific information. The status of the entire group is reported on, also showing node failure tolerances and whether Group Replication has quorum. New Group Replication Configuration and Group Replication Status Advisors provide continuous analysis of the condition of your group replication topologies. The Configuration Advisor checks for misconfigurations which could lead to unstable or insecure installations; the Status Advisor continuously monitors for servers which go offline or fall out of sync with the other members of the cluster. The new Table Statistics report utilizes sys schema and its schema_table_statistics view to show detailed table statistics in both table and treemap forms. Available on MySQL 5.6 and above, report details include total latencies, total number of rows deleted, total I/O write requests. In general, the user interface page-loading times and page responsiveness are improved in 3.4. In addition, time series graphs are much faster in this release, particularly when you specify a long time period. This graph performance improvement is gained by continuous aggregation of time series data. If you are updating from an earlier version, a one-time aggregation of your historic time series data is performed when you first start the Service Manager (as shown by a progress indicator next to the System Status Summary). You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon.  Type "MySQL Enterprise Monitor 3.4.0" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.4 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.4.1 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software...

MySQL Cluster 7.6: The First Milestone

The first Development Milestone Release (DMR) of MySQL Cluster 7.6--7.6.2--is now available! You can see the full changelog for 7.6.2 here. But before we get into the specifics on 7.6.2, I'd  like to take a minute just to paint the bigger picture of where we want to go with MySQL Cluster over the long term. While we cannot and will not discuss or project version numbers and/or dates for any given feature, it's helpful to know what our bigger goals and longer term roadmap are with MySQL Cluster (see the standard Oracle Safe Harbor disclaimer). Long Term Goals  We've set some pretty lofty goals for the MySQL Cluster development in future major releases, with our primary focus areas being as follows--with some examples of each: Cloud Native   • Scaling data nodes up and down   • Security     – Data encrypted in transit and at rest     – AuthN and AuthZ in all nodes (e.g. ndb_mgmd)    • Improved service registry and discovery   • Improved orchestration and automation     – Providing our own tooling     – Operating well within third party frameworks: Ansible, SaltStack, Puppet, Chef, etc. Greater horizontal and vertical scaling   • Greater than 48 data nodes and 255 total nodes    • Efficient 100s TB sized clusters Improved ease-of-use   • Better integration with MySQL Enterprise Monitor    • Zero configuration installs    • Improved tooling     – Official yum/apt repos (available now!) and official Docker containers     – Official Init / Systemd scripts   • More dynamic (eliminating node failures and manual restarts)     – Eliminate internal hardcoded limits on buffers / caches     – Make configuration changes settable in the running process     – Make buffers/caches adaptive and able to scale up and down as needed Improved performance   • Multi-threaded geo-replication between clusters   • Parallelized backups and restores    • Shared memory transporter Improved data redundancy   • Full support for 1-4 replicas   Highlights for 7.6.2  MySQL Cluster 7.6 is our first release where we begin implementing this bigger long term vision. With this big picture context in mind, here are some highlights of what's new in the first 7.6 DMR: A new disk based table file format, which eliminates a number of historical issues. This is one factor that can allow much larger total cluster sizes, as you can move your cold/archive data to disk based tables. Our first move towards a single flexible and dynamic memory allocation pool by the merging of the IndexMemory parameter and structure into DataMemory. A significant overall performance improvement by removing some now unnecessary debug facilities (these are "JAMs" within NDB that dump debug information to trace files). Various ndbinfo additions and other metadata improvements that pave the way for making MySQL Cluster much easier to monitor and manage (stay tuned for future announcements around MySQL Enterprise Monitor and MySQL Cluster).  A new AutoReconnect feature in ClusterJ--the native NoSQL NDB API implementation available for Java--which makes it much easier to write zero downtime Java applications for MySQL Cluster. A new bulk data load tool: ndb_import. This makes it far easier to work with large data sets and perform bulk data loads and migrations by providing a highly parallel and concurrent tool for importing data.  The very beginning of our work to improve the Local Data Manager component and the Local Checkpoint Protocol behavior, both of which are critical to our goals of supporting 100s TB sized clusters.  So as you can see, with this first 7.6 DMR we've begun to lay the groundwork for many of our long term goals. We're really excited about what's coming in future 7.6 DMRs and beyond!  You can download 7.6.2 here (Development Releases tab). I would encourage you to try it out! If you feel that you've encountered a bug, please let us know by filing a bug report or opening a support ticket.  THANK YOU for using MySQL!    Safe Harbor Statement This content is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.  

The first Development Milestone Release (DMR) of MySQL Cluster 7.6--7.6.2--is now available! You can see the full changelog for 7.6.2 here. But before we get into the specifics on 7.6.2, I'd  like to...

MySQL Enterprise

MySQL Enterprise Monitor 3.4.0 GA has been released

We are very happy to announce the general availability of MySQL Enterprise Monitor, Version 3.4. MySQL Enterprise Monitor is the best- in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Enterprise Carrier Grade subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 3.4 include: The Replication Dashboard is extended to provide monitoring support for Group Replication, which was introduced in MySQL Server 5.7.17. The Topology view provides a visual representation of your group replication topologies, and the Status drill downs are updated with Group Replication-specific information. The status of the entire group is reported on, also showing node failure tolerances and whether Group Replication has quorum. New Group Replication Configuration and Group Replication Status Advisors provide continuous analysis of the condition of your group replication topologies. The Configuration Advisor checks for misconfigurations which could lead to unstable or insecure installations; the Status Advisor continuously monitors for servers which go offline or fall out of sync with the other members of the cluster. The new Table Statistics report utilizes sys schema and its schema_table_statistics view to show detailed table statistics in both table and treemap forms. Available on MySQL 5.6 and above, report details include total latencies, total number of rows deleted, total I/O write requests. In general, the user interface page-loading times and page responsiveness are improved in 3.4. In addition, time series graphs are much faster in this release, particularly when you specify a long time period. This graph performance improvement is gained by continuous aggregation of time series data. If you are updating from an earlier version, a one-time aggregation of your historic time series data is performed when you first start the Service Manager (as shown by a progress indicator next to the System Status Summary). You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon.  Type "MySQL Enterprise Monitor 3.4.0" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.4 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are very happy to announce the general availability of MySQL Enterprise Monitor, Version 3.4. MySQL Enterprise Monitor is the best- in-class tool for monitoring and management of your MySQL assets...

MySQL

An Insider’s View of MySQL Group Replication—Now Available in Oracle MySQL Cloud Service!

MySQL is the #1 open source database. Because of MySQL’s highperformance, scalability, and availability, it has been widely popular for Webapplications and has become the foundation for IT platforms that supporthigh-traffic social media portals, e-commerce applications, and fast-growingorganizations. As business models and technology requirements are beingtransformed in all industries, more and more companies are embracing andleveraging the cloud platform to enjoy the benefits of flexibility, agility andcost-savings. Available in Oracle Cloud, the Oracle MySQL Cloud Serviceprovides an enterprise-grade MySQL database service to rapidly, securely, andcost-effectively deliver modern applications. With the latest MySQL 5.7.17 updaterelease, MySQL Group Replication is now available in Oracle MySQL Cloud Serviceand offers native, built-in high availability for MySQL databases. To gain deeper insight into the benefits and use cases ofMySQL Group Replication, we had the pleasure to interview Nuno Carvalho, theteam lead for MySQL Group Replication, and get his insider perspective. Q: Hi Nuno, could yougive us a little background about yourself and tell us what you do at MySQL? A: Absolutely! Before coming to MySQL, I was a post-graduatestudent and a researcher at the University of Minho in Portugal. My work focusedon designing and implementing techniques to improve scalability for distributedsystems. Five years ago I joined Oracle as a developer on the MySQL replicationteam. One day, the opportunity to work on Group Replication was presented to me,and my small team took on the task of making it happen. Currently I'm aPrincipal Software Engineer and the MySQL Replication Service Team Lead atOracle. My team is in charge of MySQLGroup Replication plugin. Q: Before we diveinto Group Replication, could you tell us what MySQL replication is and whyit's such a popular feature for MySQL? A: MySQL replication is a simple and effective way to spreaddata among several servers, with three main goals: 1) Availability: we can avoid the issue of singlepoint of failure by replicating data to several locations. 2) Scalability: the application can serve morerequests by sending read operations to replicas and allowing the primary serverto handle only the write operations. 3) Overcome the single server limit: eventually allbig users will reach the point when their data no longer fits in a singleserver. The solution is to shard data across multiple servers, and it needsreplication to take care of data flow for the sharding to operate effectively. MySQL replication is very easy toset up and it performs extremely well, so MySQL developers and DBAs love to usethis feature to scale out and to provide high availability for their MySQLenvironments. Q: What triggered thedevelopment of MySQL Group Replication if the existing MySQL replication isalready a great solution? A: MySQL replication is an asynchronous replication, so toavoid confusion between the traditional MySQL replication and the new MySQLGroup Replication, I’ll call the existing MySQL replication “MySQL asynchronousreplication” moving forward. As mentioned previously, many MySQL developers and DBAs useMySQL asynchronous replication for scaling out—using the primary server tohandle all the writes and the replicas for read operations. In this scenario,if for any reason the primary server fails or needs to be taken down formaintenance or upgrade, the DBA has to manually failover the primary server toone of the replicas, direct the write traffic to the new primary, and configureall the replicas to replicate from it. Once the previously-failed server goesback online again, the DBA has to manually add the server back to thereplication topology and configure it appropriately. This is not a big problem if you only have one primary andtwo replicas, but consider the situation when you have tens or hundreds ofreplicas, or even multiple layers of replication in your topology: handling allthese tasks manually becomes very complicated, time-consuming and error-pronefor DBAs. As the number of MySQL users grows, so does the usage of MySQL withbusiness-critical applications and its footprint within organizations. Therequest to have a fault-tolerant MySQL system became a high priority for our customersand also for the MySQL engineering team at Oracle. And so my team started on the journey of creatingMySQL Group Replication. Q: It’s great to hearthe story behind product development and that’s actually a good transition toour topic for today: What is MySQL Group Replication and how does it work? A: MySQL Group Replication is a MySQL Database plugin thatenables developers and DBAs to create elastic, highly-available, fault-tolerantreplication topologies. It’s a mechanism that manages a group of servers andpresents it as if it’s a single server because all the servers in the samegroup do the same operations and have the same data. Having multiple copies ofthe same data set minimizes the risk of losing that data. MySQL Group Replication can be operated in two modes: 1. Single-primary mode: in this mode, only one server acceptsupdates at a time, so it’s almost like a drop-in replacement for any singleserver, but with built-in high availability. In the case that the primaryserver fails, the group automatically elects a new primary, and there is nointerruption to the service as everything happens in the background. 2. Multi-master mode: in this mode, all servers can acceptupdates, even if they are issued concurrently. The built-in group membershipservice keeps the view of the group consistent, and it’s available for allservers at any given point in time. Servers can leave or join the group, and theview would be updated accordingly. In the case when a server leaves the groupunexpectedly, the built-in failure detection mechanism would detect this eventand notify the group that the view has changed. And when a server joins, thegroup would go through a distributed recovery stage so updates will be providedto the group before handling requests. All these operations happen automaticallywith no manual intervention needed. Q: How is MySQL GroupReplication different from other MySQL replication mechanism? A: MySQL Group Replication, despite providing the same lookand feel as a single server, it has a completely new implementation in thetransport layer. MySQL asynchronous replication uses typical TCP connectionsbetween the primary server and its secondary servers, and these operations arenot coordinated. For example, if a primary has two secondary servers, it is notsimple to ensure that data is replicated at same time to both of the secondaryservers. This makes handling failovers a very complex process for theadministrator. On the other hand, MySQL Group Replication is based on aPaxos implementation, which ensures that all servers receive the same set ofdata in the same order. This allows us to establish a logic clock among thegroup and thus all operations, such as real-time group membership or primaryelection in the single-primary mode, can be controlled according to that clock.With such implementation, MySQL Group Replication performs much better in termsof durability compared to the typical MySQL asynchronous replication. Q: How does MySQLGroup Replication help DBAs? A: When MySQL asynchronous replication is used, DBAs are responsiblefor manually handling failures and primary failovers when the machine fails or duringscheduled maintenance on the primary server. With the built-in group membershipmanagement in MySQL Group Replication, those tasks are managed automatically, nomatter when a member is removed intentionally, such as for maintenance, or by accidentdue to machine failure. MySQL Group Replication provides data consistencyguarantees, conflict detection and handling, node failure detection anddatabase failover-related operations, all without the need for manualintervention or custom tooling. When issues occur, the group has the capabilityto manage necessary failover and heal itself. This is a major step forward on automating DBAs’ tasks. WithMySQL Group Replication, DBAs not only save the time they otherwise would have hadto spend on manually configuring necessary failovers during scheduledmaintenance; more importantly, it removes the burden from DBAs to configurefailovers and other necessary settings correctly during stressful disasterrecovery. Since the failover process is automated, the failover time issignificantly reduced in the case of server failure. For MySQL asynchronousreplication, when the primary server fails, it takes from 5 seconds to a minuteor more for the failover to complete, depending on the workload and mainly onhow the primary failure is detected. With MySQL Group Replication, since wehave a group of servers, if one fails, the failover is immediately taken careof by the group automatically. That is a huge improvement in high availabilityand also there is no single point of failure. Q: How do developersbenefit from MySQL Group Replication? From the developers’ perspective, the best part ofimplementing MySQL Group Replication—using the single-primary mode—is that almostno change is required at the application level! Just minimal change in the codeand much higher availability for the application—how great is that? Existing applicationscan be easily adapted when the underlying infrastructure moves from a singleserver to a group of servers managed by MySQL Group Replication, and developerscan expect that the usual behavior of InnoDB, Performance Schema as well asother MySQL components. A quick note to developers thinking about trying out MySQLGroup Replication: transactions may rollback on commit due to conflicts betweenconcurrent operations, given the distributed fashion in the architecture. Forexample, if you have a group of three, when two transactions are issued inparallel to two different servers and they touch the same row, one of them willbe rolled back and only one will be committed. This is the difference developersshould be aware of when you replace a single server with Group Replication. Another benefit Group Replication offers for developers isguaranteed durability. MySQL Group Replication only acknowledges the commit onceit reaches the majority of servers in the group. Therefore, even if someservers fail, the data is never lost because the majority already has it. Thisis really, really important for developers. Q: What has thefeedback been from MySQL users? A: MySQL Group Replication has only been generally availablesince December 2016, so most of our users are either testing this feature orusing it in their pilot programs. So far we’ve heard a lot of positive feedbackfrom those early adopters. They especially like the fact that this feature isreally easy to use and deploy, with almost no change required in theapplication. We also received very useful input from our users, which we’re usingto make MySQL Group Replication even more powerful and user friendly. Q: Now MySQL GroupReplication is also available in the Oracle MySQL Cloud Service. Whatadditional benefits do you foresee by having this feature in the cloud? A: With MySQL Group Replication available in Oracle MySQLCloud Service, the biggest and most immediate benefit is that users have everythingthey need all together, at one place. With a few clicks, our users can accessthe latest and greatest replication technology for MySQL on the best hardware,with optimal configuration. The end user will be able to easily create elastic,highly-available, fault-tolerant MySQL replication deployment. Here is a good example: with all the great capabilities Imentioned earlier about MySQL Group Replication, some DBAs may be veryinterested in trying it out, but they may be hesitant because they would haveto buy five machines and deploy five machines to take advantage of the benefitsof having a (5-member) group. Considering the time and money required topurchase and configure five machines only to test MySQL Group Replication, theidea of trying out this new feature seems less appealing. On the other hand,having MySQL Group Replication in Oracle MySQL Cloud Service, the entireprocess becomes very easy. Those DBAs only need to click a few buttons and requestfive MySQL instances in Oracle Cloud, and the service is ready to go in amatter of minutes—far faster than acquiring and configuring five physicalservers! This scenario would be perfect for many or even most customers in myopinion. Q: What futureenhancements can users look forward to? A: We are always working to make MySQL Group Replication, andMySQL replication in general, even easier to use and more performant. There aretwo areas of performance enhancements we are currently working on for MySQLGroup Replication: the first is to minimize the performance overhead or impactwhen MySQL Group Replication is enabled; the other is to further increase thenumber of members we can support in one group. Q: Any parting wordsyou'd like to share with us? A: MySQL Group Replication was a huge team effort, and it isgreat to see it already being used by costumers and to hear their positivefeedback. It has been a pleasure to take an active part in the creation of thisproduct. Thank you, Nuno, for sharing your insight into MySQL Group Replication! To learn more, visit the product page for presentation slides and additional resources.

MySQL is the #1 open source database. Because of MySQL’s high performance, scalability, and availability, it has been widely popular for Webapplications and has become the foundation for IT platforms...

MySQL Enterprise

MySQL Enterprise Monitor 3.3.3 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.3.3 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud in a week or so. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 3.3 include: 3.3 introduces a new Enterprise Backup Dashboard that brings deeper integration with MySQL Enterprise Backup. View current backup status, history and archive details by group or instance using MySQL Enterprise Backup Advisor collections from existing mysql.backup_history and mysql.backup_progress table data. Backup Group view shows a summary of backup events, details on the last successful full and Incremental backup types, any failed backups and an indication of whether the group has full backup coverage. Coverage calculations include appropriate checks on replication filters across your replication topologies. Backup view of a single MySQL Instance shows a summary of backup events, details on the last successful full and Incremental backup types and any failed backups. Select the Backup History tab to see all known backups in the event you need to perform a restore operation. Each row in the backup history table shows the backup type, status, completion timestamp and the log coordinates when the consistent snapshot was taken. Drill down to an individual Backup archive to view all its metadata and associated progress logs. The 3.3 User Interface now makes zooming in on common problems a single click on a named filter. Use these shortcuts to quickly select the search criteria of most interest on the MySQL Instances, Events, Query Analyzer and All Timeseries Graphs pages. Examples of pre-defined filters include all MySQL Instances using an EOL version, old MySQL Enterprise Monitor Agent installations, currently open Emergency events, and all statements that cause a full table scan, temporary tables on disk or SQL Errors. In addition to pre- defined filters, you can assign a name to your own favorite search conditions for reuse across sessions. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon.  Type "MySQL Enterprise Monitor 3.3.3" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitorand Query Analyzer using our 30-day free customer trial, go tohttp://www.mysql.com/trials, or contact Sales athttp://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.3 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.3.3 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud...

MySQL Enterprise

MySQL Enterprise Monitor 3.2.7 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.2.7 is nowavailable for download on the My Oracle Support (MOS) web site.This is a maintenance release that includes a few new features and fixes a number of bugs. You canfind more information on the contents of this release in thechange log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 3.3 offers many significantimprovements over MEM 3.2 and we highly recommend that youconsider upgrading. More information on MEM 3.3 is available here: What's new in MySQL Enterprise Monitor 3.3? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitorand Query Analyzer using our 30-day free customer trial, go tohttp://www.mysql.com/trials, or contact Sales athttp://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs My Oracle Support What's New in 3.1 Change log Installation documentation Complete documentation Product information Frequently Asked Questions Download from My Oracle Support

We are pleased to announce that MySQL Enterprise Monitor 3.2.7 is now available for download on the My Oracle Support (MOS) web site.This is a maintenance release that includes a few new features...