X

MySQL and MySQL Community information

Recent Posts

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...

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...

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...

MySQL Enterprise

MySQL Enterprise Monitor 3.1.7 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.1.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.1 and 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.1.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...

Improved Logging Messages

Introduction Logging is a very importantdiagnostic tool for understanding the behavior of the application as well astroubleshooting any issue with the application. Since MySQL Enterprise Backup(MEB) is a command line application, there is little interaction with themyriad of operations going on behind the scenes. Thus, logging messages are veryimportant for knowing the progress of current operation as well as learningmore about errors should they occur. The messages logged by MEB are written tothe console and the log file as depicted in the following diagram, which lookssimilar to the Tee command in UNIX. By default, MEB creates the log file in the default ‘<backup_dir>/meta’directory with a name like MEB_<Date.time>_<operation_name>.log. For example – MEB created a logfile with the name, ‘MEB_2017-02-24.07-47-09_backup.log’, for the backupoperation executed to save the log messages. User may specify any other existing directoryto create the log file using the --messages-logdir= <directory_ path>option. Users may also skip the log file creation using the --skip-messages-logdiroption, but it is not recommended. Background Prior to 4.1 release, the log messages are printed as shownbelow. Notice how the messages seem tointerlace, making it harder to read a logical flow from the output. There wereseveral reasons for this. MEB is a multithreaded application. From the output, there was no way to determine which thread printed the message. This is very crucial information to know when diagnosing problems or performance. The log messages contained trace levels starting with the string, ‘mysqlbackup:’. But this did not convey any useful information. Furthermore, some of these log messages are printed without any timestamp prefixes. The trace levels of thelog messages, in the order of increasing fineness, are: 0 - INFO (information,warnings, errors) 1 - FINE (more information given than at trace level 0) 2 - FINER (finer levelof information given than at trace level 1) 3 - FINEST (finestlevel of information that can be given) The improvements Logging has been greatly improved In the 4.1release. They are now printed as shown below.  The improvements are small buthave a profound effect on readability and usability. These improvements includethe following. MEB now prints each thread name that it creates. The thread name is an abbreviation derived from the thread description. They willalso be helpful in analyzing the work performed by each thread. The followingtable shows several examples Thread Name  Thread Description  RDR1  ReaDeR thread #1  PCR1  ProCessoR thread #1  WTR1  WriTeR thread #1  CLD1  CLouD thread #1  RLR1  Redo Log Reader thread #1  RLP1  Redo Log Processor thread #1  RLW1  Redo Log Writer thread #1  ALW1  Apply Log Worker thread #1 Every message that includes a trace level isnow prefixed with the timestamp.  The logger module has been improved forbetter performance. Summary Wehope these small improvements will be useful for troubleshooting purpose. Tryout the latest version and provide us feedback on how we can improve itfurther. For more details and usage samples, please refer MySQL EnterpriseBackup 4.1 User’s Guide .

Introduction Logging is a very important diagnostic tool for understanding the behavior of the application as well as troubleshooting any issue with the application. Since MySQL Enterprise Backup(MEB)...

MySQL Enterprise

Optimistic Incremental Backup

