Monday Jul 09, 2012
Wednesday Jun 27, 2012
By Keith Larson on Jun 27, 2012
Ronald Bradford, an Oracle ACE Director has been busy working with database consulting, book writing (EffectiveMySQL) while traveling and speaking around the world in support of MySQL. I was able to take some of his time to get an interview on this thoughts about theMySQL Connect conference.
Keith Larson: What where your thoughts when you heard that Oracle was going to provide the community the MySQL Conference ?
Ronald Bradford: Oracle has already been providing various different local community events including OTN Tech Days and MySQL community days. These are great for local regions both in the US and abroad. In previous years there has been an increase of content at Oracle Open World, however that benefits the Oracle community far more then the MySQL community. It is good to see that Oracle is realizing the benefit in providing a large scale dedicated event for the MySQL community that includes speakers from the MySQL development teams, invested companies in the ecosystem and other community evangelists.
I fully expect a successful event and look forward to hopefully seeing MySQL Connect at the upcoming Brazil and Japan OOW conferences and perhaps an event on the East Coast.
Keith Larson: Since you are part of the content committee, what did you think of the submissions that were received during call for papers?
Ronald Bradford: There was a large number of quality submissions to the number of available presentation sessions. As with the previous years as a committee member for the annual MySQL conference, there is always a large variety of common cornerstone MySQL features as well as new products and upcoming companies sharing their MySQL experiences.
All of the usual major players in the ecosystem will in presenting at MySQL Connect including Facebook, Twitter, Yahoo, Continuent, Percona, Tokutek, Sphinx and Amazon to name a few. This is ensuring the event will have a large number of quality speakers and a difficult time in choosing what to attend.
Keith Larson: What sessions do you look forwarding to attending?
Ronald Bradford: As with most quality conferences you can only be in one place at one time, so with multiple tracks per session it is always difficult to decide. The continued work and success with MySQL Cluster, and with a number of sessions I am sure will be popular. The features that interest me the most are around the optimizer, where there are several sessions on new features, and on the importance of backups. There are three presentations in this area to choose from.
Keith Larson: Are you going to cover any of the content in your books at your MySQL Connect sessions?
Ronald Bradford: I will be giving two presentations at MySQL Connect. The first will include the techniques available for creating better indexes where I will be touching on some aspects of the first Effective MySQL book on Optimizing SQL Statements. In my second presentation from experiences of managing 500+ AWS MySQL instances, I will be touching on areas including SQL tuning, backup and recovery and scale out with replication. These are the key topics of the initial books in the Effective MySQL series that focus on performance, scalability and business continuity. The books however cover a far greater amount of detail then can be presented in a 1 hour session.
Keith Larson: What features of MySQL 5.6 do you look forward to the most ?
Ronald Bradford: I am very impressed with the optimizer trace feature. The ability to see exposed information is invaluable not just for MySQL 5.6, but to also apply information discerned for optimizing SQL statements in earlier versions of MySQL. Not everybody understands that it is easy to deploy a MySQL 5.6 slave into an existing topology running an older version if MySQL for evaluation of many new features. You can use the new mysqlbinlog streaming feature for duplicating master binary logs on an older version with a MySQL 5.6 slave. The improvements in instrumentation in the Performance Schema are exciting. However, as with my upcoming Replication Techniques in Depth title, that will be available for sale at MySQL Connect, there are numerous replication features, some long overdue with provide significant management benefits. Crash Save Slaves, Global transaction Identifiers (GTID) and checksums just to mention a few.
Keith Larson: You have been to numerous conferences, what would you recommend for people at the conference?
Ronald Bradford: Make the time to meet and introduce yourself to the speakers that cover the topics that most interest you. The MySQL ecosystem has a very strong community. The relationships you build with presenters, developers and architects in MySQL can be invaluable, however they are created over time. Get to know these people, interact with them over time. This is the opportunity to learn more then just the content from a 1 hour session.
Keith Larson: Any additional tips to handling the long hours ?
Ronald Bradford: Conferences can be hard, especially with all the post event drinking. This is a two day event and I am sure will include additional events on Friday and Saturday night so come well prepared, and leave work behind. Take the time to learn something new. You can always catchup on sleep later.
Keith Larson: Thank you so much for taking some time to do this I look forward to seeing you at the MySQL Connect conference.
Please stay tuned here for more updates on MySQL.
Monday Jun 25, 2012
By Wei-Chen Chiu-Oracle on Jun 25, 2012
Managing a MySQL database server can become a full time job. In many
occasions, one MySQL DBA needs to manage multiple, even tens of, MySQL
servers, and tools that bundle a set of related tasks into a common
utility can be a big time saver, allowing you spend more time improving
performance and less time executing repeating tasks. While there are
several such utility libraries to choose, it is often the case that you
need to customize them to your needs. The MySQL Utilities library is the
answer to that need. It is open source so you can modify and expand it
as you see fit.
In the latest episode of the "Meet the MySQL Experts" podcast series, Chuck Bell, Sr. MySQL Software Developer at Oracle, introduces a variety of recently released MySQL Utilities, and how DBAs can save significant time using the utilities.
- Use cases for each utility
- How to group utilities for even more usability
- How to modify utilities for your needs
- How to develop and contribute new utilities
Wednesday May 23, 2012
By Keith Larson on May 23, 2012
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:
Wednesday May 09, 2012
By Wei-Chen Chiu-Oracle on May 09, 2012
Waiting Room Solutions (WRS) is an award-winning web-based Electronic Medical Records (EMR) and Practice Management System for physicians’ offices. Based in Goshen, NY, WRS serves almost 3,000 users for their needs in charting, medical record filing, payment tracking, prescription and reporting via the SaaS (Software as a Service) model, and WRS has sent over 20,000 electronic prescriptions a month over its secure network.
The Business Challenge
WRS was looking for a robust database for enterprise-class web-based applications with the following features:
Medical records and health information are highly confidential, and WRS expected to be fully incompliance with privacy regulations such as the HIPAA Privacy Rule.
2. Data Integrity
It is important to minimize data corruption and inconsistency for medical records, because they directly impact critical medical judgment and decisions.
Doctors work in a fast-paced environment and are not known for being patient. WRS was looking for a database with high performance, and was aiming to deliver the speed of an on-premise system with the SaaS model.
4. Low Cost and Scalability
WRS serves customers ranging from small practices to large enterprises. Therefore, WRS needed a database solution that was affordable to the smallest healthcare provider, while being able to scale to meet the demands of the largest providers who have hundreds of facilities.
The MySQL Solution
WRS evaluated both MySQL and PostgreSQL for its EMR and Practice Management System, and decided to use MySQL for the following reasons:
MySQL is the world’s most popular open-source database with millions of installations. It is widely used and is a proven technology.
2. Better Support
In addition to the community users who actively share knowledge and best practices, it was also important for WRS to know that there is an enterprise behind the product that they can turn to for help if needed. MySQL was created by MySQL AB, and subsequently was developed and improved by Sun Microsystems and now Oracle through acquisitions.It provides WRS with Scalability.
3. Open Source / Open Standard
MySQL is the “M” in the open-source LAMP (Linux, Apache, MySQL and PHP/Python/Perl) stack. By leveraging and integrating the existing open-source technology, WRS was able to develop products and features more quickly, and with better interoperability.
WRS uses MySQL replication to achieve scalability, deploying the master-slave topology. “With MySQL, we can scale as we need. I can install it on many machines and handle any required volume,” said Brad Hall, Systems Administrator at WRS. “This gives us far more flexibility with hardware.” Three primary slaves all have to handle the volume of over 6,000 queries per second throughout the day, and WRS uses partitioning to increase speed.
With MySQL, WRS was able to develop a modular EMR and Practice Management solution to support thousands of medical practices, with the following features: electronic medical and health records; billing; scheduling; electronic prescriptions; online patient registration; practice website; messaging; order tracking; transcription; document management; and disease management. “We required an open source solution that was well maintained, stable, and actively growing. In addition, we required a solution that offered access to enterprise support when needed. MySQL was the right choice for us,” said Hall. “The performance, scalability, and reliability delivered by MySQL with InnoDB has been excellent.”
Learn more about Waiting Room Solutions: http://www.waitingroomsolutions.com/
Read more MySQL customer stories: http://www.mysql.com/customers/
Monday Apr 30, 2012
By Keith Larson on Apr 30, 2012
If you have not signed up yet for the OTN Developer Day: MySQL in NYC, hurry time is running out! This is shaping up to be one of the largest developer days yet. We have a great line up of speakers. I look forward to seeing them and a great community turn out Wednesday.
Friday Apr 13, 2012
By Keith Larson on Apr 13, 2012
The Ubuntu Developer Summit takes place at The Oakland Marriott City Center, Oakland, California from 7–11 May 2012.
If your attending this event, you will have a few different MySQL opportunities to attend:
Join us as we help support and grow the MySQL Communities.
Tuesday Jan 31, 2012
By Bertrand Mattheli�-Oracle on Jan 31, 2012
Following the success of our OTN MySQL Developer Day in London last October, we are running additional MySQL Developer Days in Europe!
Join us in:
- Germany: Frankfurt - February 9th - Check out the agenda and register here!
- France: Paris - March 21st - Check out the agenda and register here!
The MySQL Developer Day is a one-stop shop for you to learn all the essential MySQL skills. In this free, one-day seminar, we will cover everything you need to know to successfully design, develop, and manage your MySQL databases. You'll also learn the guidelines and best practices in performance tuning and scalability. Space is limited so register now!
Additionally, we will also be holding a MySQL High Availability Seminar in Stockholm on February 23rd. During this free Oracle seminar we will review the various options and technologies at your disposal to implement highly available & highly scalable MySQL infrastructures, as well as best practices in terms of architectures. Register Now!
And…remember our MySQL Embedded Online Forum today from 9.00 am to 12.00 pm PT!
Monday Oct 31, 2011
By Bertrand Mattheli�-Oracle on Oct 31, 2011
A few weeks ago we announced New MySQL Enterprise Oracle Certifications making it easier and faster for Oracle customers to deploy & manage MySQL within their existing environment.
As we regularly get questions from customers about using Oracle GoldenGate with MySQL, we put together a “Spotlight On” document briefly presenting the products and the most common use cases.
For those less familiar with Oracle GoldenGate, organizations can leverage it to move transactional data in real time between MySQL and other systems without impacting the performance of source or target systems.
You can find the "Spotlight On" document here (under "Brochures & Data Sheets") along with additional information about Oracle GoldenGate.
For more information about MySQL Enterprise Edition, get the White Paper.
Tuesday Aug 30, 2011
By Bertrand Mattheli�-Oracle on Aug 30, 2011
We’re pleased to let you know that the 2nd episode of our “Meet The MySQL Experts” podcast series, where Oracle engineers share their expertise, is now available.
Wei-Chen Chiu interviews InnoDB team member Inaam Rana who comes back on the new InnoDB features and improvements delivered in MySQL 5.5 and in the first development milestone release of MySQL 5.6. Inaam also talks to us about the InnoDB features available in labs.mysql.com.
Monday Aug 08, 2011
By Wei-Chen Chiu-Oracle on Aug 08, 2011
We organized our first OTN Developer Day: MySQL earlier this year in Santa Clara, CA, and the result far exceeded our expectation. Before we kicked off the seminar at 9am, the attendees had already taken every single seat in the beautiful auditorium in Oracle's Santa Clara campus, and there was still a line in front of the registration desk. We recruited MySQL experts from several teams to present, and had great questions and discussions along the way and at the end. I personally received many positive comments saying that the seminar was very useful and informative.
This time, we're bringing the Developer Day to the East Coast! On August 24, we'll host a full-day event in Washington, DC, where you can learn all the essential skills to successfully design, develop, and manage your MySQL and MySQL Cluster databases. You’ll also learn the guidelines and best practices in performance tuning and scalability.
The event located near the Washington Convention Center, so if you're attending GOSCON/Innovation Forum on August 23, stay one more day to learn about MySQL!
Wednesday, August 24, 2011
8:00 a.m. – 3:30 p.m.
Renaissance Washington, DC
999 Ninth Street NW
Washington, DC 20001
Don’t miss this exclusive opportunity to learn tips and tricks from the MySQL experts at Oracle, and network with your peers. Whether you’re a DBA or a developer, register now and find out how you can make the best of MySQL in your IT infrastructure or in your commercial products and applications.
Thursday Jul 14, 2011
By Bertrand Mattheli�-Oracle on Jul 14, 2011
During the past year, we’ve put a
lot of emphasis at Oracle on sharing information with the MySQL Community.
Actions included PR and communications not only about GA products but also
about development milestone releases and features available in labs.mysql.com, as well as more technical
articles, more blogs, participation to conferences…etc. We very much value the feedback
and discussions such communications generate.
We therefore plan to keep communicating this way, and do even more. This is why we’re now very pleased to announce a new Oracle podcast series entitled “Meet the MySQL Experts”! We plan to, once a month, interview an Oracle MySQL Engineer who will share information about his/her domain expertise, and what he/she is currently working on.
For the first edition, it was my pleasure to interview Mats Kindahl about MySQL Replication.
We hope you enjoy the new podcast series, which we think will be a good complement to the great “OurSQL” podcast that Sheeri and Sarah are running.
Feedback welcome, including about topics that you would like us to cover in subsequent editions.
Tuesday Jun 28, 2011
By Bertrand Mattheli�-Oracle on Jun 28, 2011
Oracle is running MySQL High Availability breakfast seminars in London, Düsseldorf and Paris.
During these free seminars, we will review the various options and technologies at your disposal to implement highly available & highly scalable MySQL infrastructures, as well as best practices in terms of architectures.
The packed agenda will include High Availability features in MySQL 5.5, MySQL Replication, MySQL Cluster, the newly released Oracle VM Template for MySQL Enterprise Edition as well as what's new in MySQL 5.6 and MySQL Cluster 7.2, including NoSQL access methods to MySQL.
There are a few places left for the seminar in London taking place tomorrow, June 29th, Register Now!
Learn more and register for the event in Düsseldorf, July 13th.
more and register for the event in Paris, September 7th.
We hope to see you there!
Tuesday Jun 14, 2011
By Bertrand Mattheli�-Oracle on Jun 14, 2011
A special early bird extra discount is available to MySQL Community members, take advantage of it!
Register Now here using the code “MYSQL11” and you will save $1,000 on your Oracle OpenWorld registration!
We look forward to seeing you there.
Thursday May 19, 2011
By Bertrand Mattheli�-Oracle on May 19, 2011
Want to win the title of Developer, DBA or IT Manager of the Year?
Can you demonstrate outstanding achievements using MySQL and/or other Oracle technologies?
Formerly Oracle Magazine Editors’ Choice Awards and now part of Oracle’s prestigious Oracle Excellence Awards program, these awards honor Oracle technologists for their cutting-edge solutions using Oracle products and services. Winners are selected based on a compelling story of technology leadership and innovation that differentiates them from others in their roles. The awards will be presented during Oracle OpenWorld 2011 (October 2–6) in San Francisco.
The 10 winners will be selected across 10 award categories.
Read more and submit nominations here.
Get the latest updates on products, technology, news, events, webcasts, customers and more.
- Importing and Backing Up with mysqldump
- Events and conferences where you can find MySQL - May-December 2015
- MySQL April Newsletter is Published!
- What a MySQL Developer Needs to Know
- On Choosing Mature Technologies
- MYSQL User Group Meeting Korea
- Is The Performance of Your MySQL Database Important?
- Improve Performance of a MySQL Database with Partitioning
- MySQL User Group Meeting Hyderabad, India, April 10, 2015
- A Single Command to Backup MySQL Cluster Data