Thursday May 23, 2013

MySQL at DrupalCamp, Goteborg - Sweden

DrupalCamp Conference is hold in Göteborg, Sweden on May 25, 2013.

MySQL is part of this show and I would like to invite you to our session on "Scalability and Availability with MySQL Replication" given by Sven Sandberg on Saturday-May 25, 2013 @ 13:45-14:25!

So, if you are close to Göteborg or attending this event, do not forget to come to listen Sven's talk!


Wednesday May 15, 2013

Upcoming EMEA Events with MySQL!

MySQL Community team is pleased to announce following events as the ones supported by us with a great MySQL staff attending. Find more details below (or at our Community wikis).

  • NoSQL Roadshow, Berlin Germany, May 16, 2013
  • Solutions Libres & Open Source, Paris, France, May 28-29, 2013
    • Talk: NoSQL & MySQL by Olivier Zemrag
    • Meet MySQL, Oracle Linux and VM team at our booth E40 in the main exhibition hall!
  • International PHP Conference, Berlin, Germany, June 4-5, 2013
  • DevConf 2013, Moscow, Russia, June 14-15, 2013
    • MySQL team has submitted about 5 talks, however the CfP is still open, so the accepted talks are not yet announced.
    • Lets meet our technical team at the MySQL booth!
  • OpenSUSE, Thessaloniki, Greece, July 18-22, 2013
    • You can find MySQL team at the MySQL booth as well as find several talks at openSUSE!
  • Froscon 2013, St. Augustin, Germany, August 24-25, 2013
    • Froscon is starting to be a tradition. Same as last year you can find our MySQL staff at the booth and also talking about MySQL news during the conference!
  • DrupalCon, Prague, Czech Republic, September 23-27, 2013
    • We are pleased to invite you to visit our MySQL booth as well as find several MySQL related talks we are planning to submit!

If you are interested, you can find the other conferences we are attending (above EMEA area) at our MySQL Community wikis. We are looking forward seeing and talking to you!

Tuesday Jul 24, 2012

Early Bird Registration Rate for MySQL Connect Ends on July 27

If you haven't already registered for MySQL Connect, now is the time to do it.

Looking for the right reason to attend? Here are the TOP THREE REASONS...

  • You'll get the chance to hear directly from users including PayPal, Verizon, Twitter, Facebook, Ticketmaster, Ning, Mozilla, CERN, Yahoo! and more, about best practices for deploying MySQL based solutions.
  • Don't miss this unique opportunity to meet the engineers developing and supporting the MySQL products, all in a single location. You'll be able to ask them all your questions and provide them feedback.
  • Acquire detailed knowledge about the latest innovations in InnoDB, the MySQL Optimizer, high availability strategies, performance and scalability, security improvements and numerous other topics. You'll hear it straight "from the horse's mouth" and from other MySQL experts in the ecosystem.