MySQL Enterprise Backup Team is pleased to announce major improvements in incremental backup performance starting with release 4.1. Introduction The current incremental backup algorithm scans all the tables to gather changed pages even if very few tables are modified since the previous backup and thus results in a  'full-scan' incremental backup. This may result in increment backups requiring the same amount of time as full backup because it scans all the tables. The new algorithm aims to eliminate this extra time. The new algorithm scans only those tables that have been modified since the previous backup. This algorithm relies on modification time, which is similar to an earlier improvement made for full backup. That full backup algorithm is known as optimistic full backup,  hence new improvement is named ‘Optimistic Incremental Backup’. For comparison, we will use optimistic full backup to refer to the performance improvements for full backup and optimistic increment backup for the new improvements to incremental backup. In the new optimistic incremental backup algorithm, we refer to the tables that are not modified since the previous backup as 'unchanged tables'. We refer to tables that are modified after the previous backup as 'busy tables'. The new optimistic incremental backup therefore scans only busy tables for changed pages. However, there is one difference between optimistic full backup and the new optimistic incremental backup. For optimistic full backup, the user had to specify either the --optimistic-time or --optimistic-busy-tables options in order to identify the busy tables. In case of optimisitic incremental backup, no additional parameters are necessary because the algorithm identifies busy tables, which are clearly defined and identified. How Optimistic Incremental Backup works The first and foremost goal for MySQL Enterprise Backup (MEB) is quality and consistency. To achieve a consistent  backup during optimistic incremental backup, MEB identifies a point in time against which the modification time of tables could be compared. MEB then acquires a read lock on the tables for very short span of time to copy the non-innoDB files. Since non-Innodb tables cannot be modified the lock period, MEB records a timestamp during the lock period which we might call the consistency time; the time that tables are consistent when the timestamp is recorded. When the optimistic incremental backup starts, it compares the modified time of each table against the consistency time. If the modification time of a table is greater than the consistency time, that table has been modified after consistency time was recorded and optimistic incremental backup needs to scan that table for changed pages. The above diagram depicts an optimistic incremental backup sample execution as the following.   There are 6 tables to be scanned (and may be copied too) during previous backup operation. MEB notes the consistency time when tables are locked. Table7 is created after the tables are unlocked but backup is still copying the meta files. After the backup is finished, Table1 is updated and Table8 is created. When optimistic incremental backup starts, it looks for the consistency time from the previous backup. MEB compares the consistency time with the modification time of all the tables present in datadir. It finds that only three tables that have been modified after the consistency time. Hence, these three tables are scanned for changed pages. The remaining tables are unchanged tables and are ignored.  If any unchanged tables are modified during optimistic incremental backup, the changes are recorded in the redo log file. These changes will be applied at the apply log (restore) phase.   Notes The consistency time is stored in a column named consistency_time_utc in the backup_history table as well as in a field with the same name in the meta file backup_variables.txt. If the --no-locking or --no-connection options are used during backup, the backup start time is recorded as the consistency time. During an optimistic incremental backup, if MEB is unable to discover the consistency time from the previous backup, it defaults to the older incremental backup algorithm. It is possible in some special cases, optimistic incremental backup may perform the same as the older incremental backup algorithm. How to Trigger an Optimistic Incremental backup The current --incremental option is extended to include the following values. optimistic: optimistic incremental backup algorithm is triggered if --incremental=optimistic is specified while taking the incremental backup.  full-scan: the older incremental backup algorithm is triggered if --incremental=full-scan or --incremental is specified while taking the incremental backup. It scans all the tables that qualifies the backup operation. This is also the default algorithm to be used when no argument is given for the option. The following are some examples. Optimistic Incremental image backup using dir:directory_path: >mysqlbackup.exe --backup-image=<image file name > --backup-dir=<temporary directory name> \ --incremental-base=dir:<previous backup directory> \ --incremental=optimistic backup-to-image Optimistic Incremental image backup using history:last_backup: >mysqlbackup.exe --backup-image=<image file name > --backup-dir=<temporary directory name> \ --incremental-base=history:last_backup backup directory> \ --incremental=optimistic backup-to-image Performance Tests In our internal tests, we created a 1TB database where 10 tables were present, each 100 GB in size. We executed three iterations and observed the results. In the first iteration (A2), we modified only 1 table. In the second iteration (A3), we modified 2 tables. In the third iteration (A4), we modified 3 tables. We compared those times with performing a full backup and an incremental backup using the old algorithm. We found that theoretical gains (A2- 90%, A3 - 80%, A4 - 70%) almost match with the practical gains (A2- 89%, A3 - 79%, A4 - 68%). It means performance will be closer to default IB as the count of modified table increases, which is expected. For brevity, we use FB for full backup, IB for the old incremental backup algorithm, and OIB for the new optimistic incremental backup algorithm.   Tag Description Time taken (hh:mm:ss) % of Improvement [(Bi-Ai)/Bi*100 ] B1 FB (10 tables; 100GB per table) 2:13:07 - B2 IB (one table changed) 2:12:18 - B3 IB (two table changed ) 2:12:12 - B4 IB (three table changed) 2:12:11 - A1 FB (10 tables; 100GB per table) 2:13:07 - A2 OIB (one table changed ) 0:13:55 89 A3 OIB (two table changed ) 0:27:43 79 A4 OIB (three table changed) 0:42:13 68 Conclusion Optimistic incremental backup will have significant advantages and benefits over the older incremental backup algorithm, especially in cases where changes are limited to small set of  tables. We hope you'll give it a try and provide us feedback on how it works for your data. For more details and usage samples, please refer MySQL Enterprise Backup 4.1 User’s Guide .

MySQL Enterprise Backup Team is pleased to announce major improvements in incremental backup performance starting with release 4.1. Introduction The current incremental backup algorithm scans all the...

Improved Redo Log Copying During Backup

MySQL Enterprise Backup Team is pleased to announce redo log performanceimprovementsduring the backup operation starting with release 4.1.  Introduction  Asexplained in Redo Logging in InnoDB, redologs are written to the redo log files in a circular fashion. Unless the MySQLserver is idle, it continues to generate redo logs. MySQL Enterprise Backup (MEB)copies the redo logs from the redo log files to the ibbackup_logfile during a backupoperation. MEB copies the redo logs in order to ensure that it does not missany transaction while the physical backup is being done. MEB continues to copythe redo logs until it reads all the files from the data directory. If the redo log records are written fasterthan they can be processed by MEB, the backup operation fails with thefollowing error. "     Log scan was only able to reach <LSN1>,     but a checkpoint was at <LSN2>.     This means that the database server has overwritten     a part of the circular InnoDB log files before ibbackup     was able to read it.     To solve this problem either:     1) re-run the backup when the database has less load, or     2) re-configure the database with bigger InnoDB log files. " Wehave improved MEB so that this problem is unlikely to happen in most cases. Background Asexplained in Parallel backup, MEBuses different types of threads during an operation. The Following diagramdepicts the typical active threads that are working during a backup operationprior to the 4.1 release. Main thread This thread forks other child threads and monitors theirexecution. Reader threads Read the files in segments to be copied and pass them to theprocessor threads. Processor threads Do the required processing (for instance - compress, encryptand validate) on the segments and pass the processed segments to the writerthreads. Writer threads Write the segments to the target location. Progress thread Is forked only if the --show-progress option isspecified. It prints the overall progress made by MEB. Redo log thread Continues to copy the redo logs until notified by areader thread to stop once reader threads have finished reading the files.  While multiple readerthreads keep reading the files from the data directory, there is only one redolog thread that performs the following three tasks: Readsredo log segments of 1MB size each from redo log files in server.  If there is no redo log then go to sleep for10 milliseconds and retry to read more redo log after wake up Validatesthe redo log segments for unlikely problems (for instance – corruption and partialread) in the redo log segment.   Writesthe redo log segments to ibbackup_logfile in the backup. It isevident that the redo log thread does a lot of work, which could be split intomultiple threads much like the reader, processor, and writer threads.  The improvement In the4.1 release, we have split the one redo log thread into three different threadsas depicted in the diagram below. Reader redo log thread Reads redo log segments of 1 MB size each andpasses them to the Processor redo log thread.  MEB creates a 16 MB buffer queue to keep theseredo log segments in order to pass them among the three redo log threads. Ifthere is no redo log to read, then the thread sleep with a duration that variesbetween 10 milliseconds to 1 second based on the redo log generation pattern. Thisensures that the reader redo log thread does not wake up too early and wasteCPU cycles and to avoid a sleep duration that may cause the same problem which wehave fixed through this improvement. Processor redo log thread Validates the redo log segments, and passesthem to the writer redo log thread. Writer redo log thread: Writes the segments to the ibbackup_logfilein the backup. Test Results Weperformed a few tests in two different environments as follows.  In both environments, redo log files inserver were configured to be on a RAMDISK and backup was performed on a harddisk.  This was done to simulate the usecases where backups are usually performed in the slower disks compared to theserver is located.  This configurationensured that server could write the redo log files as fast as it could and wecould identify the latency among the Server writing the redo logs, MEB reading,processing and writing the same. Environment-01: ServerRepository Options: innodb_log_files_in_group= 2 innodb_log_file_size= 512 MB innodb_log_buffer_size= 16 MB Initialdatabase size = 687 GB After30 seconds, sysbench clients connect to the server and insert one million rows/pertables Numberof tables were the same as the number of clients. Redowrite rate = ~60 MB/s MEB  version Number of clients Backup status 4.1 100 Completed successfully 4.1 500 Completed successfully 4.1 1000 Completed successfully 4.0.3 2 Failed with redo log overwrite issue Wekept the redo log files size small so that the redo log file switch wouldhappen frequently. That may result in a case where MEB is not able to read asfast as the server was writing, but in the test, the case did not occur. Thatis, the threads completed every time using the three iterations mentionedabove.  In each iteration, there was approximately150GB of data in the ibbackup_logfile. Environment-02:  ServerRepository Options: innodb_log_files_in_group=6 innodb_log_file_size= 4 GB innodb_log_buffer_size= 16 MB Initialdatabase size = 687 GB After30 seconds, sysbench clients connect to the server and insert three million rows/pertables\ Numberof tables were same as number of clients. Redo writerate = ~90 MB/s MEB  version Number of clients Backup status 4.1 2000 Completed successfully 4.0.3 2 Failed with redo log overwrite issue Here,we kept the redo log files size larger to widen the gap between the serverwriting the redo log and MEB reading it from the redo log files.  We increased the number of clients this timeand noticed a higher redo write rate but backup completed without any problems.In this test, there was approximately 850GB of data in the ibbackup_logfile. Summary Wecould replicate the redo log overwrite issues easily with the older version ofMEB, but we are yet to see the problem in the 4.1 release.  Although it is still possible that the redolog overwrite error may happen, the probability of that happening has beenreduced drastically.  This probability couldbe further reduced if you perform an Optimistic Full Backups or anOptimistic Incremental Backups.  Try out the latest version and provide usfeedback on how it works for your environments.

