Showing entries 17043 to 17052 of 44066
« 10 Newer Entries | 10 Older Entries »
Percona Live MySQL Conference 2012 – Day 1 Review

Day 1 is the first official day of the Percona Live MySQL Conference. It began with two mini keynotes by Peter Zaitev and Baron Schwarz of Percona talking about the history of MySQL and his beginnings in the open source movement, respectively. It was very nostalgic, and I’m sure it brought a tear to a few people’s eyes.

Following the dynamic duo was full keynotes by Mårten Mickos (Eucalyptus Systems) on “Making LAMP a Cloud” and Brian Aker (HP) on “The New MySQL Cloud Ecosystem”. To be honest, I found the full keynotes to be quite disappointing. For me, the keynotes speeches should be about a topic that is visionary or notable in some way. What I got from the keynotes were:  MySQL is good, MySQL is growing, let me show you my product around MySQL, and buy/use my product. They felt far more like glorified sales pitches.

I remember that at the last conference I attended, SXSW Interactive, the keynotes by Ray …

[Read more]
Percona Live MySQL Conference 2012 – Day 0 Review

Day 0 of the MySQL Conference was a day unlike any other day. It was, in fact, tutorial day. While regular days of the Percona Live MySQL Conference feature 50 minute sessions, usually split into a 40 minute talk and a 5-10 minute question period, tutorials are 3-hour-long sessions (with a generous 10 minute break in the middle for those that wish to go to the WC) that provide an in-depth dive into some aspect of MySQL. Due to the length of the tutorials, they are more in-depth and technical than individual sessions can be, but at the same time, we are limited to 2 tutorials slots per day instead of the 5 for sessions.The tutorial schedule for the conference is located here, and with so many good ones, it was hard to choose which one(s) to go to.For the morning session, I attended Peter Zaitev’s tutorial entitled “InnoDB and XtraDB …

[Read more]
Percona Live MySQL Conference & Expo Was A Great Event

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.” …

[Read more]
Roland Bouman's blog: MySQL 5: Prepared statement syntax and Dynamic SQL

@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.

Testing Percona Replication Manager (prm) with Vagrant

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.

 

PRM is an OCF Resource Agent for Corosync / …

[Read more]
Search engine: blekko

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.

Creating a local repository for Yum to work

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 …

[Read more]
Installing MySQL Enterprise Backup to Generic Linux

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 …

[Read more]
Why a statement can be unsafe when it uses LIMIT clause?

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 …

[Read more]
Some lessons from MySQL Conference 2012

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. …

[Read more]
Showing entries 17043 to 17052 of 44066
« 10 Newer Entries | 10 Older Entries »