Thu, 2015-08-06 09:55maria-luisaraviol

MariaDB and Foedus paths crossed less than a year ago when I met Paolo Messina at a two-day IBM event in Tuscany. IBM invited me, as the MariaDB Italian representative, to introduce MariaDB as an Open Source Solution for the POWER8 platform.

Foedus was there as one of the top Italian IBM Partners and as an Italian ISV company that provides an ERP solution platform named “Octobus”. Since 2008, Foedus has developed innovative solutions and management tools using the LAMP stack as the foundation of their technology. Foedus is at the same time open to other platforms. Octobus, which has been developed in Java, also runs on Windows platform.

When we met in October 2014, Foedus was about to test their solution on a POWER8 machine. They wanted to consider POWER8 as an option because of the great performance of POWER8 machines, and because it was a great opportunity to run a native …

It has been a while since I posted something. I’m running in to some technical difficulties with the series of posts I have been working on. Mainly that WordPress thinks it needs to make my example code invisible.

Obviously that isn’t very helpful, and I’m working on it.

What are the posts about, you ask (or maybe you didn’t, but I’ll tell you anyway)? I’m putting a few session together on parsing XML in MySQL and making it perform well.

Hopefully everything is worked out within a week.

VividCortex is sponsoring and exhibiting at the Cloud Computing Expo in Santa Clara, California November 3 - 5. Stop by our booth to get a free product demo and see how we can revolutionize your database monitoring.

Click here for more details and registration.

VividCortex is sponsoring and exhibiting at the Cloud Computing Expo in Santa Clara, California November 3 - 5. Stop by our booth to get a free product demo and see how we can revolutionize your database monitoring.

Click here for more details and registration.

As I flipped the channels in my car, Josh Groban’s soulful voice floated over my speakers and caressed my very soul, singing about our shared timeless yearning to solve the monitoring problems that plague us all:

I can’t cage you in my arms
When my heart is jumping forward
To avoid your false alarms

“These lyrics are so deeply meaningful to me!” I thought, reaching for the box of Kleenex. SING IT, Josh! And he did, his soaring voice speaking of anomaly detection algorithms (I understand the following lyrics to be addressed to a system metric such as CPU, don’t you agree?).

And you can’t tell me not to stay
When I opened up your window
And I watched you fly away

Now there’s a song I can relate to! If you need to stop reading and go listen to Josh sing his sensible, logical lyrics that always …

As I flipped the channels in my car, Josh Groban’s soulful voice floated over my speakers and caressed my very soul, singing about our shared timeless yearning to solve the monitoring problems that plague us all:

I can’t cage you in my arms
When my heart is jumping forward
To avoid your false alarms

“These lyrics are so deeply meaningful to me!” I thought, reaching for the box of Kleenex. SING IT, Josh! And he did, his soaring voice speaking of anomaly detection algorithms (I understand the following lyrics to be addressed to a system metric such as CPU, don’t you agree?).

And you can’t tell me not to stay
When I opened up your window
And I watched you fly away

Now there’s a song I can relate to! If you need to stop reading and go listen to Josh sing his sensible, logical lyrics that always …

I want to take a moment to thank you for reading this blog. We are working very hard on cool tools for you to use with MySQL and we really enjoy spreading the news of these tools to you.  With this in mind I wanted to update you on something that is changing. We are moving to a new blog home at http://insidemysql.com/.  From this point on all new content will be posted on our new blog and we encourage each of you to update your bookmarks accordingly.  Our aggregator at http://planet.mysql.com/ has already been updated.

Don' t worry! The old posts will still be here so your old bookmarks will still work.  You can find our new Windows focused category at

…

Shots Architecture and how we handle extreme load spikes
I invite you to come out and join me in a talk about the above heading. I will describe many things and walk through the cases of what technology is used, where, why and how. The event information is located here. I'll also touch on, how cost is reduced, how we handle celebrity's load when they promote and what's next to make the system even more automatic and solid.
Thanks for sfmysql.org for all the work they do and for allowing me to give a talk.

IST Basics

State transfers in Galera remain a mystery to most people.  Incremental State transfers (as opposed to full State Snapshot transfers) are used under the following conditions:

• The Joiner node reports Galera a valid Galera GTID to the cluster
• The Donor node selected contains all the transactions the Joiner needs to catch up to the rest of the cluster in its Gcache
• The Donor node can establish a TCP connection to the Joiner on port 4568 (by default)

IST states

Galera has many internal node states related to Joiner nodes.  They currently are:

1. Joining
2. Joining: preparing for State Transfer
3. Joining: requested State Transfer
4. Joining: receiving State Transfer
5. Joining: State …

Why Multi source replication is required?

MySQL has limitation of not allowing to replicate multiple DB’s from different master host on a single slave. MySQL replication had a limitation, fixed with this new release, that said that one slave could have only one master. That is a limiting factor when we are designing our replication environment. There were some “hacks” to make it work, but now there is an official way.

What is multisource replication?
MySQL Multi-Source Replication enables a replication slave to receive transactions from multiple sources simultaneously. Multi-source replication can be used to back up multiple servers to a single server, to merge table shards, and consolidate data from multiple servers to a single server. Multi-source replication does not implement any conflict detection or resolution when applying the transactions, and those tasks are left to the …