Many users new to MySQL will find themselves overwhelmed when tasked with configuring their system for best performance. It doesn't need to be intimidating, however. MySQL offers nearly 400 settings to consider, but a user should understand that most of the system's benefits can be achieved just by getting a few fundamental configurations right. The vast majority of optimizing configuration comes from selecting those very important options. Knowing where to look is the first step, and utilizing tools such as a monitoring product can be a huge boon.

Look Before You Leap

Even before beginning, a user should internalize a few ideas. First of all, while you should not be afraid to approach and adjust your server’s configuration, there are some common mistakes that it’s good to know about so you can avoid them.

The first thing to know is that …

Download PDF Presentation

At the recent New York Oracle Users Group summer general meeting I gave a presentation to the Oracle community on the MySQL product release cycle. Details included:

• Identifying the server product options covering community, enterprise and ecosystem.
• Describe MySQL enterprise products, features and support options.
• Describing the DMR, RC, GA, EOL and labs product lifecycle.
• Discussing the GA release frequency.
• Talking about the MySQL Upgrade path.

What is the difference between InnoDB locks and transaction isolation level? We’ll discuss it in this post.

Recently I received a question from a user about one of my earlier blog posts. Since it wasn’t sent as a comment, I will answer it here. The question:

> I am reading your article:
> https://www.percona.com/resources/technical-presentations/troubleshooting-locking-issues-percona-mysql-webinar

> Full table scan locks whole table.

> Some bad select (read) query can do full table scan on InnoDB, does it lock whole table please?

> My understanding was that SELECT (read) blocks another DML only in MyISAM.

To answer this question, we to need understand two different concepts: locking and …

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.50, MariaDB Connector/J 1.4.6, and MariaDB Connector/ODBC 2.0.11. See the release notes and changelogs for details on these releases. Download MariaDB 5.5.50 Release Notes Changelog What is MariaDB 5.5? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Connector/J 1.4.6 Release Notes Changelog […]

The post MariaDB 5.5.50 and updated connectors now available appeared first on MariaDB.org.

In this tutorial we will show you how to setup basic MySQL replication on two CentOS 7 servers, but the same steps should work on all RPM based systems. We will use two test CentOS 7 virtual servers for this tutorial with the following IP addresses: MASTER: 123.456.789.1 SLAVE: 123.456.789.2 Master Server: Login to the master server as user root ssh root@IP_Address and install MySQL server if it is not already installed yum install mysql-server mysql Start the MySQL server and enable it to start at boot time systemctl start mysql systemctl enable mysql Next, open the MySQL configuration file […]

While MySQL is known as an easy to use database, official tools to manage pools of MySQL servers and make the whole system highly available with less complexity have been typically missing from the picture. The introduction of MySQL Fabric makes all of this far simpler.  Join Abdul Manaf as he explains the latest developments for MySQL Fabric, a framework for managing pools of MySQL server. Using two applications, MySQL Fabric combines automated sharding with high availability. This webinar will demonstrate a broad overview of MySQL Fabric, what it can achieve, and how it’s used by DBAs, DevOps and developers. You will learn how MySQL Fabric provides a simple and effective option for high availability as well as the option of massive and incremental scale-out.  Plus, this webinar will help you understand the following topics: 

• MySQL Scaling, High Availability and Sharding
• MySQL …

How do you scale Percona XtraDB Cluster with ProxySQL in Kubernetes?

In my previous post I looked how to run Percona XtraDB Cluster in a Docker Swarm orchestration system, and today I want to review how can we do it in the more advanced Kubernetes environment.

There are already some existing posts from Patrick Galbraith (https://github.com/kubernetes/kubernetes/tree/release-1.2/examples/mysql-galera) and Raghavendra Prabhu (https://github.com/ronin13/pxc-kubernetes) on this topic. For this post, I …

 All you need for monitoring MySQL servers

Data security is paramount for individuals and corporations alike. Today, it is inevitable not to notice the importance levied on hosted MySQL like RDS, Aurora, etc. Managing MySQL servers is becoming a daunting task, given the exponential growth in data and the number of users with each working days.

Below are the key aspects that need to be part of your wishlist.

1) Leveraging Performance Schema(P_S) and SYS Schema

Performance Schema was introduced in MySQL 5.5.3 and further upgraded through version 5.7. It has its own storage engine, provides access to low-level server execution information while minimizing the impact on server performance. There is a trade-off between the time you can save by using Performance Schema and the load it adds to the server. It can optimize server performance and save time when used in an efficient manner.

You can also target …

All you need for monitoring MySQL servers. Data security is paramount for individuals and corporations alike. Today, it is inevitable not to notice the importance levied on hosted MySQL like RDS, Aurora, etc. Managing MySQL servers is becoming a daunting task, given the exponential growth in data and the number of users with each working days.

Below are the key aspects that need to be part of your wishlist.

1) Leveraging Performance Schema(P_S) and SYS Schema

Performance Schema was introduced in MySQL 5.5.3 and further upgraded through version 5.7. It has its own storage engine, provides access to low-level server execution information while minimizing the impact on server performance. There is a trade-off between the time you can save by using Performance Schema and the load it adds to the server. It can optimize server performance and save time when used in an efficient manner.

You can also target queries that …

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.