A MySQL User Camp was held on 5th March 2020 at Oracle India Pvt Ltd, Kalyani Magnum Infotech Park, Bangalore, India. The attendees included developers, DBAs and trainers from Amex, Robert Bosch, Flipkart and others.
Sanjay Manwani, the Senior Director of MySQL Engineering India, presented an informative session which highlighted MySQL’s recent achievements like the DB of the Year award and the #1 ranking in the Most Popular DB with Developers StackOverflow survey. He explained new features in MySQL 8.0 which improve performance and usability and provide support for NoSQL, plus SQL features such as Window functions and the JSON Document Store. He also spoke about InnoDB Cluster, NDB Cluster and the MySQL Enterprise Edition. The presentation was concluded with an interesting preview of MySQL-as-a-Service on OCI.
The presentation was followed by a round of questions. These included questions on recommended MySQL upgrade paths and queries on how to migrate data from other databases(such as MongoDB) to MySQL. An attendee asked about performing partial replication in InnoDB Cluster, which Sanjay answered by explaining the Replicaset feature in the latest release of MySQL InnoDB Cluster.
The second presentation was from Arnab Ray from the MySQL Cluster Team, who presented a session on Metadata Synchronisation in MySQL Cluster. The session began with an introduction to MySQL Cluster, touched upon its various features such as 99.9999 availability and its shared-nothing architecture, and then began a deep-dive into the Metadata Synchronisation feature. Arnab started with the requirement of Metadata Synchronisation, explained the design of the feature and provided mysql client outputs to illustrate the behaviour in the various sync scenarios.
Rahul Sisondia from the MySQL Security Team then presented a how-to on securely setting up user accounts for apps. He described a common scenario with multiple apps accessing a single MySQL database and explained the vulnerabilities and risks of using a single privileged super-user. After introducing a set of security features including the MySQL SYSTEM_USER privilege and privilege revokes, he revisited the same scenario and showed how these security features can be used to overcome all the risks and vulnerabilities described previously, and set up a secure environment.
The User Camp concluded with an informal mingling session with refreshments where attendees discussed their specific issues and queries with MySQL Engineers.
We received positive feedback from the attendees as well as as topic suggestions for future User Camps. I would like to thank the user community for their participation in this event.
The recordings of the sessions have been uploaded to Youtube:
Sanjay – https://www.youtube.com/watch?v=_9MYIgzbn3w
Arnab – https://www.youtube.com/watch?v=QSxphORxLis
Rahul – https://youtube.com/watch?v=K1aGQe9ZnEM
For more information on on MySQL and the MySQL User Camps, you can find us at:
Facebook Group : MySQL User Camp
Google Group : bangalore-mysql-user-camp
LinkedIn Group : MySQL India