Related resources Sharding MySQL with MySQL Fabric and ProxySQL MySQL Load Balancing with ProxySQL - an Overview How to set up read-write split in Galera Cluster using ProxySQL How ProxySQL adds Failover and Query Control to your MySQL Replication Setup Two Database Sharding Tools for MySQL
Having too large a (write) workload on a master is dangerous. If the master collapses and a …
[Read more]Related resources Sharding MySQL with MySQL Fabric and ProxySQL MySQL Load Balancing with ProxySQL - an Overview How to set up read-write split in Galera Cluster using ProxySQL How ProxySQL adds Failover and Query Control to your MySQL Replication Setup Two Database Sharding Tools for MySQL
Having too large a (write) workload on a master is dangerous. If the master collapses and a …
[Read more]We’ve been having a problem with MySQL replication at VividCortex. Replicas periodically tend to fall behind and we couldn’t really figure out how to speed things up. It wasn’t about resources. The replicas have plenty of CPU and I/O available. We’re also using multithreaded replication (a.k.a. MTR) but most of the replication threads were idle.
One thing that we decided to try out was the new
LOGICAL_CLOCK parallelization policy introduced in
MySQL 5.7.2. Here’s what the MySQL reference manual says about
slave-parallel-type:
When using a multi-threaded slave
(slave_parallel_workers is greater than 0), this
option specifies the policy used to decide which transactions are
allowed to execute in …
Today’s blog post is related again to MySQL Group Replication.
By default MySQL Group Replication runs in Single-Primary mode. And it’s the best option and the option you should use.
But sometimes it might happen that in very specific cases you would like to run you MGR Cluster in Multi-Primary mode: writing simultaneously on all the nodes member of the Group.
It’s of course feasible but you need to make some extra verification as not all workload are compatible with this behavior of the cluster.
Requirements
The requirements are the same as those for using MGR in Single-Primary mode:
This post discusses enabling and disabling jemalloc on Percona Server for MySQL.
The benefits of jemalloc versus glibc for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) you have less memory fragmentation, and thus more efficient resource management of the available server memory.
For standard installations of Percona Server 5.6+ (releases starting with 5.6.19-67.0), the only thing needed to …
[Read more]Hi all,
Fosdem’s organization relocated the MySQL & Friends Devroom from H.1308 to H.1309 (Van Rijn).
It’s the same building, just the door next to it.
MySQL will also have a stand in the H building. Don’t hesitate to visit it (I’ve heard there will be some Sakila Dolphins !)
Related resources Schema Changes for MySQL Replication & Galera Cluster Database Cluster Management - Manual vs Automation via ClusterControl Migrating to MySQL 5.7 - The Database Upgrade Guide
In the previous blog post, we discussed how gh-ost works internally and how it compares to Percona’s pt-online-schema-change. Today we’d like to focus on operations - how can we test a schema change with gh-ost to verify it …
[Read more]Related resources Schema Changes for MySQL Replication & Galera Cluster Database Cluster Management - Manual vs Automation via ClusterControl Migrating to MySQL 5.7 - The Database Upgrade Guide
In the previous blog post, we discussed how gh-ost works internally and how it compares to Percona’s pt-online-schema-change. Today we’d like to focus on operations - how can we test a schema change with gh-ost to verify it …
[Read more]This blog provides a query language type overview.
The idea for this blog originated from some customers asking me questions. When working in a particular field, you often a dedicated vocabulary that makes sense to your peers. It often includes phrases and abbreviations because it’s efficient. It’s no different in the database world. Much of this language might make sense to DBA’s, but it might sound like “voodoo” to people not used to it. The overview below covers the basic types of query languages inside SQL. I hope it clarifies what they mean, how they’re used and how you should interpret them.
DDL (Data Definition Language)
A database schema is a visualization of information. It contains the data structure separated by tables structures, views and anything that contains structure …
[Read more]Oracle’s MySQL Community Team is organizing a pre-Fosdem MySQL Day on Friday 3rd February 2017.
The event is free (like in beer) for all participants but as seating is limited, registration is required.
Come to meet MySQL engineers and listen to them talking about new MySQL 8.0’s features. Some of Percona’s experienced staff will also deliver some talks on troubleshooting, architecture, …
And finally, Booking.com will also share their user experience with the audience.
What else to start the Fosdem Week-end in the best way ?
Agenda and registration can be found on lefred’s blog !
