Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 121 to 130 of 34978 10 Older Entries
Starting my life as a freelancer
+0 Vote Up -0Vote Down

As of the first of August I have become self employed. After working for Spil Games in the past nine and a half year as developer, IT architect, DBA and Head of Database Engineering I decided it was time to share my knowledge with the world outside.

I have founded my own company, DBArt, which I will use as an umbrella to both work as a freelance DBA and share knowledge in various ways. In the last case think beyond training and writing, but more on that in a future update.

In September I will be present at the Percona Live Europe Amsterdam 2015 conference and present about the MySQL …

  [Read more...]
San Francisco mySQL Meetup August 26 2015
+1 Vote Up -0Vote Down

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.

PXC – Incremental State transfers in detail
+0 Vote Up -0Vote Down

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 …

  [Read more...]
Become a MySQL DBA blog series - Live Migration using MySQL Replication
+0 Vote Up -0Vote Down

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 …

  [Read more...]
In search of cleanliness : the elusive quiet installation
+0 Vote Up -0Vote Down

UPDATE: Almost solved! See at the end.

A clean installation of a database server is one where everything goes according to the expectations. It used to be easy: you only had to do what the manual says, and, presto! you would see your database server installed and ready to use. If something went wrong, you got one or more error messages that informed you of what needs to be fixed.

Sometimes, rarely, it happened that you got also a warning message, telling you that while the installation was successful, you could improve it by fine tuning this and that. No big deal.

Gone are those times. A clean …





  [Read more...]
Velocity EU: Amsterdam
+0 Vote Up -0Vote Down

VividCortex is sponsoring and exhibiting at Velcoity EU in Amsterdam October 28 - 30th. Stop by our booth to get a free product demo and see how we can revolutionize your database monitoring.

Baron Schwartz will also be speaking on Probabilistically Sampling A Stream Of Events With A Sketch.

Click here for more details and registration.

Velocity EU: Amsterdam
+0 Vote Up -0Vote Down

VividCortex is sponsoring and exhibiting at Velcoity EU in Amsterdam October 28 - 30th. Stop by our booth to get a free product demo and see how we can revolutionize your database monitoring.

Baron Schwartz will also be speaking on Probabilistically Sampling A Stream Of Events With A Sketch.

Click here for more details and registration.

VividCortex Live Demo
+0 Vote Up -0Vote Down

Have you been considering VividCortex but putting off a free trial? Are you a user who wants to get the most of the product? Are you a huge fan who simply wants to hear the brains behind the product give you the inside scoop?

Join us on Tuesday, September 15 at 2 p.m. ET (6 p.m. GMT), for a live walk through of VividCortex on production systems from our CEO, Baron Schwartz. He will use the product to demonstrate the following:

  • Using our top queries feature to quickly find queries that need attention
  • Finding and diagnosing stalls with …
  [Read more...]
VividCortex Live Demo
+0 Vote Up -0Vote Down

Have you been considering VividCortex but putting off a free trial? Are you a user who wants to get the most of the product? Are you a huge fan who simply wants to hear the brains behind the product give you the inside scoop?

Join us on Tuesday, September 15 at 2 p.m. ET (6 p.m. GMT), for a live walk through of VividCortex on production systems from our CEO, Baron Schwartz. He will use the product to demonstrate the following:

  • Using our top queries feature to quickly find queries that need attention
  • Finding and diagnosing stalls with …
  [Read more...]
MYSQL_HISTFILE and .mysql_history
+0 Vote Up -0Vote Down

The MySQL manual says:
"mysql Logging
On Unix, the mysql client logs statements executed interactively to a history file. By default, this file is named .mysql_history in your home directory. To specify a different file, set the value of the MYSQL_HISTFILE environment variable."
The trouble with that is: it doesn't tell you what you don't need to know. So I'll tell you.

Heritage

The history-file concept that MySQL and MariaDB are following is indeed "on Unix" and specifically is like the …




  [Read more...]
10 Newer Entries Showing entries 121 to 130 of 34978 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.