Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Dec 30, 2013

MongoDB in 2013 -- A Year in Review

It's again that time of the year. Analysts are spending oceans of words to predict the future, companies are making plans for the next year and people are resting and enjoying the break with their families. To me, this is the perfect time to reflect on my choices, the direction I'm headed to and consider if I still love what I do.

At the beginning of the year I decided to join MongoDB (formerly 10gen). The more I think about it, the more I realize I've been wrong. Yes, it's been the worst decision in my life not to join MongoDB when I was first offered the opportunity years ago. At that time an insightful friend asked me to consider the opportunity. At that time I didn't see what I see today.

I didn't see the database world changing so quickly. I didn't see lots of new applications being built on MongoDB and an ecosystem growing around the product. I couldn't glimpse the future of it becoming the leading NoSQL database. I couldn't understand the opportunity for Document Databases and for JSON emerging as a new standard for developers... or maybe I just preferred stability over challenge.

Time has passed since then and now I'm here. How was 2013 at MongoDB? Just amazing. As a good scribe I want to capture the key developments in the MongoDB world in a single page. This is an exercise that I'm doing since years and it gives an idea of the pace of growth, how well we communicate and the level of engagement of the ecosystem.

Company
Products
Clients
Partners
I want to say thank you to all partners, customers, colleagues and users who made this journey a great one. I'm looking forward to working with all of you even more in the years to come. PKPFZ79ENW4D

Apr 29, 2013

From Oracle to 10gen, The MongoDB Company

Those who are familiar with me know I've a dream.

5 years ago I decided to leave a systems integrator where I was doing great. Why? I wanted to be in a company with the same growth prospects that Oracle had in the 80s. I dreamed to be in the Oracle of 30 years ago and, as time travel wasn't affordable, I decided to join MySQL AB to help expand the business in Europe, the Middle East and Africa.
A few years later my dream came true, but in a slightly different sense. Sun acquired MySQL and was later swallowed by Oracle giving me the opportunity to join the company I wished I could have helped build.

Oracle is an amazing company and the MySQL family is full of energy and passion. The product is much better now and the opportunities are even more. MySQL is a dream that I've proudly been part of, but I decided to move on to a new adventure to keep the energy, commitment and passion that are part of me. That's why I decided to leave Oracle.

I've joined an outstanding company, with a leading solution and huge growth prospects. A company that could become the size of Oracle in less than 30 years. I'll be working with a product sitting at the intersection of Cloud, Mobile and Big Data. A document database that will shape the technology landscape in the years to come.

With an attractive partner program and a shiny new version of MongoDB just launched, it's the right time for me to join 10gen. I've accepted the exciting challenge of building the ecosystem and work with software, hardware, cloud, services and channel partners to make MongoDB the de-facto standard NoSQL database.

Interested in a partnership with 10gen? Let's talk! Reach out to me via LinkedIn or firstname.lastname at 10gen.com. ;)

My new dream starts today, and today is the time to say Thank You! to all friends, colleagues, customers and users who made the MySQL journey a great one. I look forward to working with all of you again in the future.

All the best!

Dec 21, 2012

2012, the Best Year for MySQL (...so far, but more to come)

It's the end of the year and, before the world ends ;-) , I feel the pressure to follow up on last year's article "2011, a great year for MySQL in Review". I'll adopt a similar format and mention things in context, covering products, marketing, momentum, etc. at a high level. I may have missed something and I hope my colleagues will contribute to the list.

I really do think it's been the best year for MySQL so far... well, at least since when I signed my contract with MySQL AB at the end of 2007. We're just at the beginning of our journey and I wish to the MySQL family, to our community and ecosystem an even better 2013!

Summary
With MySQL Cluster 7.2 GA, MySQL 5.6 Release Candidate and Cluster 7.3 DMR this is the start of something exceptional. These products are introducing long-awaited features and received very positive feedback from our community.

New windows tools joined the party to help customers migrate from Microsoft SQL Server and access MySQL from Excel. MySQL Cluster Manager has been updated and the new auto-installer saw the light of the day. We improved our Connectors, released new ones and delivered additional value to MySQL Enterprise Edition customers. We've also held our first ever MySQL Connect conference that's been a phenomenal success and the MySQL momentum is growing exponentially.

