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 …
[Read more]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 …
[Read more]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
…
[Read more]
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:
IST states
Galera has many internal node states related to Joiner nodes. They currently are:
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 …
Hi,
I think most of the DBAs experience this error in their weekly, monthly todo list. Each one follows different approach, I would like to share some tips here:
I/O thread has stopped:
ping or traceroute/tracert to
reach the host.
Migrating your database to a new datacenter can be a high-risk and time-consuming process. A database contains state, and can be much harder to migrate as compared to web servers, queues or cache servers.
In this blog post, we will give you some tips on how to migrate
your data from one service provider to another. The process is
somewhat similar to our previous post on how to upgrade MySQL, but there are a couple
of important differences.
This is the seventh installment in the ‘Become a MySQL DBA’ blog
series. Our previous posts in the DBA series include Database Upgrades, …