MySQL Enterprise Backup Team is pleased to announce redo log performance improvements during the backup operation starting with release 4.1.  Introduction  As explained in Redo Logging in InnoDB, redolog...

MySQL Enterprise

MySQL Enterprise Monitor 3.2.6 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.2.6 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.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...

MySQL Enterprise

MySQL Enterprise Monitor 3.1.6 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.1.6 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.1 and 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.1.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...

MySQL Enterprise

MySQL Enterprise Monitor 3.3.2 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.3.2 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.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 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.2 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.5 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.2.5 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.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...

MySQL Cluster

MySQL Cluster 7.5 Is Now GA!

The MySQL team at Oracle are excited to announce the immediate availability of the MySQL Cluster 7.5.4 GA release!   The development focus has been on improving overall performance and ease of use, combined with improved SQL support and the introduction of read optimized and fully replicated tables, all of which allow for better support of a variety of use cases.  Use Case: Hadoop Performance Records Smashed by Hops and MySQL Cluster--delivers over 1.2 million operations per second The key enhancements delivered by MySQL Cluster 7.5 are summarized below: Improved Performance: Improvements in index/range scan performance and internal thread handling will allow for better use of existing hardware and a better overall user experience. Improved Ease-of-Use: Improved logging and SQL views offer greater insight into the current configuration, state, and general database operations, all of which helps to decrease maintenance and support costs, increasing your ability to resolve issues early enough that they don't become bigger user impacting problems. MySQL 5.7 Support: Developers can combine the InnoDB and MySQL Cluster NDB storage engines within a single database, using the very latest MySQL 5.7 release. This includes NDB support for the new native JSON data type, Generated Columns, and more! Increased Capacity: With support for 128TB+ data set sizes per data node you can better utilize the much bigger commodity machines available today, which increases your ability to scale-up, in addition to scaling out. Improved Read Scalability: You can mark all or individual tables as being read-optimized, thus effectively doubling your read throughput at the cost of slightly slower writes--a feature that is ideal for read-mostly tables. You can also declare some tables as being "global" or fully replicated--a feature that is ideal for lookup or fact tables which are relatively small, static, and often joined against (e.g. City, State, Product Type, etc.). These two features can greatly improve overall data locality--meaning that the data used for more complex queries (e.g. scans and joins) is local to a given data node, allowing you to avoid costly overhead associated with cross-node/cross-shard network communication and transaction management.  You can see the full MySQL Cluster 7.5 changelogs here, and the online manual here. If you're considering MySQL Cluster for a new application, please also see the Evaluation Guide. Download the source and binaries today and get started now!          

The MySQL team at Oracle are excited to announce the immediate availability of the MySQL Cluster 7.5.4 GA release!   The development focus has been on improving overall performance and ease of use,...

MySQL Enterprise

MySQL Enterprise Monitor 3.1.5 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.1.5 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.1 and 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.1.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...

MySQL Enterprise

MySQL Enterprise Monitor 3.3.1 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.3.1 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.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 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.1 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

MySQL Enterprise Monitor 3.3 Is now GA!

