The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.20 and MariaDB Galera Cluster 5.5.44. These are Stable (GA) releases.
Download MariaDB Galera Cluster 10.0.20
Release Notes Changelog What is MariaDB Galera Cluster?
[Read more]
When I joined Pinterest, my first three weeks were spent in Base
Camp, where the newest engineering hires work on real production
issues across the entire software stack. In Base Camp, we learn
how Pinterest is built by building it, and it’s not uncommon to
be pushing code and making meaningful contributions within just a
few days. At Pinterest, newly hired engineers have the
flexibility to choose which team they’ll join, and working on
different parts of the code as part of the Base Camp experience
can help with this decision. Base Campers typically work on a
variety of tasks, but my project was a deep dive into a MySQL
performance optimization project.
Pinterest, MySQL and AWS, oh my!
We work with MySQL running entirely inside Amazon Web Services (AWS). Despite using fairly high-powered instance types with RAID-0 SSDs and a fairly simple workload (many point selects by PK or simple ranges) that peaks around 2,000 …
[Read more]This Log Buffer Edition gathers a wide sample of blogs and then purifies the best ones from Oracle, SQL Server and MySQL.
Oracle:
It was a very long time since I wrote something in this blob, but
I have been very busy this spring with MariaDB on Power mostly.
This has been a lot of work, but also a lot of fun. So, what is
this MariaDB on Power thing all about, well I wrote an introduction to the Power platform late last
year. Since then a lot of things has happened though.
One thing is that several service providers out there has adopted
Power8 as a platform. To be honest, this really isn't sexy, but
it is useful and as a user of one of these services, you will
just see the same old Linux you are used to, but potentially it
is more powerful and reliable. One such provider is OVH, whose
service is more known as RunAbove. If you want to try it, you can do so for
free for 7 7 days, just go …
The slides of “Efficient Use of Indexes in MySQL” talk we delivered on SFMySQL Meetup.
This is an introductory talk for developers on MySQL indexes. In my opinion it’s quite important to understand how InnoDB organizes data. If you know how MySQL accesses data it’s easier to write optimal queries.
When working with queries I imagine secondary indexes as a table with records sorted by secondary key fields. This is a powerful concept that helps to understand MySQL logic. It’s also easy to understand complex optimizations like loose index scan.
For example, for index (last_name, rank) the secondary index table looks like:
…
[Read more]
Prior to MySQL 5.7, the CREATE USER command had a number of
limitations:
All of these things could be done through other means, but
typically involved other statements, such as GRANT commands. Starting with MySQL 5.7.6, these can all be done through a
new and improved CREATE USER …
UMASK and UMASK_DIR are amongst few MySQL Environment variables which defines directory and file creation modes (file permissions). In this post we will understand using UMASK & UMASK_DIR for changing the database directory and file permissions from it's default to what we need.
The post UMASK & UMASK_DIR – changing default MySQL file dir permissions first appeared on Change Is Inevitable.
A question I often hear when customers want to set up a production PXC cluster is: “How many nodes should we use?”
Three nodes is the most common deployment, but when are more nodes needed? They also ask: “Do we always need to use an even number of nodes?”
This is what we’ll clarify in this post.
This is all about quorum
I explained in a previous post that a quorum vote is held each time one node becomes unreachable. With this vote, the remaining nodes will estimate whether it is safe to keep on serving queries. If quorum is not reached, all remaining nodes will set themselves in a state where they cannot process any query (even reads).
To get the right size for you cluster, the only question you should answer is: how many nodes can simultaneously fail while leaving the …
[Read more]The Log Buffer Edition once again is sparkling with some gems, hand-picked from Oracle, SQL Server and MySQL.
Oracle:
MySQL India team is back with another MySQL user camp.
The day of the week, time and venue remains the same:
Date: Jun 26th, 2015
Day : Friday
Time: 3-5:30 pm
Place: OC001, Block1, B wing, Kalyani Magnum Infotech Park, J.P Nagar, 7th Phase Bangalore, India
During our previous meetings we were requested by our attendees that they would like to hear about implementation of GTID by the MySQL community. We have listened to you and requested a community member to talk about their experience with the implementation of GTID. Our first talk is :
There is also a lot of interest in our new delivery vehicles for MySQL packages. Using the new YUM repos you can stay up to date with the latest MySQL releases. You need not wait for your distro to update MySQL in their release …
[Read more]