Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447
Brazil: +55 11 5189-1097
A day packed with technical sessions, customer experiences and all round MySQL goodness! You will be able to learn, improve your skills and network with other MySQL users.
Whatever your experience with MySQL, the MySQL European conferences help you can get the most out of MySQL technology, and from the company now behind it, Sun Microsystems.
Don't miss this once a year opportunity!
Register before August 31st and receive an early bird discount!
Learn more and Register now » (http://www.mysql.com/news-and-events/european-conferences/2008/)
Thursday, September 04, 2008 - 10:00am PST
The MySQL Query Analyzer is designed to alleviate pain points around diagnosing and fixing performance problems related to poorly performing SQL code. Join us for this presentation to see how the new Query Analyzer help keep your key MySQL systems up and running at the highest levels of scalability and performance by identifying problems and tuning opportunities around application and user queries before they lead to costly outages.
September 10, 2008 - 10:00am PST
You will get expert insight and learn best practices to help you identify those areas of database and application design that will give you the greatest benefits for performance. Plus, learn how to leverage the MySQL Enterprise Monitor and Advisors to improve your productivity in a small, customer-only group setting.
CONCEIVIUM Business Solutions ensures that BlackBerry Enterprise Servers are up and performing optimally 24X7 for three of the world's top five banks, The Coca Cola Company, IBM Global Services and many other primarily Fortune 500 organizations. With MySQL Embedded Server, CONCEIVIUM's Mobile Monitor/Analyzer Agents have achieved a 70% performance gain and are now able to analyze over two gigabytes of data per day and perform thousands of transactions per second.
Learn More » (http://www.mysql.com/why-mysql/case-studies/conceivium-relies-on-mysql-real-time-analytics-for-blackberry/)
You can now Test Drive the MySQL Enterprise Monitor with no download or installation required. MySQL will provide you access to demo servers to test MySQL Enterprise Monitor for 48hrs.
Learn More » (http://www.mysql.com/products/enterprise/monitor-test-drive.html)
MySQL is the world's most popular open source database software. As part of Sun Microsystems' software group, MySQL is a global organization with over 400 workers in 25 countries. We are looking for talented professionals in engineering, sales, marketing, professional services, and support that will contribute to our product's strong momentum and share in our success! We have openings for the following positions:
Apply Now » (http://www.mysql.com/jobs/)
MySQL Community Server 5.0.67 has been released. Important functionality added or changed includes:
MySQL 6.0.6-alpha, a new version of the MySQL database system has been released. MySQL 6.0 includes two new storage engines: the transactional Falcon engine, and the crash-safe Maria engine.
The Maria storage engine is a crash safe version of MyISAM. Maria supports all of the main functionality of the MyISAM engine, but includes recovery support (in the event of a system crash), full logging (including CREATE, DROP, RENAME and TRUNCATE operations), all MyISAM row formats and a new Maria specific row format. Changes include:
The MySQL Developer Tools team is working on version 5.1 in parallel while we keep constantly improving version 5.0 and fixing remaining bugs. We managed to close 24 bugs since the last release 06/25/2008. Unfortunately due to a bug in our auto-update feature, we had to disable it for previous versions - so please download and install the release manually this time, sorry for the inconvenience.
A new connector has been made available: MySQL Connector/C++. The MySQL Connector/C++ provides a C++ API for connecting client applications to the MySQL Server. The MySQL Connector/C++ mimics the JDBC 3.0 API. Using MySQL Connector/C++ instead of the MySQL C API (MySQL Client Library) offers the following advantages for C++ users:
I still remember the day. I was working for a large systems integrator on a very major account, and had responsibility for some DB2 databases, but also had the unfortunate duty of also taking care of some legacy IMS databases (hierarchical IBM databases used quite a lot 'back in the day'), which I knew next to nothing about. One morning I was asked to make a small change to a very large and prominent IMS database - just remove one record - what could go wrong?
MySQL can be used with multiple programming languages, but PHP is probably the most popular choice. MC Brown of the MySQL Docs team has synced the MySQL-related parts of the PHP documentation with the MySQL Reference Manual.
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 MySQL, including technical tips and best practices.
It should come as no surprise to readers of this blog that I really like ZFS. Personally I think it is one of the biggest developments in file system design in many, many years. One place where I've started to use it recently on my own home server is to make instant and consistent backups of my MySQL databases.
A system is not a system unless it can be monitored and controlled...I recall something like that from a university course in Control Theory. However, in a couple of blogs on I am going to give some ideas on how to monitor and control MySQL Cluster.
The following maintenance jobs are typically run against a MySQL database:
A backup is not a typical maintenance job. But it behaves more or less like one. The backup should be done regularly depending on the restore/PITR (Point in Time Recovery) requirements.
My first project at Facebook was a tad more involved then I was expecting, but I think that is one reason why we have such a great engineering organization; we have a lot of hard problems to solve and everyone here is excited to jump in and tackle them. I set out to really understand why we were building a new datacenter and what problems we had to overcome to make it work.
Being able to use an Open Source DBMS to manage your data is nice, but what good would it be if you can't easily access it from your applications? One key factor to the popularity of MySQL is probably its wide range of available language bindings, which started with support for C, PHP and Perl from early on. I've tried to gather a list of languages and their respective MySQL drivers/modules below.
So, you have a binlog. You want to find out something specific that happened inside of it. What to do? mysqlbinlog has some neat features, which I thought we would look at here.
The big reasons most people are going to salivate over 5.1, and probably start plans to upgrade now, are the online operations.
GlassFish and MySQL bundle was released a while ago and I finally got a chance to try it out. This blog post contains simple instructions to get you started.
One of the biggest problems I faced as a field DBA was defending For MySQL DBAs the challenge to identify and isolate resource intensive SQL code is really two-fold; job #1 is to find the offending code (after that the chore becomes fixing it so it performs, but that is a topic for another post)
Thursday, September 04, 2008 - 8:00 am PST
Join us for this interactive web seminar, to learn about the prototypical Web 2.0 concepts and how the database schema lies at the heart of a scalable, high performance modern web application. During this seminar, we will discuss:
Tuesday, September 09, 2008 - 10:00am PST
Join us for this informative technical webinar with Patrick Galbraith of Grazr Inc., were he will discuss the lessons learned in designing and implementing scalable Web 2.0 applications leveraging MySQL and memcached, the open source distributed memory caching system.
Join us for this informative webinar where we will explore how MySQL 5.1. MySQL 5.1 is the next version of the MySQL Relational Database Server. 5.1 has been enhanced for Partitioning, Row Replication, Events, Disk-based Clustering, XML-/XPATH- Support and other features for better performance and ease of use. In this web seminar, you will learn how to put these features to use.
Tuesday, September 16, 2008
MySQL Workbench is a powerful model-based visual database design tool. It allows developers and DBAs to efficiently design, maintain and document MySQL database schemas. Apart from many powerful built-in functions, such as reverse and forward engineering, MySQL Workbench also features a plug-in architecture, allowing users to extend its functionality. This webinar provides an overview of MySQL workbench, demonstrating some of its key features.
Thursday, September 25, 2008
Join us for this informative technical webinar with Jeff Freund, CTO of Clickability, the global leader in on demand web content management, will discuss how memcached has helped his company massively scale their SaaS applications for hundreds of customers including Cisco and CNN Interactive.
September 23-25, 2008
Brian Aker, Director of Architecture at MySQL will be giving a keynote at the Astricon conference Sept 23-25 in Glendale Arizona. Astricon covers the Asterisk open source VOIP system and related technologies for developers, users and the community.
A dedicated MySQL certified consultant will work closely with your team to:
Learn More » (http://www.mysql.com/consulting/packaged/dev.html)
Lyon, Paris, Milan, Tokyo, New York
This course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.
Register Now for an Upcoming Date » (http://www.mysql.com/training/courses/mysql_5_ha.html)
Thursday, September 11, 2008 - 10:00am PST
Customers who have been looking to achieve regulatory compliance with the Payment Card Industry Data Security standard (PCI-DSS) for their MySQL installations need not look any further. PCI- GENERAL, a secure MySQL server, prevents loss or exposure of sensitive data and automates business processes for sustainable compliance with the Payment Card Industry Data Security mandates. Transparent data encryption, data disclosure protection against "root" and lifetime key management are some of the main features of Packet General's solutions. Join us on September 11 for a Webinar discussing some of the issues involved in achieving PCI-Compliance for your infrastructure.
This paper goes under the covers of the first high-performance appliance for MySQL from Kickfire. Specifically, you will learn how Kickfire's first-of-a-kind SQL chip combined with its columnar-based storage engine overcome the I/O and von Neumann bottlenecks - the two main barriers to high performance reporting and analytics. The result is an appliance, purpose-built for MySQL, that delivers 10-1000X performance improvement over general-purpose hardware.