We're very happy to announce the general availability of the next release of MySQL Enterprise Monitor, version 3.3 (see the full changelog here). This is the best in class tool for monitoring and management of your MySQL assets, included with your MySQL Enterprise Edition subscription. What's New? Backup Dashboard -- The new Backup Dashboard brings deeper integration with MySQL Enterprise Backup and provides key visibility into critical backup activities, allowing you to easily ensure that your most valuable assets are protected against data loss. Visually monitor high level backup metrics for your entire MySQL topology or individual groups, and drill in to view all key metrics and details for individual backups of specific instances. Best Practice Advisors also help you ensure that your backup jobs are running as expected by proactively alerting you when potential problems are detected. Named Filters -- The UI now makes honing in on common problems even easier with support for "named filters". You can use these shortcuts to quickly select your preferred search criteria on views throughout the product, such as those for: Instances, Events, Query Analyzer, and the All Timeseries Graphs. We also now include some pre-defined filters for: "MySQL Instances using an EOL version", "Old MySQL Enterprise Monitor Agent Installations", "Currently Open Emergency Events", and more. In addition to the pre-defined filters, you can easily assign a name to your own favorite search conditions for easy reuse across sessions.  You can download MySQL Enterprise Monitor 3.3 from My Oracle Support or Oracle Software Delivery Cloud. You can find the complete documentation here. If you have any questions or encounter any problems, please let us know by opening a support ticket or filing a bug report. If you're not already a MySQL Enterprise customer, start your free 30 day trial today!  Thank you for using MySQL! 

We're very happy to announce the general availability of the next release of MySQL Enterprise Monitor, version 3.3 (see the full changelog here). This is the best in class tool for monitoring and...

MySQL

The #1 Open Source Database Now Available in Oracle Cloud

We're very excited to announce the General Availability of Oracle MySQL Cloud Service! Oracle MySQL Cloud Service allows you to accelerate innovation and to rapidly, securely and cost-effectively develop & deploy modern applications powered by the world’s most popular open source database. Built on the proven MySQL Enterprise Edition and powered by the Oracle Cloud, it provides a simple, automated, integrated and enterprise-ready cloud service that enables organizations to deliver MySQL-based applications globally at scale.Check out the Oracle MySQL Cloud Service video for a rapid overview: The only public cloud service integrating MySQL Enterprise Edition, Oracle MySQL Cloud Service empowers developers and ISVs with the most comprehensive MySQL offering in the cloud, including advanced features, tools and technical support to accelerate the time to market of new modern applications. Customers benefit from: Automated & Effective Management: Best-in-class Oracle management tools including web-based cloud tooling, MySQL Enterprise Backup, MySQL Enterprise Monitor, MySQL Query Analyzer, MySQL Workbench and integration with Oracle Enterprise Manager reduce administrative efforts and costs. Multi-layered Security: Enterprise-grade security features such as network access control, MySQL Enterprise Firewall, MySQL Enterprise Authentication, MySQL Enterprise Encryption, MySQL Enterprise Transparent Data Encryption and MySQL Enterprise Audit help customers achieve regulatory compliance and ensure data is protected against external attacks and misuse of information. Developer Enablement & Integrations: Pre-integration with Oracle Cloud Platform Application Development offerings such as Oracle Java Cloud Service and Oracle Application Container Cloud Service enables developers to quickly spin up a development environment. Pre-integration with Oracle Cloud Infrastructure gives them the choice to for example backup data to Oracle Storage Cloud. Global Scalability: Developers & ISVs can instantly scale their applications globally relying on Oracle Cloud. Automated scaling enables users to elastically scale compute and storage resources as well as MySQL replicas. The MySQL Thread Pool provides sustained performance and scalability facing ever increasing user, query and data loads. Hybrid Deployments: Relying on the exact same database platform and tools on premises and in the cloud allows customers to quickly and easily migrate existing applications to the cloud, move workloads between on-premises deployments and the cloud and architect hybrid deployments. Expert Technical Support: Technical support is provided directly by the MySQL experts, backed by the engineers that develop MySQL solutions, to solve customer’s most complex issues and help them make the most of their MySQL deployments. Additionally, Oracle Premier Support gives customers a one-stop support solution for both cloud infrastructure and MySQL related issues. Learn more and try it out now! Are you attending Oracle OpenWorld? Join the Oracle MySQL Cloud Service conference sessions and Hands-on Lab! Register now for our webinar on Wednesday, October 5 at 9.00 am PT! Check out the Oracle MySQL Cloud Services resources available to you including an eBook, datasheet and more...and, try the service for free right away! Digital disruptors rely on MySQL. The #1 Open Source Database in now available in the Oracle Cloud; it’s never been easier to rely on MySQL to drive your digital transformation initiatives and beat the competition. Innovate with Oracle MySQL Cloud Service!

We're very excited to announce the General Availability of Oracle MySQL Cloud Service! Oracle MySQL Cloud Service allows you to accelerate innovation and to rapidly, securely and cost-effectively...

MySQL Enterprise

MySQL Enterprise Monitor 3.3 GA has been released

We are very happy to announce the general availability of MySQL Enterprise Monitor, Version 3.3. 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’ll find information about what’s new in the change log. Highlights of this release 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. Choose "MySQL Database" as the Product Pack and 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 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 very happy to announce the general availability of MySQL Enterprise Monitor, Version 3.3. MySQL Enterprise Monitor is the best- in-class tool for monitoring and management of your MySQL assets...

MySQL Enterprise

MySQL Enterprise Monitor 3.0.27 has been released

MySQL Enterprise Monitor 3.0.27 is now available for download on theMy Oracle Support (MOS) web site.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 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.2 offers many significantimprovements over MEM 3.0 and 3.1 and we highly recommend that you considerupgrading. More information on MEM 3.2 is available here: What's new in MySQL Enterprise Monitor 3.2? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History More information on MySQL Enterprise and the Enterprise Monitor can befound here: http://www.mysql.com/products/enterprise/ http://www.mysql.com/products/enterprise/monitor.html http://www.mysql.com/products/enterprise/query.html http://forums.mysql.com/list.php?142 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. If you haven't looked at MEM recently, and especially MEM 3.2, pleasedo so now and let us know what you think. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team

