ReportonMySQLUserCamp, Bangaloreon20thJune, 2014_MySQL

ReportonMySQLUserCamp, Bangaloreon20thJune, 2014 MySQL User Camp Bangalore organized on 20th June, 2014 started as per plan. it was a good gathering. we got extends users from different companies like Flipkart, CTS, CGI, Yahoo, Onze Technologies, Webyog and few other startups. apart from this we also got 2 Mysql MERS this time from UID AadharProject managed by HCL.

Event started on its scheduled time with a welcome speechSrinivasarao Ravuri, (Senior Manager, Software Development at MySQL India). He thanked all the attendees for coming followed by a brief agenda and handed over the mic to the speakers for presentation.

It was followed by a talk on"MySQL 5.7 New Features and NoSQL support in MySQL"Sudipto Sahoo(Senior Engineer at MySQL India). He gave a good summary on the new features we have in Mysql 5.7 DMR 4.

Some of the key points he spoke about were

1. Improved InnoDB Online Alter Table

2. Parallel "Dirty Page" Flushing

3. Partitions-support for Transportable Tablespaces (TTS)

4. New Separate tablespace for temporary tables

5. Improved MDL locking

His presentations were equipped with good intuitive graphs where Sysbench Benchmarks were shown clearly showing good performance in Point Select. It was shown that Mysql 5.7 is 2X Faster than MySQL 5.6 Over 3X Faster than MySQL 5.5.

He finished his presentation with some good Examples on NoSQL implementation in Mysql.

For more details you can also refer to the5.7.1, 5.7.2, 5.7.3, 5.7.4blog posts writtenGeir hø ydalsvik.

Tea Break

After this we had a quick round of introduction from all the attendees followed by a small break for Tea and snacks already arranged at the venue. we had great variety of users from Mysql Enthusiast new to Mysql to Advanced Mysql DBA's. it was nice to see the users having open discussions with the Mysql Developers over cup of Tea.

The interactions went little longer than anticipated and users were requested to fall back for the next presentation.

We had the next presentation onMysql FabricBy (Narayanan Venkateswaran, Software Developer in Fabric Team ). it cocould be easily sensed that the users from both outside and within Mysql were really keen on the topic with the number of questions they had. all the questions were answered with good examples by the speaker. there were should use cases from users for which answers were given and for some we have work still in progress but best workarounds were suggested.

Some of the key points he spoke about were

1. Sharding Architecture

2. Managing a Sharded Database with some good examples.

3. MySQL Fabric Architecture

Event finished little late. Some Mysql Goodies were distributed to the Users and feedback forms were collected. However the discussion continued among the users little later too.

Feedback from attendees:

I was having a look at feedback forms and felt very good to see such a positive response. people also suggested topics to be supported Ded in next talk like Replication, Optimization and database tuning and best practices e. t. c. we wowould definitely take their suggestions into consideration.

Presentations

Mysql User Camp: 20-June-14: Mysql New features and NoSQL SupportFromMysql User Camp

Mysql User Camp: 20-June-14: Mysql FabricFromMysql User Camp

Photos and Videos:

Courtesy:

Sayantan Dutta(Senior Engineer at Mysql India)

Vin Perothas(Senior Engineer at Mysql India)

Follow us for more information on upcoming User Camp Events in Bangalore

Meetup:MySQL-User-Camp-Bangalore

Facebook Group:MySQL User Camp

Linked-in Group:MySQL India