Read the original article at 5 Ways to fortify MySQL replication

MySQL replication technology is powerful and flexible. But it doesn’t do everything perfectly all the time. You may experience trouble with the slaves falling behind the master, or want to scale horizontally by building new slaves automatically. Or you might need to build a slave without blocking the master database.

All of these goals can be achieved using some powerful tools. Here’s a quick guide to those tools and how to use them.

1. 1. Build new Replicas without Downtime

Something we’re sure you need to do quite often is to build new slaves. You can snapshot from another slave by bringing …

On Friday last week, after the intensive days of the conference, Ars Technica wrote and published a nice article about MariaDB including many of the messages we had been delivering during the conference, http://arstechnica.com/business/news/2012/04/mysql-founders-latest-mariadb-release-takes-enterprise-features-open-source.ars.

MariaDB seals

Last year, when it became clear that O’Reilly wasn’t going to arrange the MySQL user conference in the future, there was a lot of discussion on who should arrange it. In the end Percona was pretty fast informing everyone that they had booked the convention center in Santa Clara to arrange the conference this year. Now with the …

It’s nice that this happened again this year:

The question I ask myself every year is, When am I going to get time to study all of these great blog posts?

Further Reading:

• The first guest post on Xaprb blog
• Schedule for MySQL-and-beyond conference is live
• MySQL conference Ignite call for proposals
• …

Percona has 2 talks lined up at OSDC in Nuremberg, Germany:
- Taking hot backups with XtraBackup by Alexey Kopytov
- Expert Troubleshooting: Resolving MySQL Problems Quickly  by Kenny Gryp

Feel free to come and say Hi!

On April 25 & 26, 2012 the Open Source Data Center Conference will invite experienced administrators and architects for an exchange with international open source experts.

OSDC is about simplifying complex IT infrastructures with Open Source and offers an ideal opportunity to meet with open source professionals and insiders, gather …

A few days ago, Ronald Bradford asked for a mysqldump –ignore-database option.

As a workaround, he proposes:

mysqldump --databases `mysql --skip-column-names \
   -e "SELECT GROUP_CONCAT(schema_name SEPARATOR ' ') \
   FROM information_schema.schemata WHERE schema_name \
   NOT IN ('mysql','performance_schema','information_schema');" \
   >` >/mysql/backup/rds2.sql

It's a clever solution, but unfortunately it only works if you have a handful of schemas. If your databases happens to have several dozens (or hundreds or thousands) of schemas (which is where you need this option more), then the output will be truncated to the length of group_concat_max_len (by default, 1024.)

There are two alternative methods.

The all-shell methodThis method lets …

There are ways to scale databases, unfortunately some are limited, some introduce complexities, some are do not fit the cloud...

By scaling solution I mean a solutions that help me scale my existing environment, my existing RDBMS. Some magic or technology that will take my existing Oracle or MySQL for example, to the next level, without porting to a new DB engine/vendor and without completely recoding my app.

Let's try to organize things a bit in this very summarized table, just to get the hunch of it. I can't imagine to cover it all in 1 table or even 100 pages, but that should be a start of a meaningful discussion to continue in next posts:

I just wanted to take a moment and say congratulations to all of the 2012 Community Contributor Award Winners!

The usual suspects, Baron, Sarah, Gerardo, and Sheeri, each won, and deservedly so. All 4 contribute a great deal to the MySQL Community and ecosystem, and it is very much appreciated.

However, I was especially happy to hear that James Day was also a winner (a name everyone might not be so familiar with). But, having worked with James for 5 years, I really couldn’t say it better than Henrik Ingo already did (in his initial post of this year’s winners), so let me quote him:

“James was nominated for ‘MySQL advocacy and swimming upstream to keep people informed about bugs and other issues.’ When looking into James’ activities in the community, the panel first didn’t find much evidence to support …

For the week of April 18th, 2012: Oracle Announces It’s First Sponsored MySQL Conference A New Development Milestone Release of MySQL 5.6 is now available IOUG’s Real World Performance Tour Returns to California this Month IOUG’s Plug-In to Vegas! adds … Continue reading →

Over the coming three months, Percona will be holding our highly acclaimed MySQL courses in the following cities:

• Dallas, Texas – May 14 – 17, 2012
• London, England – May 21 – 24, 2012
• Orlando, Florida – June 11 – 14, 2012
• Raleigh, North Carolina – June 18 – 21, 2012
• Boston, Massachusetts - July 9 …

At Collaborate, and on the Web, come on and join us and F2F with the tech-saavy! COLLABORATE Social Media Hour  Tues, 4/24, 1–2 pm Exhibit Hall-IOUG Booth There’s no 140 character limit for this meet up! Stop by the IOUG … Continue reading →