Products
MySQL 5.6 will be loved by developers, giving them more freedom to build next generation applications. With huge performance improvements, new NoSQL access and better replication, that's going to be the best MySQL release to date.
New options for High Availability are waiting to be deployed in your data centers to increase service levels and policy-based auditing will make your servers safer.
MySQL Cluster 7.2 went GA in February, initially delivering 1.2 Billion queries per minute, but then beating his own achievement and producing 1.1 Billion queries writes per minute. Adaptive Query Localization and better ease of use increased Cluster use cases. Leveraging our Not-Only SQL strategy, the latest previews introduced Node.JS access to provide developers further flexibility. Last but not least, Foreign Keys are now part of MySQL Cluster 7.3 DMR.

Case Studies
A lot of case studies can be found here, but let me pick some of the recent noteworthy ones:
  • MySQL Cluster Powers El Chavo from Playful Play, Latin America's Most Popular Facebook Game.
  • RedeHost Quadriples Backup Speed with MySQL Enterprise Edition
  • With Its MySQL Database-as-a-Service CERN Empowers Scientists
  • StayFriends Secures a Leading Position Among European Social Media Sites with Robust, High-Performance, Relational Database
  • Tilgin Improves Subscriber Device Management by Enabling Telecommunications Operators with Robust Database Solution
  • Verizon Wireless Supports its Mission-Critical Employee Portal with MySQL
  • A special mention goes to Twitter, who's handled a huge workload with MySQL during 2012 Presidential Elections
Events & Momentum
At the first ever MySQL Connect conference, Edward Screven presented enlightening statistics:
  • Over 15 Million Estimated Active Installations
  • Facebook: 163k Fans, +35% Yoy Growth
  • Twitter: 25k Followers, +67% Yoy Growth
  • MySQL Newsletter: 1,4m Subscribers, +20% YoY Growth
  • Events: Dozens Of Fully Booked Dev Days & Tech Tours
  • Awards: CRN, Linux Journal, PHP Architect...
Several of those numbers have grown since then, and MySQL once again got awarded the Linux Journal Reader’s Choice Award as Best Database for 2012.

People are downloading, tweeting, liking, adopting and blogging about MySQL at a great pace. Embedding MySQL has become a common practice. Adoption in the Cloud is skyrocketing and MySQL has emerged as the leading database, offered by the vast majority of cloud services providers. MySQL is also a key component of big data platforms, with Hadoop vendors estimating 80% of their deployments are integrated with MySQL. MySQL is everywhere!

To all MySQL users, customers, partners, colleagues, developers, advocates and aficionados: Thank you for another amazing year! Go MySQL!
Enhanced by Zemanta

Nov 19, 2012

Meeting the MySQL Team at UKOUG (ICC Birmingham, December 3-5 | 2012)

Come and see us...
If you're planning to attend UKOUG in Birmingham on Dec 3-5, here's your guide to know more about Oracle's MySQL.

There's a MySQL stream on Monday 5th and we've a great list of sessions, including:
I'd like also to mention Dr. David Harper, from the Wellcome Trust Sanger Institute, on Better Living Trough Metadata: Harnessing the Power of MySQL Information Schema.

Want to meet myself or my team at the UKOUG? Feel free to get in touch via LinkedIn or Twitter.

Want to come prepared? Here's what you can read beforehand:
Enhanced by Zemanta

Oct 15, 2012

MySQL Enterprise Monitor, my super powers and my life

Last week I had an enlightening experience. It may sound strange, but I found I have super powers... let me explain.

I had a meeting with a big customer of mine to show the value of MySQL Enterprise and Cluster CGE and to share with them the latest and greatest features available in our commercial offerings. During the discussion I said: "Imagine if your MySQL database has a problem at 3pm. Thanks to My Oracle Support and MySQL Enterprise Monitor you can quickly resolve your issues and restore the service".

MySQL Enterprise Monitor
Well, this is exactly what happened at 2.50pm... I missed the prophecy by just 10m and found I have super powers!

You could imagine how happy the customer was about my incredible abilities ;)
However, thanks to MySQL Enterprise Monitor, I'm still alive and I'm here to tell the story.

By using correlated graphs we've been able to filter all the events running at that time and quickly diagnose the problem. For those of you who're curious, they had an issue on their advertising network and, at that particular time, all the banners pointed to the portal bringing the number of active MySQL connections to 8000+ and putting a lot of pressure on the database. In the troubleshooting process we also found some regular spikes in the charts, probably related to batches they weren't aware of and they started an internal discussion to find the cause.

At the end I've learned a few things:
  • MySQL Enterprise Monitor is an amazing troubleshooting tool and could also be used to start a conversation between DBAs and DEVs
  • Never mention, during a customer visit, that the database might have a problem... or this could really happen
  • I've a debt of gratitude with the my colleagues in the MySQL Enterprise team at Oracle. Guys, the next time we meet, drinks are on me ;)
