The Early Bird rate for MySQL Connect has been extended for two weeks. Register by August 2 to save US$500 over the onsite price!

MySQL Connect will be held on September 21 - 23 in San Francisco, California. The conference will start on Saturday with "The State of The Dolphin" keynote presented by Oracle's Chief Corporate Architect, Edward Screven, and Vice President of MySQL Engineering, Tomas Ulin, followed by a panel to discuss "Current MySQL Usage Models and Future Developments", with panelists from renowned web properties including Facebook, Twitter, LinkedIn and Paypal. …

Good afternoon Oscon attendees - in particular attendees of my High Availability in MySQL tutorial!

Attached you can find a spreadsheet (both LibreOffice, Excel) that we will use at the end of the tutorial. You can also download the slides, in case you wish to browse them at your own pace.

In this Log Buffer, you have naan bread, two types of roti, pasta, Karachi biryani, Chiken Tandoori, Beef tikka, eggplant masala, mixed pickles, French pastry with some elixir to wash all of it down. Yes, once again, this edition of Log Buffer contains numerous flavors from Oracle, SQL Server and MySQL.

Oracle:

Sometimes it’s the little differences that make something really cool, and Martin was wondering why this hasn’t made it into the Oracle dictionary before.

Oracle introduced a new feature for DataGuard called Far Sync. This configuration is designed to support synchronous redo transport between primary and standby database, which are far apart.

There are a few …

A lot is said about the differences in the data between MySQL and MongoDB. Things such as “MongoDB is document based”, “MySQL is relational”, “InnoDB has a clustering key”, etc.. Some may wonder how TokuDB, our MySQL storage engine, and TokuMX, our MongoDB product, fit in with these data layouts. I could not find anything describing the differences with a simple google search, so I figured I’d write a post explaining how things compare.

So who are the players here? With MySQL, users are likely familiar with two storage engines: MyISAM, the original default up until …

At OSCON, if you’re into the MySQL world, the day to be paying attention to BoFs is clearly Wednesday, 24 July 2013. We have a MariaDB BoF at D136 at 8pm-9pm, but before that you might be at the MySQL BoF in the same room, or you might be in Peter Zaitsev’s BoF on MySQL, NoSQL, Big Data – Better Together in E141. So figure out how to split yourself at 7-8pm, and once you’re done, come from 8-9pm at D136 on Wednesday and join the MariaDB crew at OSCON!

We’ll also be at the SkySQL booth, so come by Booth 815 and get some free t-shirts, stickers, or support the MariaDB community by being a foundation donor.

So far, I have been blogging about curious RDBMS caveats mostly related to Oracle and MySQL databases. Some examples: You never stop learning about Oracle features NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: MySQL SQL incompatibilities: NOT IN and NULL values MySQL Bad Idea #384 But there are also other databases, … Continue reading 10 Things in SQL Server Which Don’t Work as Expected →

Not so far I have found new cool tool to work with mySQL – Valentina Studio. Its free edition can do things more than many commercial tools!!
I very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview

The MySQL for Developers course examines the tools used by MySQL development professionals. Expert instructors reference real-world examples when illustrating how to generate complex queries, and consume them in your application. This course covers Java and PHP languages.

You can take this course as:

• A Live-Virtual event: Take this course from your own desk, no travel required. Choose from a wide selection of events on the schedule to suit different timezones.
• An In-Class event: Travel to an education center to take this class. Below is a selection of in-class events already on the schedule.

I attended Percona Live London since the creation of the event, and every year, I left with the same feeling, a great satisfaction.
This year again PLUK will be the place to be for MySQL lovers in Europe and I hope to meet you there.

Let me explain why you should go to PLUK2013?

• Because MySQL is primarily a community
• And you are this community
• This is an easy way to meet other members of this community
• You can meet talented people behind the blogs you read every days
• And speakers from some of the most innovative companies with MySQL
• This is the largest MySQL event in Europe
• London is really a fantastic city even in November (there is no season for beer)
• You can save a lot of money until August 4

Register now and enjoy …