Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447
Edward Screven, Oracle's Chief Corporate Architect, discussed the current and future state of MySQL in his keynote at the MySQL Conference & Expo.
The Oracle Development Tools Users Group (ODTUG) is holding its annual conference in Washington, DC, from June 27th to July 1st. By popular demand, there will be a MySQL track organized by the MySQL community. The event includes free sessions. Join us and meet with the MySQL experts!
MySQL enables up-and-coming Web 2.0 sites like Wikipedia, Facebook and Twitter, as well as established web properties like Craigslist, Google and Yahoo!, to scale out and meet the ever-increasing volume of users, transactions and data.
You will gain an understanding of how MySQL can be used in conjunction with other open source components to deliver low-cost, reliable, scalable, high performance Web 2.0 applications.
The MySQL 5.1 server continues to move MySQL ahead in its mission to make sophisticated database management available and affordable to all. With the release of MySQL 5.1, the MySQL database server provides more enterprise-caliber enhancements that greatly assist those wanting to use MySQL for:
that requires little attention and continually services anywhere from one to thousands of user requests per second.
In this white paper learn the fundamentals of how to design and select the proper components for a successful MySQL Cluster evaluation. We explore hardware, networking and software requirements, and work through basic functional testing and evaluation best practices.
Uppsala Clinical Research Center, UCR, is a national center of competence for healthcare quality registries in Sweden, and is an independent unit under Uppsala University Hospital and the Disciplinary Domain of Medicine and Pharmacy at the University of Uppsala. UCR's National Quality Registries include treatment and outcome data based on all hospital patients in Sweden, and is used by thousands of doctors, nurses, medical secretaries and representatives within county councils.
ContactLab is a leading Italian provider of digital direct marketing services, with offices in Milan, Madrid, Paris, London and Munich. ContactLab chose to subscribe to MySQL Enterprise to help support the security, availability and scalability of its market-leading platform. Today ContactLab manages more than 3 Terabytes of data with MySQL for sending, tracking and analyzing hundreds of millions of messages every month.
Tuesday, May 18, 2010 - 9:00am PT
Among the top 500 most visited sites on the Internet, myLifetime.com, which is built on Drupal, receives 6.5 million visitors (3.6 million unique) and 50 million page views per month. Because of online campaigns, and the popularity of associated television shows, the Lifetime family of sites must be prepared to accommodate significant volume spikes.
Nathan Potter, VP of Digital Media Technology at myLifetime.com, cites show-related volume spikes of 150,000 page views per hour as within the normal range of traffic. In this webinar, Nathan will cover the architecture they've developed for scalability as well as the techniques they've used for optimizing their site, including MySQL, for scalability and performance.
Thursday, May 20, 2010 - 9:00am PT
Join Jimmy Guerrero and Mike Frank of Oracle for an overview of MySQL's internal architecture including storage engines, security and datatypes. Also covered will be replication, migration strategies, tools and product comparisons to SQL Server, SQL Server Express and Access. If you are a SQL Server DBA interested in learning how to leverage your current knowledge against MySQL, this webinar is for you.
Thursday, May 27, 2010 - 9:00am PT
Join us for Part 1 of the "MySQL Essentials" webinar series with Jimmy Guerrero and Mike Frank from the MySQL Product Management group at Oracle. In this presentation we'll demonstrate how to setup an environment for building MySQL from source on Windows and Linux, leveraging free or open source tools in the build environment. We'll also examine the various MySQL downloads, packages, distributions and installers available to get up and running in 15 minutes or less. Finally, we'll cover the initial configuration of MySQL including memory allocation, connection limits, security and other options.
MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Oracle employees. Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.
MySQL Community Server 5.1.46, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.46 is recommended for use on production systems.
We're announcing the first Release Candidate of MySQL Workbench. MySQL Workbench 5.2 RC provides:
If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench.
MySQL Connector/Net 6.1.4, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against MySQL servers ranging from version 4.1 to 5.5!
Memached is an open-source, distributed memory caching system designed to tackle today's web-scale performance and scalability challenges. Many of the largest and most heavily trafficked web properties on the Internet like Facebook, Fotolog, YouTube, Mixi.jp, Yahoo, and Wikipedia deploy Memcached and MySQL to satisfy the demands of millions of users and billions of page views every month. By integrating a caching tier into their web-scale architectures, these organizations have improved their application performance while minimizing database load.
Many ISVs and OEMs have seen that MySQL Embedded Server's superior scalability -- in both concurrent userload and overall data volume, cost-savings, platform freedom, and feature set combine to provide a compelling business case to move some or all of their Access applications to MySQL Embedded Server. This paper provides insight into what is needed when considering a move from Microsoft Access to MySQL Embedded Server and presents a number of options that ease the transition.
This paper looks at the various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how the MySQL Workbench product from MySQL can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.
This tutorial will show you the essential steps to build and install the new, elegant MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database. Application developers who are new to MySQL Connector/C++ but not to C++ programming and the MySQL database, are the target audience of this tutorial. Because the focus is on database connectivity from a C++ application, this document assumes that some kind of MySQL database is already up and accessible from the client machine.
Launched in 1998, Promovacances is a brand of the Karavel group, the leading provider of vacation packages online in France. Promovacances.com gets about 40 million individual visitors per year and 250,000 per day during the high season.
The MySQL Enterprise Platinum subscription gives Karavel access to 24/7 technical support as well as to the MySQL Enterprise Monitor including the new MySQL Query Analyzer.
Aito Technologies has chosen to employ the MySQL Embedded Database Server in order to successfully analyze up to billions of daily phone calls, text messages and mobile data sessions.
With reference clients such as Nokia, TDC, Blyk, Elisa and Muxlim, Aito's daily traffic load entails several terabytes of data. Consequently, the vendor's application has strict requirements for high database performance and scalability on a multiprocessor architecture.
The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.
Yesterday at the MySQL Conference, I spent time in a few sessions discussing the performance enhancements in the MySQL 5.5.3 and 5.5.4 milestone releases. What I saw made me very, very happy. In fact, the timing couldn't be better.
While I was researching for my partitions tutorial, I came across two hidden problems, which may happen often, but are somehow difficult to detect and even more difficult to fix, unless you know what's going on, and why. I presented both cases during my tutorial, but there were no pictures to convey the mechanics of the problem. Here is the full story.
Did you ever have the need to find the maximum value of an integer in MySQL? Yeah, me neither. Anyway, some people seem to need this, and this is what I came up with.
SPJ (preview, not production ready) is a new feature allowing some types of JOINs to be pushed down and executed inside the data nodes! This allows for, in many cases, much faster JOIN execution.
At the 2010 MySQL User Conference, Jonas Oreland presented on the work he's been doing on improving the performance of joins when using MySQL Cluster - the slides are available for download. While not ready for production systems, a preview version is available for you to try out. The purpose of this blog is to step through testing an example query as well as presenting the results.
Geert JM Vanderkelen
Last week, my colleague Massimo and I discussed how to handle big result sets coming from MySQL in Python. The problem is that MySQL doesn't support server-side cursors, so you need to select everything and then read it. You can do it either buffered or not. MySQL Connector/Python defaults to non-buffered, meaning that you need to fetch all rows after issuing a SELECT statement. You can also turn on the buffering, mimicking what MySQL for Python (MySQLdb) does.
Collaborate10 is the conference of the Oracle Users Groups. I had been asked to participate with a few talks on MySQL, and I was curious of meeting, for me, a new organization. I prepared three talks, one introduction to MySQL and two advanced ones, and thus equipped I ventured along the immense corridors of the Mandalay Bay convention center.
In a period of two weeks, I had two cases with the exact same symptoms. Database users were experiencing low responsiveness. DBAs were seeing locks occurring on seemingly normal tables. In particular, looking at Innotop, it seemed that INSERTs were causing the locks.
Huge performance improvement has come with MySQL 5.5.4, and looking at the following picture it's very easy to see why.
Some days ago I was working in a vocabulary game and dictionary. The dictionary contains 1,10,000 words and meanings. I developed a vocabulary game where I had to randomly choose 10 words out of 1,10,000 dataset. Here I'm describing the possible solutions for this problem and which solution I used.
Whether you're working with MySQL, MySQL Cluster, or any other RDBMS, every database with a requirement for persistent data should always have a backup. As a Production DBA you're the insurance policy to safeguard the data. Bad things do happen. Backups are your safety net to ensure you always have a way to recover should the worst happen and the database becomes irreparable.
Today evening one of my friend asked me in the IM to look into one of his production server where a query was taking about 11 seconds to run on 20 million row table, even though the query is using the right index and the plan as shown below.
Tuesday, May 25, 2010 - 9:00am PT
Join MySQL and Java experts, Mark Matthews and Todd Farmer, for an encore performance of their MySQL 2010 User Conference Session. In this technical presentation they will explain how to use the scalability and reliability features that are built into MySQL Connector/J to do
Tuesday, May 25, 2010 - 10:00 CET/8:00 UTC
MySQL Replication is widely used to deploy scalable and highly available database architecture. In this presentation we will demonstrate how to get started with configuring MySQL Replication. We will also cover how replication works, supported replication topologies and how to perform management and administration tasks.
Wednesday, May 26, 2010 - 10:00 CET/8:00 UTC
You will get expert insight and learn best practices from the experts at MySQL to help you improve performance! We will discuss the main performance optimization opportunities, including schema optimization, server options tuning, storage engine selection, and more.
Thursday, May 27, 2010 - 15:00 CET/13:00 UTC
In this presentation we will look at more advanced MySQL Replication techniques. We will cover master-master configurations, semi-synchronous replication, fail-over and resynchronization.
In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO; MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.
The Java Persistence API is the Java API for the management of persistence for Java EE and Java SE applications. It provides an object/relational mapping facility for the Java application developer using a Java domain model to manage a relational database. The release 2.0 has been expanded to include several key new features.
This session will provide an introduction to the Java Persistence API and then a presentation of some of the new features available in Java Persistence 2.0. The talk will provide an overview of the object-relational mapping and modeling additions, the query language facilities, the new criteria API, pessimistic locking, and support for validation.
More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.