That's it... thanks for taking the time to read this life-changing story ;)
Enhanced by Zemanta

Jun 4, 2012

MySQL Events that I don't want to miss

Do you want to closely follow what MySQL is doing around the globe? We've created a Lanyrd guide just for that. It's curated by the MySQL Community, Marketing, Presales and Product Management teams and with some other contributions too.
Tomorrow we'll host the MySQL Innovation Day (in streaming too) and MySQL Connect is also quickly approaching. If you'd like showcase your products and services to the MySQL Community you can take advantage of the various sponsorship opportunities.

Stay tuned for the latest and greatest updates from the MySQL team at Oracle and from our vibrant community!
Enhanced by Zemanta

May 16, 2012

MySQL Cluster 7.2 -- Unlimited Possibilities

We've recently seen some great announcements of MySQL Cluster delivering amazing results for both selects and updates. The posts (see related articles below) are full of juicy technical details and proofs, but today I'd like to change the perspective a bit. Let's compare those figures with real-world data and imagine what could be done. Please note that I'm not using any scientific method here, just dreaming about the unlimited opportunities offered by MySQL Cluster today.

MySQL Cluster 7.2.7 -- 1B+ Writes per Minute
Cluster can deliver 1B+ selects per minute with 8 nodes and 1B+ updates per minute with 30 nodes.

Our planet is getting quite populated and interconnected. World population is 7B+ and 2B+ of us are using internet. Let's assume that, due to time-zones, only 1/3 of the total internet population is online at a given time (700M+) and that a single action generates one update and one select on the database.

What kind of services can we offer then?

With such scalability and performance, MySQL Cluster offers endless opportunities to develop something new that can support the exponential growth of the web and offer always-on services to everyone, for example:
  • Hellos from the world -- a website where everyone can say hello to the world, whenever they want. MySQL Cluster can handle the entire online population in less than 1 minute;
  • Let's shop together -- a global eCommerce website selling everything with 100% market share. If everyone would buy an item per minute, MySQL Cluster could easily fulfill the needs of the entire internet population with 30 nodes;
  • Like everything you like -- a like button that can be attached to everything in order to collect statistics on users' favorite things. MySQL Cluster could easily sustain the total online world assuming they'd like 1 thing per minute;
Furthermore, MySQL Cluster could handle updates from all of Zynga's 60M active daily users in 3 seconds or all of Facebook's 900M+ active users in less than a minute. All of that giving you ACID compliance and synchronous replication to ensure no data loss.

The Oracle MySQL engineering team did a great job with Cluster: let's build the next big thing with it!

Related articles


Jan 8, 2012

Changing Name and Improving Focus

You might have noticed that this blog changed name and URL. Instead of having one single blog for everything, I decided to split my blogging activities in two separate blogs.

If you're interested in MySQL, Oracle, Databases, Business Intelligence, Open Source, Cloud, etc. this is the place to be. Blog's new name is Data & Co.
A big "Thank you!" to David Stokes who moved all the planet.mysql.com references to the old blog to this new one.

On the other hand, if you'd like to read about communication, marketing, advertising, PR, soft skills, etc. feel free look at Publicime.  Please see the introduction of my new blog here. I've moved non-technical articles to this one to make sure my posts on Data & Co are exclusively technology-centric.

This will result in better focus for both blogs and I won't annoy you with topics you're not interested in. The old url is redirecting to Data & Co. by default.




Dec 29, 2011

2011, A great year for MySQL in review...

I see so many posts on what happened to company X, product Y and dream Z that I couldn't resist the temptation to summarize this great year for MySQL. At the end of 2010, Oracle did an announcement we were all waiting for: MySQL 5.5 is GA! Another year has passed since then and it's time to reflect on what has been done.

I know this is a long post. I tried to rewrite it at least 10 times to make it shorter, but I couldn't condense the list. Hence, I wrote a summary in the beginning for those who don't want to read it all.

I believe that 2011 was an exceptional year for MySQL and I really enjoy being part of this team. I wish all of us a lot of success and fun in the years to come!

Summary:
Oracle released many MySQL 5.6 and MySQL Cluster 7.2 DMRs accompanied by new versions of MySQL Enterprise Monitor, MySQL Enterprise BackupMySQL Workbench (and utilities), MySQL Proxy, MySQL Cluster Manager and Connectors.

The MySQL team unveiled new products like the MySQL Installer for Windows and Oracle VM Templates for MySQL. Besides, the MySQL Enterprise offering has been enriched with new commercial extensions. MySQL can now be leveraged as one of the Oracle data management solutions with new certifications and the integration with My Oracle Support increased the business value of customers' investment on Oracle technologies.