Early bird registration rate offering a saving of $500 ends this friday, July 27. Don't miss out...Register Now.

 

  • Wednesday May 23, 2012

    Thanks to the MySQL Connect Content Committee

    A big thanks goes out to everyone involved with the MySQL Connect Content Committee. We had a great response to the call for papers and realize that it took a considerable amount of time and effort to review the submitted sessions and BOFs. While Oracle employees aided with this effort, the MySQL Community deserves to be acknowledged for the time they took out of their busy schedules to help with our conference. Their input was invaluable to the support of the MySQL Community. Continued support such as this from the community is another reason that MySQL continues to be #1 open source database. We'll keep you posted as we finalize and publish the sessions, BoFs and HOLs for MySQL Connect.

    Thanks to the following committee members:

    MySQL Community:

    Oracle Employees:

    Tuesday Aug 10, 2010

    Seeking talks for the MySQL stream at the UKOUG Conference in Birmingham (2010-11-29/2010-12-01)

    Similar to events in the US and Germany, another large Oracle User Group organization is preparing for their annual conference and would like to set up a dedicated track of sessions about MySQL – this time it's the British UKOUG  which organizes the Conference Series Technology & E-Business Suite 2010.

    This annual user group event will offer a place to share knowledge and hear the latest information from key personnel about product development. This event is a technical event and not a marketing event and we'd like to encourage you to submit a MySQL-related talk!

    Some more information about this conference:

    • Dates: Monday 29th November – Wednesday 1st December
    • Location: The ICC, Birmingham
    • Size: Approximately 2000 attendees

    They have made an exception for the MySQL session stream and extended the call for papers deadline until Monday, 16th of August, 8:00 am (UK).

    If you are interested to speak about MySQL or you know somebody who would, please pass this information on and submit your proposal via this link as soon as possible. Once you've registered, the speaker loungeshould provide a button "Add abstract" that allows you to submit your talk.

    Thanks in advance! We look forward to your submission and another great conference.

    Monday Jun 21, 2010

    MySQL Sunday tracks at Oracle Open World 2010

    Oracle Open World is the conference of everything related to Oracle. This year edition, running from September 19th to 23rd, is expected to have more than 45,000 attendees, making it one of the biggest IT events worldwide.

    Traditionally, on the Sunday preceding the main event, there is a full day technical event, fueled by the user groups, independently from the company. These Sunday events are wildly popular. they are organized by users for users, and these sessions are usually fully attended.

    Now that MySQL is part of the Oracle portfolio, it is going to be part of the Oracle Open World show. In the spirit of the user groups events, there will be a MySQL Sunday event on Sunday afternoon, with four highly technical tracks, with well known speakers.

    The official schedule has all the details of every session (search for "stream/track" = "MySQL Sunday"), but doesn't offer a broad view of the event. For your convenience, here's the unofficial schedule with some useful information.

    Schedule

    Time
    Golden Gate B
    Golden Gate C1
    Golden Gate C2
    Golden Gate C3
    12.30 - 1.00
    opening keynote
    1.05 - 1.45
    Chris Schneider, Ning, MySQL High Availability
    Sarah SproehnleCloudera, Leveraging Hadoop to augment MySQL deployments
    Calvin Sun, OracleInnoDB Enhancements and Roadmap
    Lars Thalmann, Oracle, MySQL 5.5 replication enhancements
    1.50 - 2.30
    Philip Antoniades, Oracle, MySQL performance tuning best practices
    Thomas AndersonOracle,Performance and Scalability Enhancements in MySQL 5.5
    Ronald Bradford, 42SQL, MySQL Idiosyncrasies That Bite
    Sheeri Cabral, PalominoDB - Mike Frank, Oracle, For best results – Use daily:  MySQL Workbench - Design, Develop, and Admin
    2.30 - 2.45
    BREAK
    2.45 - 3.25
    Sarah Novotny, BlueGecko, You know databases, how hard can MySQL be?
    Giuseppe Maxia, Oracle, Boosting MySQL performance with partitioning
    Harrison Fisk, Facebook, Advanced MySQL replication techniques
    Jeff Freund, Clickability - Mark Matthews, Oracle, Efficient performance analysis and tuning with MySQL Enterprise Monitor
    3.30 - 4.10
    Mark Callaghan, Facebook, Success with MySQL
    Duleepa "Dups" Wijayawardhana,Empire Avenue, Insert MySQL INTO Startup
    Sheeri Cabral, PalominoDB, Proactively optimizating queries with EXPLAIN and mk-query-digest
    Andrew Morgan, Oracle - Mat Keep, Oracle, MySQL Cluster: The Leading Open Source, HA Database for Real-Time Services
    4.15 - 5.00
    Closing keynote

    Secure your seat.

    MySQL Sunday is open to all Oracle OpenWorld, JavaOne, and Oracle Develop attendees, including those with the value-priced Discover pass ($50 if you register by July 16). You will be asked if you are attending MySQL Sunday during the conference registration process. Register today.

    • When: Sunday, September 19
    • Where: Oracle OpenWorld, JavaOne, and Oracle Develop
      San Francisco Marriott Marquis

    Sessions.

    (Alphabetically by title)

    Advanced MySQL Replication techniques

    Harrison Fisk

    MySQL replication plays a critical role in most successful deployments of MySQL. Replication is relatively simple to setup, but takes much more mastery to optimize. Harrison will discuss some of the more advanced replication topologies, as well as practical tips and tricks designed to allow you to take your replication solution to the next level.


    Boosting MySQL performance with partitioning

    Giuseppe Maxia

    Databases always grow. With partitions, MySQL 5.1 becomes an efficient and easy to use data warehouse. This session explains with practical examples how to create and use MySQL partitions and how they will increase your application performance. This presentation also covers the recent additions from MySQL 5.5


    Efficient performance analysis and tuning with MySQL Enterprise Monitor

    Jeff Freund - Mark Matthews

    How do you know if your MySQL application is having performance issues? More importantly, how do you stop these performance issues before the application is put into production? In this session, learn how to use MySQL Enterprise Monitor to detect and notify you of existing performance robbing issues in production and how to use it in development and QA to prevent the problems from happening in the first place. Plus, you'll learn from Clickability, the leading on-demand Web Content Management solution provider, how the MySQL Enterprise Monitor and MySQL Query Analyzer are utilized to identify performance-tuning opportunities and to eliminate bottlenecks in a fraction of the time.


    For best results – Use daily: MySQL Workbench - Design, Develop, and Admin

    Sheeri Cabral - Mike Frank

    Why are so many DBAs and developers using MySQL Workbench every day? Just ask Sheeri Cabral - Oracle Ace Director and MySQL guru. See how Sheeri designs, develops and administers MySQL databases at PalominoDB using Workbench.

    PalominoDB provides remote services for MySQL and Oracle. Sheeri uses MySQL Workbench to manage distributed, replicated MySQL servers around the globe. Learn to leverage Workbench to connect, tunnel, script, control, configure, maintain, and manage your servers.

    Sheeri will share her Workbench snippets and show a few in action. Later you can download these snippets to improve your own productivity.

    Also on hand, Mike Frank, PM for Workbench will show how to extend Workbench with plug-ins.


    InnoDB Enhancements and Roadmap

    Calvin Sun

    Oracle's InnoDB is the most popular, reliable, and proven transactional storage engine for MySQL. InnoDB provides transactions, row-level locking, multi-version concurrency control for superior performance, and referential integrity and all four ANSI SQL transaction isolation levels to ensure the integrity of your database.

    In this session, you will learn InnoDB architecture and some innovative technologies in InnoDB for performance and data protection. You will also hear new performance-enhancing features to improve concurrency and scalability in InnoDB.


    MySQL High Availability

    Chris Schneider

    This talk will cover high availability techniques, sharding fundamentals, third party technologies and how to decrease the likelihood of system outages.

    • Hardware specifications to consider
    • Functionally Sharding your data
    • Why one would use various topologies such as a relay slave,master-master replication or circular replication for High Availability
    • Fail over mechanisms you should consider with replication (i.e. keepalived, heartbeat)
    • How to safely and reliably replicate over a WAN for disaster recovery
    • Mixing up storage engines (e.g., Leveraging the Blackhole engine)
    • Third party options for sharding your data

    Leveraging Hadoop to augment MySQL deployments

    Sarah Sproehnle

    When you're dealing with Petabytes of data, even MySQL starts to struggle. Hadoop can work alongside your current system, allowing you to perform complex analyses of your entire dataset. And with tools such as Sqoop and Hive, you can do all of that in an SQL-like language without needing to learn the complexities of the underlying MapReduce system.

    This talk will demonstrate how you can augment your existing MySQL deployments with Hadoop for batch processing of large amounts of data.

    In particular, these topics will be discussed:

    • Using Sqoop, an open-source tool for importing data from MySQL to Hadoop
    • Using Sqoop to export data from Hadoop back to MySQL
    • Using Hive, an SQL-like language, for doing reporting or ETL operations in Hadoop

    MySQL 5.5 replication enhancements

    Lars Thalmann

    To scale the business, many companies have large data centers with replicated MySQL servers. Some have hundreds or even thousands of MySQL servers that replicate data. In this talk Lars explains how to use MySQL Replication for scalability and high availability and we especially review the new MySQL 5.5 features that has been implemented to support and simplify maintenance of such installations. Features include replication heartbeating, semi-synchronous replication plugin, fsync tuning, and relay log corruption recovery.


    MySQL Cluster: The Leading Open Source, HA Database for Real-Time Services

    Andrew Morgan - Mat Keep

    MySQL Cluster has proven itself in mission critical telecoms and web services demanding real-time performance and HA in organizations including ALU, Cisco, Juniper, Telenor, UTStarcom & Zillow.com.

    This session will introduce the most recent MySQL Cluster 7.1 release including:

    • ndbinfo: presents real-time usage statistics, enabling developers and DBAs to monitor performance and optimize applications.
    • The MySQL Cluster Connector for Java: an easy-to-use, high performance native Java interface & OpenJPA plug-in that maps Java classes to tables stored in the MySQL Cluster database.

    Finally, Andrew and Mat will present some real-world case studies & explain some of the new capabilities that are currently in development.


    MySQL Idiosyncrasies That Bite

    Ronald Bradford

    While MySQL is a popular and widely used RDBMS, some default features and settings are very foreign in comparison with other commercial RDBMS products. In this discussion, Ronald Bradford will discuss some of the MySQL defaults including a non-transactional state, silent data truncations, date management, and transaction isolation options. These are all critical for data integrity and consistency. He will cover in-depth topics including SQL_MODE that saves the day. He will also cover character sets and collations and the best practices to ensure your UTF8 is stored and retrieved correctly.

    Insert MySQL INTO Startup

    Duleepa "Dups" Wijayawardhana

    When you picture a software startup today you no longer think of people in a garage creating a piece of software to be shipped on disks. It's all about data and global connectivity. Dups will lead you through the technical wonders of deciding to create a virtual economy and stock market and the decision to use MySQL. For Empire Avenue, MySQL is the foundation for a scalable, fast, web architecture which has allowed the company to create and deploy an application in record time with minimal cost. In the world of massive data and the web, you want applications that Scale Fast and Fail Fast. Those that scale and grab our imagination present new business opportunities, technical challenges and new economies. Welcome to the world of a Startup with MySQL.


    MySQL performance tuning best practices

    Philip Antoniades

    Learn how to do basic tuning of MySQL using only the tools that come with MySQL. See how to tune for connections, select the best storage engines, and learn how to analyze the key statistics of a MySQL server. This is a technical talk, but no MySQL experience is needed.

    Performance and Scalability Enhancements in MySQL 5.5

    Thomas Anderson

    In this technical, deep-dive talk, Thomas will explain the performance features added to MySQL Server and the InnoDB 1.1 Plugin. Including details on the scalability gains for multicore systems.


    Proactively optimizating queries with EXPLAIN and mk-query-digest

    Sheeri Cabral

    This session will cover how to systematically find each query in a system and how to approve or optimize each query using EXPLAIN. Participants do not need to know how to use EXPLAIN or mk-query-digest to attend this session. This methodology can be used to find queries before they become problems; it can also be used in parts for regular query optimization of known bad queries.


    Success with MySQL

    Mark Callaghan

    What determines whether a MySQL deployment will succeed? Some deployments are great while others are a constant source of trouble. The secret to success is you, not the MySQL RDBMS. Decisions that you make with respect to the database operations, server platform, schema and workload are critical. Mark will provide examples of decisions, both good and bad, that have a significant impact on the health of a MySQL deployment.


    You know databases, how hard can MySQL be?

    Sarah Novotny

    DBAs everywhere are being asked to support MySQL as a less costly alternative in Oracle's portfolio. Rest assured, (almost) everything you know about Oracle can be translated and applied to supporting MySQL with some new vocabulary and some smart starting points.

    This talk will touch on 5 things that are helpful to get right from the beginning. Through anecdotes, Sarah will spotlight some common pitfalls, share paths to a fix If you've inherited a running system and offer a vocabulary lesson so those who speak Oracle can start understanding MySQL.

    She'll be touching on user management and security, backups and replicas, monitoring, storage engine choices, and probably monitoring again (because it is that important).


    Speakers

    (Alphabetically by last name)

    Thomas Anderson

    Thomas is a performance software engineer at MySQL.


    Ronald Bradford

    Ronald is a RDBMS industry expert with 2 decades experience using MySQL, Oracle and Ingres.

    He presently provides MySQL and Drizzle consulting in the US and Europe for companies requiring assistance in performance analysis & tuning, web scalability, higher availability and for database architecture and design. Ronald has presented at many MySQL events including a number of presentations for Oracle resources. More information is available at MySQL for the Oracle DBA resources.

    Ronald is co author of the upcoming Wrox Press book ‘Expert PHP and MySQL’

    For more information and blog visit www.ronaldbradford.com and on Twitter Ronald writes at @RonaldBradford and @MySQLExpert


    Sheeri Cabral

    Sheeri K. Cabral has a master’s degree in computer science specializing in databases from Brandeis University. She has background as a systems administrator; has worked with Oracle, Sybase, DB2, Solaris, RedHat/Fedora, AIX, and HP-UX. Unstoppable as a volunteer and activist since age 14, Cabral founded and organizes the Boston, Massachusetts, USA, MySQL User group, and wrote the MySQL Administrator’s Bible.


    Mark Callaghan

    Mark leads the MySQL engineering team at Facebook. The team makes MySQL better for a large and critical deployment. The team writes about their work at http://facebook.com/mysqlatfacebook and publishes patches for MySQL at http://launchpad.net/mysqlatfacebook.

    He previously lead the MySQL engineering team at Google. The team published a popular patch for MySQL that included semi-sync replication, user and table monitoring via SHOW TABLE_STATISTICS and USER_STATISTICS, SMP and IO performance patches for InnoDB, global transaction IDs for replication, row-change logging, transactional replication and many bug fixes.

    Prior to Google Mark worked at Identity Engines, Oracle and Informix on database internals. Mark holds an M.S. degree in Computer Science from the University of Wisconsin-Madison. He occasionally writes about MySQL at http://mysqlha.blogspot.com.


    Harrison Fisk

    Harrison is part of the MySQL team at Facebook. Prior to working for Facebook, he was employed at MySQL AB (subsequently acquired by Sun and then Oracle) for 8 years as a senior principal MySQL support engineer, trainer, and consultant. He also is the co-author of a book, MySQL Clustering. Harrison holds a B.S. degree in Computer Science from University at Buffalo. His MySQL writings can also be found at http://harrison-fisk.blogspot.com.


    Mike Frank

    Mike Frank is a Senior Product Manager at Oracle focusing on MySQL - specifically Workbench, security, backup/recovery, platforms, and connectors. Prior to joining MySQL, Mike was Director of Technology at Idera. He was a Product Line Manager at PentaSafe Security Technologies which was acquired by NetIQ. His experience includes development and consulting in the fields of IT security, database design and management, e-business and trading systems.


    Jeff Freund

    Jeff Freund is the Founder and CEO of Clickability. With over 14 years of experience in the technology industry, Jeff works to expand Clickability’s leadership position in the Web Content Management category. Jeff is instrumental to Clickability’s rapid growth through the expansion of customer and partner initiatives, product innovation, and driving the market shift from traditional, on-premise technology to on-demand, cloud-based software and infrastructure. As Clickability's technical visionary and founding CTO, Jeff designed and deployed the first and only pure-play SaaS platform for the entire Web Content Management lifecycle. Under Jeff’s leadership, Clickability is responsible for the management and global deployment of over 500 websites worldwide for such companies as NetApp, BMC Software, PR Newswire (United Business Media), NBC, Cantor Fitzgerald, Smithsonian, Philly.com, and Eloqua, among others.


    Mat Keep

    Mat is part of the MySQL Cluster product team, responsible for product strategy and community development. In addition to driving adoption of MySQL Cluster into telecoms, web and enterprise industries, Mat is also involved in gathering user feedback and roadmap planning/ implementation with the engineering groups. Based out of the United Kingdom, Mat became part of MySQL in September 2008. Prior to that, Mat held a series of product management and development positions with Sun Microsystems and other vendors.


    Mark Matthews

    Mark Matthews is a member of the MySQL and Java communities since 1996, and joined MySQL as a developer in 2002. He is currently an architect for the MySQL Enterprise Monitor team at Oracle. Prior to joining the Enterprise Monitor Team, he was the original developer of MySQL's JDBC driver and still participates in the JDBC Experts Group. Before joining MySQL, Mark worked as a consultant helping deliver applications for the finance, healthcare, retail and cosmetics industries.


    Giuseppe Maxia

    Giuseppe Maxia, a.k.a. “The Data Charmer” is the MySQL community team lead at Oracle.

    He’s an active member of the MySQL community and long timer open source enthusiast. During the past 23 years he has worked in various IT related fields, with focus on databases, object oriented programming, system administration. Fluent in Italian, English, Perl, SQL, Lua, C, Bash, and good speaker of C++, French, Spanish, Java. Works in cyberspace, with a virtual team.


    Philip Antoniades

    Philip Antoniades has over 10 years of Web and Database development experience, and has been a MySQL Employee since 2003. He currently heads the MySQL Pre-sales Consulting teams for the Americas and Asia at Oracle. Philip lives in New York City.


    Andrew Morgan

    Andrew is the MySQL Product Manager responsible for High Availability Solutions - in particular MySQL Cluster and replication. He is based in United Kingdom and has worked for MySQL/Sun/Oracle since February 2009. Before joining MySQL he was responsible for delivering High Availability telecoms applications which is where he became exposed to MySQL Cluster - replacing proprietary and 3rd party databases. His primary roles in MySQL are working with engineers to make sure that MySQL Cluster & replication evolve to meet the needs of their users as well as spreading the word on the what people can get from these technologies. Andrew blogs regularly at www.clusterdb.com.


    Sarah Novotny

    Sarah’s a founding partner of Blue Gecko. She manages and is a senior administrator in the MySQL/ LAMP practice. Her company does remote administration and management of databases around the world.

    She additionally runs the Seattle meetups for LinuxChix, MySQL, and one focused on Opensource and general geeky socializing.


    Chris Schneider

    Chris is a certified MySQL professional with over 6 years in the MySQL community. He has designed, implemented and maintained small to large-scale MySQL installations. This includes building architectures from the ground up and improving on those that are currently in place while emphasizing scalability, performance and ease of use. A few of the companies he has contributed to are GoDaddy.com, Facebook.com, VMware, Virident, Plaxo.com and Ning.com.


    Sarah Sproehnle

    Sarah works for Cloudera, where she provides training on Hadoop, Hive, HBase and more. Prior to Cloudera, she worked for MySQL, teaching people database administration, high availability and performance tuning.


    Calvin Sun

    Calvin Sun is the development manager of the InnoDB group at Oracle. Prior to joining Oracle, he was the development manager of storage engines at MySQL. He has over ten years of database internals experience at Pervasive Software, MySQL and now Oracle. He has an M.S. degree in Computer Science from the University of Science and Technology of China.


    Lars Thalmann

    Dr. Lars Thalmann is the development manager for MySQL replication and backup. He is responsible for the strategy and development of these features and leads the corresponding engineering teams. Thalmann has worked with MySQL development since 2001, when he was a software developer working on MySQL Cluster. More recently, he has driven the creation and development of the MySQL backup feature, has guided the evolution of MySQL replication since 2004, and has been a key player in the development of MySQL Cluster replication. Thalmann holds a doctorate in Computer Science from Uppsala University, Sweden.


    Duleepa "Dups" Wijayawardhana

    Duleepa "Dups" Wijayawardhana is the CEO of the brand new web-based startup Empire Avenue based out of Edmonton Alberta, Canada. Prior to starting Empire Avenue, Dups worked for MySQL AB (later Sun Microsystems) and BioWare Corp. (later a subsidiary of Electronic Arts). At MySQL/Sun, Dups was the Community Relations Manager for North America as well as being on MySQL's Web Team. Dups has spoken at various events, and multiple universities on the topics of scaling and web site performance and is now reliving the front line fun of creating a social network and a virtual economy using MySQL, Memcached and whole host of new and old technology.

    Tuesday May 11, 2010

    MySQL track with free event at Kaleidoscope 2010

    The Oracle Development Tools Users Group (ODTUG) is holding its annual conference in Washington, DC, from June 27th to July 1st. The great news this year is that, at popular demand, there will be a MySQL track, organized and manned by the MySQL community.

    The even greater news is that, in addition to the general schedule, there are SUNDOWN SESSIONS

    Monday, June 28, 5:45 p.m. – 6:45 p.m. (reception immediately following)

    Join us on Monday, June 28 for a lively open discussion with Oracle MySQL ACE Directors. In addition to a specific session on MySQL, other Sundown Sessions will address: Middle Tier and Client-Side Development, Database Development, Hyperion, Essbase and BI, SOA and BPM, and Application Express. Drinks and snacks will be served during the sessions, followed by a reception for conference attendees and ACE Directors.

    The sundown sessions are free, and they don't require a registration, however the organizers are asking you provide your name and email for confirmation of numbers of attendees by filling in this form.

    As previously reported, there has been some love at first sight between independent Oracle User groups like the IOUG and the ODTUG (Oracle Development Tools Users Group). The end result was that a few skilled Oracle ACE Directors have taken the task of organizing the MySQL track within the conference, and the event is shaping up wuite nicely.

    You can see the lineup in Sheeri's blog and more info in Ronald's pages.

    This is a good chance for the MySQL community. Mingling with a wider organization of dedicated and skilled users is the starting point for widening one's business and to improve on best practices.

    UPDATE: Track details with discount code for MySQL attendees.

    Friday Jan 08, 2010

    Announcing the tracks of the "MySQL & Friends" Developer Room at FOSDEM 2010

    We are happy to announce the selected sessions for our "MySQL and Friends" developer room at FOSDEM 2010 in Brussels, Belgium. It will take place on Sunday, 7th of February from 9:00-17:00 in Room AW1.121.

    In total, we received 20 submissions from 15 speakers. We'd like to thank them very much for their great proposals!

    As we only have 12 speaking slots (20 mins each) available that day, we first needed to perform a selection process. Unfortunately there wasn't enough time to perform a full-blown voting process that involved the community at large. Since we didn't want to do this in a completely closed committee, we decided to involve all speakers that submitted a talk in this.

    After this voting process, the final candidates are (ordered by last name).

    Update: Mikael Ronström had to cancel his talk about "The new MySQL Thread Pool Design". Instead, Frédéric Descamps will talk about "Daily Maintenance of Big Databases/Tables".

    Speaker: David Axmark
    Title: Drizzle, A MySQL fork for the Web
    Abstract:

    The Drizzle project is building a database optimized for Cloud and Net applications. It is being designed for massive concurrency on modern multi-cpu/core architecture. The code is originally derived from MySQL. The code has been simplified by removing many of the original features (Stored procedures, triggers, views, some types etc). Other features are being moved from the core to plugins.

    Speaker: Piotr Biel
    Title: Multi-Master Replication Manager for MySQL
    Abstract:

    • Introduction to MySQL high availability with MMM
    • MMM architecture overview
    • pros and cons
    • examples of usage

    Speaker: Ronald Bradford
    Title: 10x performance improvements - A case study
    Abstract:

    Taking a client from a 700ms (at times 1-2 seconds) page load time to a consistent 60ms is a great success story for improvement in database performance.  In this presentation we will outline the steps taken and what can be applied to any website as one model to use in evaluation of your website.

    While part of a longer talk, we will be reviewing the highlights including:

    • Identify what is truly slow and high volume queries
    • Choosing the right indexes including unique indexes, concatenated and partical indexes
    • Choosing the right storage engines (MyISAM, InnoDB and Memory)
    • Removing load including synchronous/real-time queries, master load, locking and sharding
    • The best performance improvement for a SQL statement is to eliminate it
    • Quantifying improvements made

    The 10 Points are:

    1. Monitor, Monitor, Monitor
    2. Identify problem SQL
    3. Analyze problem SQL
    4. Indexes
    5. Offloading master load
    6. Improving SQL
    7. Storage engines
    8. Caching
    9. Sharding
    10. Handling database maintenance

    Bonus: Front end improvements

    Speaker: Kris Buytaert
    Title: MySQL HA overview
    Abstract:

    Database High Availability is often the core component to build a higly available infrastructure.

    This presentation will guide you trough the different options available with their advantages and disadvantages when choosing a method to setup a Highly available MySQL setup.

    We'll cover MySQL Cluster, MySQL DRBD, MultiMaster based HA setups and different others including a look at how to integrate them with the Operating System.

    Speaker: Stéphane Combaudon
    Title: Correcting replication data drift with Maatkit
    Abstract:

    Replication with MySQL is very easy to set up but also very easy to break. As soon as inconsistencies are introduced, the master and the slaves start being desynchronized - and most often, you have no way to be quickly and efficiently aware of the problem as MySQL offers no built-in mechanism to check data consistency between servers.

    Fortunately Maatkit has a neat solution with 2 nice scripts: mk-table-checksum, which is a tool to detect inconsistencies between a master and its slaves and mk-table-sync, which can correct automatically these problems detected with mk-table-checksum.

    This session will show you first how to use both tools depending on your replication setup (master-slaves or master-master) and then how to get the most from the multiple options that are available.

    Speaker: Marc Delisle
    Title: State of phpMyAdmin
    Abstract:

    phpMyAdmin is still evolving. New features in version 3.3 include changes tracking, replication support and database synchronization. Other lesser known features like data transformation and graphical relational manager will be covered as well.

    Speaker: Frédéric Descamps
    Title: Daily Maintenance of Big Databases/Tables
    Abstract:

    Explain the tools and best practices on how to daily maintain big databases/tables

    Speaker: Seppo Jaakola
    Title: Galera Replication for MySQL
    Abstract:

    This session will present the current state of Galera replication project. The presentation will contain elements like:

    • High level overview of Galera replication method
    • Contents of recent MySQL/Galera 0.7 release (fully open source)
    • Feedback and experiences from the field
    • New benchmark results
    • Short term road map, 0.8 development status

    Speaker: Vladimir Kolesnikov
    Title: Effective SSD for your Database - a PBXT Primer
    Abstract:

    In this session it will shown how to efficiently combine SSD and HDD storage for the benefit of performance of a MySQL database. Examples involving the PBXT storage engine will be demonstrated.

    Speaker: Giuseppe Maxia
    Title: Sharding for the masses
    Abstract:

    The Spider storage engine, a plugin for MySQL 5.1 and later, is an extension of partitioning. Using this engine, the user can deal transparently with multiple backends in the server layer. This means that the data is accessible from any application without code changes. This lecture will briefly introduce MySQL partitioning, and then shows how to create and use the Spider engine, with some practical examples. This talk covers the latest version of the Spider and the Vertical Partition engines, including the related technology of UDFs that come with the engines. Practical instructions of how to install and use these technologies will be provided during the session.

    Speaker: Kristian Nielsen
    Title: Beyond MySQL GA: patches, storage engines, forks, and pre-releases
    Abstract:

    There is more to the MySQL server than MySQL 5.1 GA.
    There are a lot of patches available that are not included in the official MySQL source tree. There are several new or enhanced storage engines. There are a handful of branches of the MySQL source code maintained by community members. And there are official MySQL milestone releases and snapshots. But to benefit from all of this, one has to know that they exist, and know how to use them.
    In my talk, I will first give an overview of what community enhancements of various kinds are available. I will then go through the options for using these enhancements, including using pre-build binaries from various sources, building from alternative source trees, building storage engine plugins, and patching upstream MySQL sources.
    Speaker: Mikael Ronström
    Title: The new MySQL thread pool design
    Abstract:
    This session will present a new thread pool design worked out in the last few months. The design will be presented together with its pros and possible cons. Benchmark data validating its relevance to users will also be presented.

    The main benefits of a thread pool design is that users can now have thousands of connections to the MySQL Server in a scalable manner. It also provides a performance which is more independent of the number of concurrently active connections than previously.

    Speaker: Geert Vanderkelen
    Title: MySQL and Python: an overview
    Abstract:

    There has been lots of chatter about other languages, but not much about Python. This talk will give an overview of what is available to connect to MySQL, and also introduce MySQL Connector/Python.

    These talks will now be put in the room schedule on the MySQL Forge Wiki. We look forward to having these sessions! If you happen to be a FOSDEM, please stop by at our Developer Room!

    Tuesday Jan 05, 2010

    Call for Papers for the "MySQL and Friends" Developer Room at FOSDEM 2010 extended until Wednesday, 6th

    A Happy New Year to all of you! About a month ago we posted our initial Call for Papers for the MySQL Developer Room at FOSDEM 2010 in Brussels, Belgium. We already received several great submissions and we'd like to thank the speakers who contributed their suggestions so far. But we would like to get some more!

    Therefore we decided to extend the deadline for a few more days: you can still submit your talk proposals until tomorrow (Wednesday, 6th)!

    So if you think you have an interesting MySQL-related topic to talk about, we'd like to hear about it! Thanks.

    Wednesday Dec 09, 2009

    Call for Papers for "MySQL and Friends" Developer Room at FOSDEM 2010 now open!

    FOSDEM 2010, the annual Free and Open Source Software Developers' European Meeting will take place again on February 6th and 7th in Brussels, Belgium. Next year they will celebrate their 10th anniversary (congratulations!) and we feel very honored and happy to announce that the organizers accepted our request for a developer room! They had to reject many proposals due to the great demand (there were 39 applications, but there are only 12 rooms available per day). Therefore we are glad to be among the excellent projects that will be present there.

    Our devroom is titled "MySQL and Friends" and will be available for sessions on Sunday, 7th from 09:00 - 17:00. It will be located in room AW1.121 and provides 81 seats, a video projector with VGA cable, and wireless Internet. As for the previous edition, we would like to set up a schedule of talks related to the MySQL server and the various projects that surround it. For the next time we will introduce a small change: each talk will last 20 (instead 45 minutes), plus 5 minutes of Q&A. This will give us 12 slots to fill up, plus a short opening keynote and a lunch break. This idea was inspired by Scott Berkun's great book "Confessions of a Public Speaker", which is a very entertaining and insightful read. If you are a frequent speaker at conferences and events, we highly recommend it.


    At this time, we would like to encourage and invite you to submit a talk! We are looking for covering a wide range of topics that attract both MySQL DBAs as well as application developers that work with MySQL as their database of choice. Are you developing a new storage engine or other plugin? Do you want to share your experiences and best practices in administering or deploying MySQL servers? Did you develop a new method to scale a MySQL setup? Let us and the audience know about it! You can submit your talk proposal via this submission form.

    The deadline for turning in your proposal is Sunday, 3rd of January, 2010, after which there will be a voting and rating period to identify the most interesting and attractive topics.

    We are looking forward to your ideas and suggestions! If you have any questions, please check our FOSDEM 2010 page on the MySQL Forge Wiki and feel free to get in touch with us directly or via our public mailing list. Thanks in advance!

    Monday Jun 29, 2009

    FrOSCon schedule draft published, CfP for OpenSQL Camp still open until July 19th!

    FrOSCon Logo

    FrOSCon, the Free and Open Source Conference, will take place on August 22nd and 23rd in Sankt Augustin, Germany. Sun Microsystems is a Gold Sponsor of the conference which takes place for the fourth time now. As for the previous years, the organizers have managed to arrange a great lineup of speakers and content. Presentations are held in both English and German — a first draft of the schedule is now available. However, it is still subject to change in some details, based on the feedback by the invited speakers.

    I am looking forward to this event, especially since we're helping to organize the OpenSQL Camp subconference there, which will take place in parallel (there also is a subconference about Java this time). By the way: if you've missed the deadline for submitting your database-related talk to FrOSCon, you can still submit your talk for OpenSQL Camp until July, 19th! We look forward to your submission.

    On the FrOSCon main tracks, there will be a number of MySQL-related talks as well as presentations about other Open Source projects sponsored and supported by Sun. Here's an excerpt from the schedule:

    In addition to that, there are numerous other very interesting talks related to Linux, Open Source, Cloud Computing and other topics. There usually is a nice social event (BBQ) and BOFs on Saturday evening and the overall atmosphere at FrOSCon is very relaxed and friendly. So don't miss this opportunity!

    Wednesday Mar 18, 2009

    MySQL QA at the Users Conference

    If you liked the article on QA before releasing, you may want to mark your calendars for this session at the MySQL Users Conference and Expo 2009, where Omer BarNir and Trim Pershad will tell everything about Software Quality and Testing in MySQL.

    Trim and Omer are veteran QA engineers, whose main goal is to improve the quality of MySQL products. Their session will tell you how the QA process evolved and what is going on right now.

    MySQL Conference & Expo 2009
    About

    Get the latest updates on products, technology, news, events, webcasts, customers and more.

    Twitter


    Facebook

    Search

    Archives
    « April 2014
    SunMonTueWedThuFriSat
      
    2
    5
    6
    9
    10
    11
    12
    13
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
       
           
    Today