MySQL Enterprise Monitor 3.0.27 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few enhancements and fixes a number of bugs.You can...

MySQL

Centreviews Relies on MySQL to Offer SaaS-based Finance and Accounting Services

Founded in St. Paul, Minnesota, API Outsourcing is atechnology company and provider of Centreviews Business Intelligence Suite, asimple, scalable, and secure solution for back office departments andprofessionals to automate their accounts payable, accounts receivable anddocument management processes. Manyenterprises adopt finance and accounting technologies not only to driveefficiency, improve business performance, and reduce operating costs, but evenmore importantly, to allow their resources to focus on core competencies inproducts and service offerings. Centreviews Business Intelligence Suite is available tocustomers or business partners on a SaaS only model or as a BPaaS model whereAPI provides outsourced labor to process accounts payable, accounts receivable,document management on its Centreviews Business Intelligence Suite. Both theSaaS and BPaaS offering enables customers to implement a technology basedsolution to automate processes with no capital investment and minimal ITresources. API’s customers can identify,resolve, and prevent problems with their accounts payables, accountsreceivables, and document management processes faster and easier than everbefore. The Centreviews Payables Solution allows customers to automate theirpayables processes from order to payment using the Centreviews workflowplatform to improve efficiency, visibility and controls. The Centreviews Receivables Solution allowscustomers to automate their remittance matching, cash application and deductionmanagement from order to cash using the workflow platform. This sophisticated, yet simple to use solution has helpednumerous companies both large and small including Sirius XM, Kohler, G&KServices, Randstad and NASDAQ to improve cash flow and profits. Business partners such as, Rosenthal andRosenthal, , Swiss Post Solutions and Commerce Bank have utilized Centreviewsto automate their customers processes toimprove their cash flow, increase business intelligence, enhancecustomer/vendor relationships, and reduce processing costs up to 60%. Business Challenges When API initially launched the Centreviews suite, itrequired a database that supported high-speed data inserts, was very secure,and performed well on the Linux operating system. Since many of Centreviews’customers are financial institutions, it’s essential that the products are incompliance with the latest regulations to safeguard sensitive financial data.Furthermore, this database had to be highly available, reliable, at a low cost,and scalable enough for future expansions. The MySQL Solution API chose MySQL as the database to host all the data in itsCentreviews product suite for the following reasons: MySQLcan perform large insert operations quickly MySQLhas great support and performance on Linux Lowtotal cost of ownership (TCO) MySQL has been the core of the Centreviews platform sincethe inception in 2005. It stores all the data to support invoice approvalworkflow and the associated documents to data archives and remittance processes.Even when the Centreviews suite evolved and required better support fortransactional operations, MySQL continued to perform well and met all therequirements from API. Today, MySQL serves over 10,000 Centreviews users dailyand processes over 100 million transactions annually. Replication Strategy MySQL replication is deployed in Centreviews for backup anddisaster recovery. One master server and two slave servers are co-located,while a third slave is at a separate site, dedicated for the purpose of maintaining99.9% uptime and for disaster recovery. One of the slaves in the same locationas the master is configured with replication to be a backup server in casethere’s any issue during recovery, while the other runs replication to take asnapshot of the master server. Oracle Premier Support for MySQL As more data and business processes are digitized andaccessed via mobile devices, the reliability and availability requirements haveelevated to a new level. Hundreds of companies are using Centreviews to accessor update some of its 24,000 tables and 1 TB of data, not only during regularbusiness hours, but also at 6am on Sunday morning when business activities wererarely seen previously. “More and more people now have to do work outside ofwork.” said Joe Hess, IT Manager at API. “Therefore, we have to be reliable andavailable.” To meet customer expectations of being available 24x7, APIupgraded Centreviews to the MySQL Enterprise Edition so that they can leveragethe advanced features and have direct access to expert MySQL supportprofessionals through Oracle Premier Support for MySQL. “The reality is thatwe’re in trouble when we need Oracle’s MySQL support team,” said Joe Mullen,Software Development Manager at API. “In all those stressful events, the MySQLsupport engineers have helped us get the business-critical systems back tofunction in a timely manner. It’s pretty awesome that I can’t think of any badexperience with the MySQL support team. “ API started to use MySQL since version 4, and have followedthe product releases closely and upgraded to newer versions. Currently,Centreviews is based on MySQL 5.6, and the IT team plans to upgrade to MySQL5.7 soon to take advantage of the latest features and performance improvements. “API deploys MySQL Enterprise Edition as the foundation ofour Centreviews product suites for its high performance, low cost, and greatsupport on Linux. We are very satisfied in its ability to deliver simple,scalable, and secure business solutions to our customers.” – Joe Mullen, Software Development Manager, API Outsourcing “More and more of Centreviews’ customers work outside ofregular business hours due to easy access to our SaaS solutions, which raisedthe availability requirement of our platform. MySQL Enterprise Edition offersthe performance, reliability, and availability we need, and has enabled API toprovide uninterrupted cloud-based financial and accounting services, especiallywith the access to expert MySQL support professionals through Oracle PremierSupport for MySQL.” – Joe Hess, IT manager, API Outsourcing

Founded in St. Paul, Minnesota, API Outsourcing is a technology company and provider of Centreviews Business Intelligence Suite, a simple, scalable, and secure solution for back office departments andp...

Backup and Restore of Encrypted Innodb Tables