Additionally MySQL presented at major events across the world and won a few awards.

Aug 16, 2011

The Oracle's MySQL Sales Consulting Team is Hiring Across EMEA

Would you like to work with the biggest websites and social networks in the world? Do you want to support large enterprises with their database initiatives? Would you like to assist ISVs and OEMs providing the technology that powers their products?

In the MySQL Sales Consulting organization we do just that.

You’ll support MySQL partners, customers and prospects across EMEA, evangelize our products, assist marketing and cooperate with product management to shape the future of MySQL.

Sounds interesting? We're actively looking for senior professionals to join the team!
Feel free to reach me on LinkedIn for more information or have a look at the links below:
Please note that the location in some posts is wrong as Malaga is obviously neither in Austria nor in Switzerland. :)
Multiple locations for each position are possible and we'll fix the error soon.

Update: we've fixed the location typos now!

May 2, 2011

Live Event in Rome (May 19th) - Improve Performance and Scalability with the Latest from MySQL

MySQL, the world's most popular open source database, powers today's most demanding web sites and applications. With the acquisition of Sun, Oracle continued to invest and improve MySQL - to make MySQL a better MySQL.
Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools.

Register now for this seminar that will be held in Rome on the 19th of May. Agenda and location details are available on the event registration page.

Cost?
None, it’s a free event! But places are limited and the seminar is held on a first come first served basis, so register quickly!

Mar 16, 2011

MySQL, Oracle and their Marriage

During Collaborate 11, the biggest IOUG conference, I'll be presenting on MySQL, Oracle and their integration in a session called: "Integrating MySQL and Oracle: The Journey of a Transaction". 

Apart from the usual self-promotion about a speaking engagement, this time I'd like to make the session interactive. I'd love if you could add your comments on the challenges you find integrating the two products and on the hints you might want to share. I'll do all my best to address your concerns during my lecture, at the MySQL community dinner (see Sheri's post below) or in a blog post after the event.

See you in the sunny Florida!
Luca
Enhanced by Zemanta

Jan 12, 2011

Free Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL (EN,IT) - January 20, 2011

Online backup has been one of the most requested features for MySQL. With MySQL Enterprise Backup, developers and DBAs have tools they need to safely and rapidly backup and restore their databases. In this webinar we will go into the advantages of Hot "Online" backups. We will show how MySQL Enterprise Backup supports full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery, as well as saving both time and money.

In this Webinar you will learn:

  • Backup Strategies & Methods
  • Comparison of backup types for MySQL
  • MySQL Enterprise Backup: Features
  • MySQL Enterprise Backup Performance
  • MySQL Enterprise Backup: Architecture
  • MySQL Enterprise Backup: How it Works
  • MySQL Enterprise Backup: Script Examples
Who
Mike Frank and Alex Roedling for the English session.
Luca Olivari for the Italian one.

When
Thursday, January 20, 2011: 09:00 Pacific time (English)
Thursday, January 20, 2011: 10:00 Central European time (Italian)

Register now: English, Italian.
On demand French and German versions available as well.
Enhanced by Zemanta

Nov 23, 2010

Webinar: Designing MySQL Databases (Italian) - Nov, 25@10am CET

We already have more that 500 registrants for this MySQL web seminar. Join us and the crowd to learn the design dos and don'ts for MySQL. We will show you how to design, forward and reverse engineer databases including discussions on datatypes, indexes, and foreign keys for various application scenarios.

In this technical presentation, we will cover:
  • MySQL design basics
    • Data Modeling Basics
      • Physical and Logical Models
      • "Dos" and "Don'ts"
    • How to design MySQL for your specific application
      • Datatypes
      • Indexes
      • Foreign keys
  • MySQL Workbench
    • Design
      • Reverse Engineering
      • Design
      • Deploy (Forward Engineer)
      • Maintain (Synchronize)
    • Develop
      • SQL Coding

Whether you are developing commercial applications, Web-based applications, or in-house applications, and whether you are a novice or more advanced, you will benefit from this presentation.

When
Thursday, November 25th, 2010 at 10am CET


How

To register for this free web seminar please click here.
Enhanced by Zemanta

Sep 20, 2010

Oracle's MySQL - What's New? Live event in Rome on Oct, 7

As a follow up of this post I'd like to inform all the readers that the What's New event will be replicated in Rome on Oct, 7.

Join us at this live event to better understand what’s new with MySQL. You will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle’s investment in MySQL aiming to make it even a better MySQL.

