Thanks to all of our sponsors, speakers, speaker selection committee, event staff, and especially the attendees for making last week’s conference a resounding success. With over a thousand people, the event made a good comeback after last year’s event, but more importantly, the mood was strongly optimistic. I think a lot of people arrived with some uncertainty about how it would turn out, but the doubts didn’t last long, and after a few hours I believe everyone felt the energy and enthusiasm.

The positive comments on the Internet certainly seem to point that direction: Florian Haas called it “awe-inspiring.” …

@Anonymous,

this does not sound like a question that has anything todo with this article. Simple write a servlet as you are used to, and add code to execute SQL statements. You can send it whatever statement you like so you should be able to generate a statement that creates a table using some servlet parameter as name.

If you have recently attended some Percona Live events or if you have checked some slides from Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL.

• Percona Live DC 2012
• Percona Live MySQL Conference & Expo 2012

PRM is an OCF Resource Agent for Corosync / …

I blogged about duckduckgo previously, and here's another search engine, I've just recently learned about: blekko.

Met their CTO at Percona Live, running the CentOS (!) booth, to learn they have their own 25 petabyte index and an own NoSQL database to run it.
Their database (should I say petabase?) is written in C and Perl.

You cannot use Yum to an unregistered Linux by default after installation. As a workaround, you will have to create a repo from your installation CD or ISO file.

1. Mount your DVD/CDROM. Run this command from shell.

mount /dev/cdrom /mnt


2. Or if you have no DVD/CDROM, you can copy your ISO file to the server and mount like this.

mount -o loop -t iso9660 yourisofile.iso /mnt


3. Change directory to /mnt and run this command

yum clean all


5. Edit /etc/yum.repos.d/iso.repo. Use nano or vi.

nano /etc/yum.repos.d/iso.repo


6. Paste below and save.

[local]
name=Local CD Repo
baseurl=file:///mnt
gpgcheck=1
gpgkey=file:///mnt/RPM-GPG-KEY


Now try installing using …

The MySQL Enterprise Backup is a very powerful backup tool from MySQL. By using MEB, you can always take a hot and fast backup of all your MySQL Databases. I've been using it in Oracle Linux platform but just recently I have this need to use it in our Ubuntu production servers. I've tried installing it to Ubuntu 11.04 and have no problem at all. Here's what you need to do to get this done.

1. Download the files from http://edelivery.oracle.com. You need to have an account to download one.
2. Transfer it to the server using SCP or WinSCP if you are using windows or any other type of file transfer client.
3. SSH to your server and login as root.
4. Unzip the file to your preferred location. I recommend to use the default location the MEB is using at /opt/mysql/ directory.
5. Edit ~/.bashrc and add below lines

export PATH=/opt/mysql/meb-3.7:$PATH
6. execute source ~/.bashrc …

MySQL 5.1 or newer can sometimes start throwing a strange message into an error log. The message states that a query was unsafe for binary logging along with some additional information. What does it mean? Is it a problem?

From time to time you might spot MySQL error log filling with the following warning:

“[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted. Statement: DELETE FROM score WHERE user_id = 12345 AND created = ’2012-04-15′ LIMIT 1″

If binary logging is enabled and the log format is set to STATEMENT, MySQL generates such message when it considers that a query is ambiguous and could behave differently each time it executes against the same data set. Such situation could happen, for example, on a …

The Percona Live MySQL Conference and Expo 2012 is over. Together with the SkySQL solutions day, it has kept me occupied for 4 full days, from early morning to late at night.

I have to say that I am pleased. The quality of the organization was very high, with a very good lineup of speakers and an excellent technical support.

As usual, I have learned a lot during this week, either directly, by attending talks, or indirectly, by meeting people who told me what was juicy at the talks that I had missed. And I have met new interesting people, and caught up with the people that I know already.

This conference was particularly intense also because I got myself involved in 5 talks, which was probably more than I should have. How did I end up with such a task? It's a long story. …

 MySQL Cluster Performance Tuning

-------------------------------------------

In this session we will look at different tuning aspects of MySQL Cluster.

As well as going through performance tuning basics in MySQL Cluster, we will look closely at the new parameters and status variables of MySQL Cluster 7.2 to determine issues with e.g disk data performance and query (join) performance.

This was the last session I attend, and for me is alway a great pleasure to be at Johan presentations, for many reasons:

- he is probably the best cluster expert (in service delivery)

- he knows a lot of distinctiveness and insight that no one else knows

--------------------------------------------------------------------------

Speech taken by Johan "my Viking" Andersson

MySQL/Oracle has released a new version of MySQL cluster recently, and I had the opportunity to …

Boost Your Replication Throughput with Parallel Apply, Prefetch, and Batching

------------------------------------------------------

Slave lag is the bane master/slave replication. This talk will explain why slave lag occurs and show you three important ways that Tungsten Replicator can banish it for MySQL slaves. Parallel apply uses multiple threads to execute slave transactions. Prefetch uses parallel threads to read ahead of the slave position and fetch pages that will be needed by the slave. Batching uses CSV files to load row updates in extremely large transactions that bypass SQL completely. We will explain each technique, show you how to use it, and provide performance numbers that illustrate the gain you can expect. We will round the talk out with a discussion of non-Tungsten tools that offer similar benefits. With these techniques in hand, you'll be well-prepared to attack any replication performance …