Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 11 to 20 of 34198 10 Older Entries
MariaDB: The Differences, Expectations, and Future
+0 Vote Up -0Vote Down

Thu, 2015-03-26 07:48russelljtdyer

For my new book, Learning MySQL and MariaDB, Monty Widenius, one of the founders of MySQL and MariaDB, graciously contributed a Foreword. It's about six pages long and an interesting read for those who are familiar with MySQL and MariaDB. Of particular interest to newcomers to MariaDB, is the excerpt below on his perspective of MariaDB and his vision for its future, as well as MySQL.

Excerpt from Foreword of …

  [Read more...]
Save 20% on Percona Live and Hear Baron Speak
+0 Vote Up -0Vote Down

Percona Live is the premier event for the MySQL ecosystem. It is being held in Santa Clara this year, April 13 - 16. If you are not already registered, use the code Vividcortex20 to receive a 20% discount.

We will be exhibiting, and Baron Schwartz will be speaking on Encrypting Data in MySQL with Go on April 16th at 12:50.

We look forward to seeing you!

How to Tell If It’s MySQL Swapping
+0 Vote Up -0Vote Down

On servers that are into the swap file and have multiple processes running, I often wonder if it’s MySQL that is in the swap or some other process.  With Linux this is a fairly easy thing to figure out.  Below is the format of a command to do just that:

echo 0 $(cat /proc/`pidof process`/smaps | grep TYPE | awk '{print $2}' | sed 's#^#+#') | bc

 

In the above command, TYPE refers to what type of Memory you want to examine.  Below are some of the options for this value:

TYPE Explanation
Private Private …
  [Read more...]
MySQL Statement Digests
Employee_Team +0 Vote Up -0Vote Down

Decoupling Statement Digests From Performance Schema

MySQL Statement Digests are a feature originally introduced as part of the MySQL Performance Schema in MySQL 5.6 to aggregate statement statistics based on the normalized statements executed within the server (for additional info, see here).

  [Read more...]
How to Cluster Atlassian Server Apps in your Data Center - JIRA, Confluence, Stash with MySQL Galera Cluster
+0 Vote Up -0Vote Down

Atlassian apps are widely used by development teams to facilitate software development and collaboration. For larger teams who require enterprise-grade tools, you might want to host the applications in your own data center and cluster them for high availability and performance. 

In this blog post, we are going to deploy a redundant active-passive setup for JIRA with clustered MySQL and NFS shared storage. Note that some Atlassian applications (JIRA, Confluence and Stash) already has built-in clustering support, …

  [Read more...]
Follow up on MySQL 5.6 GTIDs: Evaluation and Online Migration
+0 Vote Up -0Vote Down

One year ago, I blogged about Evaluation and Online Migration of MySQL 5.6 GTIDs.  At that time, we setup the following test environment where:

  • A is a production master with GTIDs disabled,
  • D to Z are standard slaves with GTIDs disabled,
  • B is an intermediate master running my recompiled version of MySQL implementing the ANONYMOUS_IN-GTID_OUT mode (see the details my previous …


  [Read more...]
Yelp IT! A talk with 3 Yelp MySQL DBAs on Percona Live & more
+0 Vote Up -0Vote Down

Founded in 2004 to help people find great local businesses, Yelp has some 135 million monthly unique visitors. With those traffic volumes Yelp’s 300+ engineers are constantly working to keep things moving smoothly – and when you move that fast you learn many things.

Fortunately for the global MySQL community, three Yelp DBAs will be sharing what they’ve learned at the annual Percona Live MySQL Conference and Expo this April 13-16 in Santa Clara, California.

Say “hello” to Susanne Lehmann, Jenni Snyder and Josh …

  [Read more...]
7 quick MySQL performance tips for the small business
+0 Vote Up -0Vote Down

We’ve heard lots in recent years about Big Data and the alternative models of data management and processing, like Hadoop and NoSQL. But truth be told, relational databases are still the workhorses of most of today’s small and medium sized businesses. Relational DBs date back over 40 years and SQL skills are fairly common, and they’re known to be highly secure.

 

MySQL is the world’s second most popular relational database management system (RDMS) and is the most popular open-source version of the database. It’s easily accessible and is often known to be part of the LAMP web development stack, standing for …

  [Read more...]
isolation levels
Employee_Team +2 Vote Up -0Vote Down

I gots to know…

Big web companies who use MySQL – what isolation level(s) do you use? Do you take the default? Do you think about it at all? How about if you use, eg, memcached, what there? And, does your code think about optimistic or pessimistic locking?

I’ve been reading up on isolation levels after seeing Peter Bailis’
http://www.bailis.org/blog/understanding-weak-isolation-is-a-serious-problem/
(thanks to Mark Callaghan for re-tweeting about it).

I’m learning things…  here’s one for today – …



  [Read more...]
An Inside Look: Building Database Driven Apps with Go
+0 Vote Up -0Vote Down

Have you downloaded our eBook, Building Database Driven Apps with Go? It is the best resource to quickly learn how to connect a database from Go programs.

This excerpt presents a quick introduction to the major functionality of database/sql in the form of a fully functioning Go program.

Before you begin, ensure you have access to a MySQL database, as we’ll use MySQL for the example. If you don’t have an instance of MySQL that’s appropriate for testing, you can get one in seconds with the …

  [Read more...]
10 Newer Entries Showing entries 11 to 20 of 34198 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.