In particular the following topics will be discussed:
  • Oracle’s MySQL Strategy
  • What’s New for:
    • The MySQL Server
    • MySQL Cluster
    • MySQL Enterprise
    • MySQL Workbench
Attendance is free, but you’ll need to register in advance. Seats are limited, register today!

When:

Sep 2, 2010

Oracle's MySQL - What's New? Live event in Milan on Sept, 28

Join us at this live event in Milan to better understand what’s new with MySQL. You will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle’s investment in MySQL aiming to make it even a better MySQL.

In particular the following topics will be discussed:
  • Oracle’s MySQL Strategy
  • What’s New for:
    • The MySQL Server
    • MySQL Cluster
    • MySQL Enterprise
    • MySQL Workbench
Stay tuned because we are organizing a similar event in Rome that will be announced soon. Attendance is free, but you’ll need to register in advance. Seats are limited, register today!

When:
Enhanced by Zemanta

Aug 13, 2010

Upcoming Webinar: Scaling Web Services with MySQL Cluster (IT)

On the 9th of September at 10am CET I will present in Italian a Webinar titled: "Scaling Web Services with MySQL Cluster". You can register here.

This is a summary of the english webinar series in two parts that are now available on-demand:
Content

There are two common choices to power web applications: MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web. The MEMORY storage engine has been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management.

However if you have web services that are update-intensive, demanding real-time responsiveness and continuous availability or if your services evolve to support more users, the scalability and availability demands can start to exceed the capabilities of these two approaches.

The MySQL Cluster datbase, which itself can be implemented as a MySQL storage engine, is a viable alternative to address increased web service demands. MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency, higher levels of scalability and database functionality and 99.999% availability.

This webinar will discuss the use-cases for all three approaches, and provide an insight into how MySQL Cluster is enabling users to scale their update-intensive web services.

When
  • Thursday, September 9, 2010: 10:00 CET
EAVB_NEYWAQLUNW

Jun 4, 2010

What's New in the MySQL Enterprise Spring 2010 Release

The MySQL Enterprise Spring 2010 Release includes key improvements designed to help you proactively optimize MySQL performance and identify potential issues before they can become costly outages or slowdowns. In this webinar we will explore the new features of the MySQL Enterprise Monitor 2.2 that are designed to save DBAs and Developers time and effort in keeping MySQL systems running at the highest levels of security, performance and availability. Join us and learn about:
  • How the MySQL Connectors can now be used to collect, aggregate and monitor MySQL query performance data
  • How to quickly identify which queries are performing full table scans
  • How to isolate your worst performing queries based on total execution counts, time, data returned, date/time, query content, query type, and more
  • How to identify and drill down into line-level source code for specific query executions
  • New LDAP authentication model
  • New Read Only User
  • New Auto-Closing Events
  • New MySQL Support Diagnostic Reports
  • New Custom Rule/Graph Import and Export options
  • New Faster Purging of Repository Data
  • New Installation Options
  • And more!
Here are the links for the various localized webinars:

May 31, 2010

Wearing a Red Tie (or a T-Shirt if you prefer).

Starting from tomorrow (1st of June) I will officially become an Oracle employee. It is quite funny how many companies you can change without even applying for another job. ;-)
I've been hired by MySQL in the beginning of 2008, a few months later it has been acquired by Sun and after about a year we've been acquired again, this time by Oracle.

I personally consider this a new beginning and I join Oracle with a lot of enthusiasm. After all I'm now part of a company that has a huge set of products and technologies and it is like a playground for me.

I'm afraid I've not blogged frequently in these months, but I plan to write more and more in the future. This short post is just to wish good luck to all the Dolphins who have joined Oracle and all those who are swimming in a different ocean.

Go MySQL! Go Oracle!

Feb 12, 2010

MySQL and Java - The World's Most Popular Development Platforms

On Feb 10, 2010 we've held an event in Milan, explaining why MySQL and Java are the most popular development platforms.

Our annual MySQL User Survey conducted in early 2009 showed that 57%  of those surveyed use Java to develop their MySQL applications.

My speech was all about MySQL and its usage from Java applications with various connectors. I explained the capabilities of Connector/J and Connector/MXJ, you can see relevant on demand webinars here.

After that, I moved to the usage of MySQL Cluster from Java applications, elucidating the three types of connectivity available. If you want to see for yourself then take a look at the blog post by my colleague Bernhard or hurry up and register for the upcoming webinars.

If you are a Java developer, don't forget to look at the Java page on our website alongside the developer portal.

Thanks for your participation and see you soon,
Luca