MySQL Enterprise Backup(MEB) 4.0.2 is provided to support the backup and restore of Encrypted Innodb Tables. MySQL Transparent Data Encryption(TDE) is introduced in MySQL 5.7.12. This enables data-at-rest encryption by encrypting the physical files of the database. MySQL TDE uses a two-tier encryption key architecture, consisting of a master encryption key and tablespace keys. The InnoDB storage engine uses the keyring to store its key for tablespace encryption. These keyring solutions are available as plugins. To use this feature on server, one of the plugins need to be installed and configured on the server. Currently, MySQL Server Community Edition supports keyring_file plugin which stores keyring data in a file local to the server host.MySQL Server Enterprise Edition Edition supports keyring_file and keyring_okv, a plugin that uses Oracle Key Vault (OKV) for keyring backend storage.Thus the feature prevents malicious users to read data from tablespace files, database backups and disks.The use of MEB ensures that the Backup also has the innodb tables encrypted. This will secure the database "backups" also from hackers. When an InnoDB table is encrypted, a tablespace key is encrypted and stored in the tablespace header. When an application or authenticated user wants to access encrypted tablespace data, InnoDB uses a master encryption key to decrypt the tablespace key.On Server : Master encryption key + Innodb tablespace key = Encrypted Innodb tablespace keyWhen a backup is taken, MEB retrieves the Innodb tablespace key by using master key and decrypting the Encrypted Innodb tablespace key.In Backup : Innodb tablespace key + encrypt password(user key)= MEB re-encrypted Innodb tablespace key stored in a transfer file with .bkt extension per encrypted table.To install keyring_okv plugin:mysql> INSTALL PLUGIN keyring_okv SONAME 'keyring_okv.so'; mysql> SET @@global.keyring_okv_conf_dir= '/home/okv_enrollment_dir';To install keyring_file plugin:mysql> INSTALL PLUGIN keyring_file SONAME 'keyring_file.so'; mysql> SET @@global.keyring_file_data='/export/Data/keyring';MEB is part of an Enterprise Edition and hence designed to access both File and Oracle Key Vault to backup and restore MySQL data.Here is a brief overview on the steps to create tables with TDE and take a backup of the same with MEB:To create a table with Encryption enabled:mysql> CREATE DATABASE tde_db;mysql> USE tde_db;mysql> CREATE TABLE t_enc(C INT) ENCRYPTION="Y" ENGINE=INNODB;To take backup of the above server:mysqlbackup --user=root –password –backup-image=/home/admin/backups/my.mbi \--backup-dir=/home/admin/backup-tmp –encrypt-password= backup-to-imageSince MEB connects to the server, the plugin information is fetched from server, master key is read and MEB decrypts the tablespaces keys and re-encrypts the encryption keys of the tablespace with the encrypt password specified in "--encrypt-password" option while taking backup of the TDE tables. The resulting key is stored in the transfer file (.bkt) per tablespace. To restore a backup:mysqlbackup –defaults-file=/usr/mysql/my.cnf –backup-image=/home/admin/backup/my.mbi\ --backup-dir=/home/admin/restore-tmp –encrypt-password= \copy-back-and-apply-logMEB uses the encrypt-password to decrypt the encryption keys of the tablespace(s) to read and apply the logs. Then a normal restore operation is performed.MEB supports --keyring, --keyring-file-data/--keyring-conf-dir for providing keyring options as in MySQL Server.This way, the backup taken in my.mbi also has encrypted Innodb tables and hence the backup is secure.For more information on the support of this feature:http://dev.mysql.com/doc/mysql-enterprise-backup/4.0/en/meb-encrypted-innodb.htmlhttps://www.mysql.com/products/enterprise/tde.htmlhttps://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.htmlhttps://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.htmlhttps://www.mysql.com/news-and-events/web-seminars/mysql-security-transparent-data-encryption/

MySQL Enterprise Backup(MEB) 4.0.2 is provided to support the backup and restore of Encrypted Innodb Tables. MySQL Transparent Data Encryption(TDE) is introduced in MySQL 5.7.12. This...

MySQL Enterprise

MySQL Enterprise Monitor 3.2.4 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.2.4 is nowavailable for download on the My Oracle Support (MOS) web site. Itwill also be available via the Oracle Software Delivery Cloud in a few weeks.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. You will also find the binaries on the Oracle Software Delivery Cloud in a few weeks. Choose "MySQL Database" as the Product Pack and you will find the Enterprise Monitor along with other MySQL products. Version 3.2 adds significant replication monitoring enhancements.  Highlights include: Monitor and visualize any complex replication topology available in MySQL 5.7 using the completely revamped Replication Dashboard Intuitively monitor the current process list for any MySQL 5.6+ instances Monitor your new MySQL 5.7 instances and ensure that all of the new features and components are being used optimally You can see some highlights of MySQL Enterprise Monitor in the new demo 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.2 Change log Installation documentation Complete documentation Product information Frequently Asked Questions Download from My Oracle Support (available now) or the Oracle Software Delivery Cloud (in a week or two)

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

MySQL Enterprise

MySQL Enterprise Monitor 3.2.3 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.2.3 is nowavailable for download on the My Oracle Support (MOS) web site. Itwill also be available via the Oracle Software Delivery Cloud in a few weeks.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. You will also find the binaries on the Oracle Software Delivery Cloud in a few weeks. Choose "MySQL Database" as the Product Pack and you will find the Enterprise Monitor along with other MySQL products. Version 3.2 adds significant replication monitoring enhancements.  Highlights include: Monitor and visualize any complex replication topology available in MySQL 5.7 using the completely revamped Replication Dashboard Intuitively monitor the current process list for any MySQL 5.6+ instances Monitor your new MySQL 5.7 instances and ensure that all of the new features and components are being used optimally You can see some highlights of MySQL Enterprise Monitor in the new demo 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.2 Change log Installation documentation Complete documentation Product information Frequently Asked Questions Download from My Oracle Support (available now) or the Oracle Software Delivery Cloud (in a week or two)

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

MySQL

May 2016 - December 2016 => Events where you can find MySQL

As an update to the previous announcement, please find below list of events where you can find either MySQL Community team or MySQL experts at.  Please find more details at each conference below.  New events are marked with NEW! Any update to already announced event is marked as UPDATE!: July 2016: NEW! Debian Conference 2016, Cape Town, Africa (July 2-9, 2016)  MySQL Community team is going to support this conference financially even without staffing.  Open Source Conference Okinawa 2016, Japan (July 2, 2016) As tradition we are going to actively participate at this OS event, this time in Okinawa, Japan. There will be a MySQL booth in expo area as well as MySQL talk as follows: general topic "State of Dolphin" focusing more on "Document Store ant X Dev API" given by Ryusuke Kajiyama, the MySQL Sales Consulting Manager of Asia Pacific and Japan.  Texas Linux Fest, Austin, US (July 8-9, 2016) MySQL Community team is supporting this event and we are planning to have a MySQL booth. The schedule is not yet announced, but we are planning to have a MySQL talk as well. Please watch the organizers website for further updates. NEW! db tech showcase, Tokyo, Japan (July 13-15, 2016) MySQL team is going to attend the db tech showcase conference in Tokyo, Japan. This time we are going to have a huge presence by MySQL talks. The schedule can be found on the conference url. Please do not miss following talks: "RDBMS & NoSQL, Best of the booth worlds" by Shinya Sugiyama, the MySQL Sales Consultant, scheduled for Jul 13@13:00 "MySQL 5.7 - Inno DB" by Mikiya Okuno, the MySQL Support team, scheduled for Jul 14,@10:00 MySQL replication talk by Yoshiaki Yamasaki, the Senior Sales Consultant for Asia Pacific and Japan, scheduled for Jul 14@16:00 August 2016:  FrOSCon 2016, Sankt Augustin, Germany (August 20-21, 2016) As a tradition MySQL Community team is going to support this event with a MySQL expert on site. This year we are going to have a MySQL booth at the expo area as well as we will be submitting a MySQL talk. Please watch the organizers website for further updates. NEW! COSCUP 2016, Taiwan, Taipei (August 20-21, 2016) We are pleased to announce MySQL attendance at COSCUP 2016. This time there are 2 workshops approved one on Configuring MySQL HA architecture with Group Replication and Router and second one on Implementing and operation MySQL document store both given by Ivan Tu, the Principal Sales Consultant. There will be also at least one MySQL talk once that is approved. Please watch the organizers website for further information. September 2016:  NEW! Open Source Conference Enterprise, Tokyo, Japan (September 1, 2016) As a tradition we are going to be part of this OSC conference in Tokyo. You can find our MySQL staff at the booth in expo area and also you can talk to us after the MySQL session. Do not miss the talk! please watch the organizers website for the timing. UPDATE! SwanseaCon 2016, Swansea, UK (September 12-13, 2016) This year for the first time MySQL Community team is going to be part of this development conference. We have secured a Gold sponsorship with a MySQL booth in the expo area. Do not miss the opportunity to stop at our booth to talk to our MySQL members and attend our talk on "Scaling MySQL" given by David Stoke, the MySQL Community Manager, scheduled for September 13, 2016 @11:35am. PyCon Japan, Tokyo, Japan (September 20-22, 2016) MySQL is going to become a Silver sponsor of this conference with a MySQL booth in expo area. We are also planning to submit several talks and we strongly hope they will be approved. Please watch the organizers website for further updates. UPDATE! WebExpo, Prague Czech republic (September 23-24, 2016) We are happy to announce that MySQLis part of this technology conference in lovely Prague this year for the second time. We are planning to have a MySQL booth & talk on "MySQL 5.7 and MySQL Document Store" given by Johannes Schlueter, the Lead on Connector/Node.JS for MySQL. Please watch the organizers website for program updates & do not miss the opportunity to talk to our MySQL members at the booth!! PyCon India, New Delphi, India (September 23-25, 2016) Again this year we are planning to become a sponsor & partner of this PyCon in India with a MySQL booth and several talks. Please watch organizers website for further updates. October 2016: Ohio Linux Fest, Columbus, US (October 7-8, 2016) We are pleasure to announce that MySQL Community team is part of this show. We are going to have a MySQL booth at this show and MySQL talks as scheduled below: MySQL 5.7, scheduled on October 3@1-2pm MySQL's NoSQL, scheduled on Oct 3@3-4pm, both given by David Stokes, the MySQL Community Manager. NEW! PHP Brno, Brno, Czech Republic, (October 15, 2016) It's our pleasure to announce that MySQL Community team is going to be part of this PHP show in Brno. We are going to be Gold sponsor with at least one already approved talk on "MySQL 5.7 & JSON: New Opportunities for Developers" given by Frederic Descamps, the MySQL Community Manager. More talks will be hopefully approved once the schedule is set. Please watch organizers' website for further updates. November 2016: PHP.RUHR, Dortmund, Germany (November 10, 2016) MySQL team is going to be part of this show with a MySQL talk. Please watch organizers website for further updates.  DOAG 2016, Nuremberg, Germany (November 15-18, 2016) As a tradition we are again plan to attend the DOAG 2016 with MySQL talks as well as with MySQL representatives at the Oracle booth in expo area.  NEW! BuzzConf 2016, Phoenix Park, Ballan, VIC (November 25-27, 2016) Please find our MySQL representatives at this very special event called BuzzConf. It's partially an conference and partially festival. Come to have a lot of fun with organizers as well as do not miss to find our MySQL guys!  December 2016: NEW! IT Tage,  Frankfurt, Germany (December 12-15, 2016) We are pleased to announce that MySQL team is going to attend and talk at IT Tage this year. There will be 3 talks given by our MySQL experts: “MySQL as a Document Store: Best of Both Worlds” by Mario Beck, MySQL Sales Consulting Manger "MySQL Security talk" given by Carsten Thalheimer, the MySQL Sales Consultant. Third one is still TBC, please watch the organizers website for further updates. Come to hear our sessions and talk to our MySQL staff! We are looking for meeting you there! NEW! PHP Brazil 2016, Sao Paulo, Brazil (December 7-11, 2016) We are happy to announce MySQL Community team attendance at PHP Brazil this year. We are planning to have MySQL talks & MySQL booth in the expo area. Please find our staff there and watch organizers website for further updates.  There is more events planned for the second half of the 2016. We will keep you informed or you can check the MySQL Community platform for more information.

As an update to the previous announcement, please find below list of events where you can find either MySQL Community team or MySQL experts at.  Please find more details at each conference below.  New...

MySQL Enterprise

MySQL Enterprise Monitor 3.2.2 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.2.2 is nowavailable for download on the My Oracle Support (MOS) web site. Itwill also be available via the Oracle Software Delivery Cloud in a few weeks.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. You will also find the binaries on the Oracle Software Delivery Cloud in a few weeks. Choose "MySQL Database" as the Product Pack and you will find the Enterprise Monitor along with other MySQL products. Version 3.2 adds significant replication monitoring enhancements.  Highlights include: Monitor and visualize any complex replication topology available in MySQL 5.7 using the completely revamped Replication Dashboard Intuitively monitor the current process list for any MySQL 5.6+ instances Monitor your new MySQL 5.7 instances and ensure that all of the new features and components are being used optimally You can see some highlights of MySQL Enterprise Monitor in the new demo 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.2 Change log Installation documentation Complete documentation Product information Frequently Asked Questions Download from My Oracle Support (available now) or the Oracle Software Delivery Cloud (in a week or two)

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

MySQL

Myriad Group Connects Mobile Users Worldwide to Online Services with MySQL Cluster

Although smartphone penetration and 3G/4G coverage is increasing, the cost of data access is still beyond most people’s reach in emerging markets. The GSMA Foundation estimates (i) that only one-fifth of mobile connections in Sub-Saharian Africa are based on 3G, with 4G accounting for less than 1% of the connection base. The GSMA also estimates that "despite the shift in the region towards smartphones and mobile broadband, nearly 450 million connections will still be based on feature phones by 2020".Myriad Connect Division is working closely with Mobile Network Operators (MNOs) worldwide to provide "no data access users" innovative and compelling services, creating new opportunities for operators to achieve 100% market reach worldwide and generate new revenues. The company offers MNOs & B2B integrators a best-in-class Unstructured Supplementary Service Data (USSD) platform, allowing them to easily create and deploy compelling cost-saving mobile services and boost monetization. In essence, Myriad connects users to online services without mobile internet access. It gives them for example access to the most popular social networks and connected services.Myriad’s USSD+ platform is an enabler for a plethora of connected USSD applications in several domains, such as self-care portals and financial transactions, reaching all mobile users. Addressing for instance the challenge of low bank subscription rates in emerging markets, Myriad bridges the gap between mobile penetration and financial access, letting end-users check their bank account, make in-store transactions, bill payments and peer-to-peer money transfers, while conducting micro-credit and saving operations. Sub-Saharan Africa currently leads the world in the adoption of mobile money services, with more registered mobile money accounts than banks accounts in a number of countries. Challenges Deliver 5 nines (99,999%) availability for the mission critical USSD platform, including a disaster recovery capability ensuring transparent and instantaneous business continuity to MNOs in case of a natural disaster. Effectively serve tens of millions of subscribers per operator with a high performance and highly scalable database. Implement a solution trusted by Mobile Networks Operators, on which they would feel highly confident relying. Solution The Myriad R&D team evaluated several options and selected Oracle’s MySQL Cluster based on its characteristics and proven reputation in the communications industry. MySQL Cluster is an open source, ACID-compliant transactional database designed to deliver real-time in-memory performance and 99.999% availability. It powers the subscriber databases of major communications service providers and mobile networks with nearly a billion subscribers. Numerous operators actually recommended MySQL Cluster to Myriad. Not only did they trust the proven database but they also very much valued its open source nature, providing them with the desired flexibility and ease of integration with existing infrastructures. The flexibility of MySQL Cluster would furthermore allow Myriad to offer its solutions on-premises and in the cloud, while implementing different business models with its customers such as revenue sharing or "pay as you go" models. Myriad’s "all in one" premium USSD platform integrates a gateway and a portal available for both cloud-based and in-network environments: Myriad CellGate is a robust USSD gateway bridging the GSM/UMTS SS7 network to the IP world. The USSD portal CellCube provides mobile operators with an environment for launching successful interactive services. MySQL Cluster is implemented at the heart of the CellCube portal. MySQL Cluster powers Myriad’s Disaster Recovery Center Active-Active (DRC A/A): USSD platforms are implemented at physically distant sites with synchronous replication between them, providing geographic redundancy and a capability for immediate & automatic disaster recovery without human intervention.  With its active-active geographic replication, MySQL Cluster ensures that each site can actively serve read and write requests while maintaining data consistency across the clusters. On average the system processes 3000 messages per second for the largest MNOs and about 1000 messages per second for the mid-size ones. "Mobile Network Operators demand solutions exhibiting high performance & scalability as well as high availability, with geographic redundancy and transparent failover. MySQL Cluster squarely addresses those needs and enables us to offer a USSD platform featuring a world-class Disaster Recovery capability."Jean-Christophe Malinowski, Product & Marketing Director, Myriad Group.(i) https://gsmaintelligence.com/research/?file=721eb3d4b80a36451202d0473b3c4a63&download 

Although smartphone penetration and 3G/4G coverage is increasing, the cost of data access is still beyond most people’s reach in emerging markets. The GSMA Foundation estimates (i) that only one-fifth...

MySQL Enterprise

MySQL Enterprise Monitor 3.1.4 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.1.4 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.2 offers many significantimprovements over MEM 3.1 and we highly recommend that you considerupgrading. More information on MEM 3.2 is available here: What's new in MySQL Enterprise Monitor 3.2? 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.1.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...

Oracle

Integrated Cloud Applications & Platform Services