Tag: MySQL Replication

Feed: Planet MySQL; Author: João Gramacho; MySQL 8.0.2 introduced a small yet powerful per transaction metadata information containing the transaction length in binary logs. MySQL binary logs are being used for many other things than MySQL replication or backup/recovery: replicate to Hadoop; replicate to other databases, such as Oracle; capture data change (CDC) and extract-transform-load (ETL); record change notification for cache invalidation; change tracking for differential backups; etc. A quick search about “binlog” into Github listed entries about projects parsing MySQL binary log event streams in many programming languages: Ruby, PHP, Python, NodeJS, Java, Golang, etc. Identifying that the stream ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; It is with extreme delight and a big smile on our face that we share the news that a new major MySQL release has been declared Generally Available (GA). The road to MySQL 8 was pretty eventful, sometimes painful and sometimes hard, always challenging, but nonetheless a great ride and an extremely rewarding journey for the engineers that have worked on it. This is another awesome release and we want you, as a MySQL user, to fully realize the exciting new things all around, in particular in replication! And if you want to ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Peter Zaitsev  | April 18, 2018 |  Posted In: Change Data Capture, Database Monitoring, Insight for DBAs, MySQL, Percona Server for MySQL PREVIOUS POST In this blog post, I’ll examine when looking at raw MySQL query logs can be more useful than working with tools that only have summary data. In my previous blog post, I wrote about analyzing MySQL Slow Query Logs with ClickHouse and ClickTail. One of the follow-up questions I got is when do you want to do that compared to just using tools like Percona Monitoring and Management or VividCortex, which ... Read More

Feed: Planet MySQL; Author: MyDBOPS; This is our third blog in the ProxySQL Series MySQL Replication Read-write Split up Seamless Replication Switchover Using MHA This blog post explains one of the very important use case of ProxySQL called Mirroring. Mirroring in ProxySQL is not an equivalent to MySQL replication. Also it does not guarantee data consistency across the servers but still there are a few cases where this feature of ProxySQL can take advantage. Let us consider we have Master-Slave replication running behind ProxySQL with MySQL 5.6 Writes and Reads are served by Master and Slave respectively. For more information kindly refer ... Read More

Feed: Planet MySQL; Author: Severalnines; Running databases on cloud infrastructure is getting increasingly popular these days. Although a cloud VM may not be as reliable as an enterprise-grade server, the main cloud providers offer a variety of tools to increase service availability. In this blog post, we’ll show you how to architect your MySQL or MariaDB database for high availability, in the cloud. We will be looking specifically at Amazon Web Services and Google Cloud Platform, but most of the tips can be used with other cloud providers too. Both AWS and Google offer database services on their clouds, and ... Read More

Feed: Planet MySQL; Author: Giuseppe Maxia; MySQL 8.0 GA is right around the corner. I don't have precise information about its release, as I don't work at Oracle. If I did, I would probably know, but I couldn't tell when the release is scheduled to appear because of company policies. I can, however, speculate and infer, based of my experience with previous releases. My personal assessment is that the release will appear before 9:00am PT on April 24, 2018. The "before" can be anything from a few minutes to one week in advance.Then, again, it may not happen at all ... Read More

Feed: Planet MySQL; Author: Severalnines; ClusterControl can be used to deploy highly available replication setups. It supports switchover and failover for GTID-based MySQL or MariaDB replication setups. ClusterControl can deploy different types of proxies for traffic routing: ProxySQL, HAProxy and MaxScale. These are integrated to handle topology changes related to failovers or switchovers. In this blog post, we’ll take a look at how this works and what you can expect from each of the proxies. First, let’s go through some definitions and terminology. ClusterControl can be configured to perform a recovery of a failed replication master - it can promote ... Read More

Feed: Planet MySQL; Author: The Pythian Group; Introduction In my travels to visit many customers over the last few years, I often see my customers creating many or all of their MySQL InnoDB tables using auto-increment primary keys. Many Object Relational Mappers do this by default on behalf of the user. Once the tables are all created with auto increment primary keys, then the database designer/developer goes about assigning alternate keys that they will actually use to access the data. Most of the time the auto-increment key is simply there to ensure that there is a unique key on the ... Read More

Feed: Planet MySQL; Author: Severalnines; Choosing your HA topology There are various ways to retain high availability with databases. You can use Virtual IPs (VRRP) to manage host availability, you can use resource managers like Zookeeper and Etcd to (re)configure your applications or use load balancers/proxies to distribute the workload over all available hosts. The Virtual IPs need either an application to manage them (MHA, Orchestrator), some scripting (Keepalived, Pacemaker/Corosync) or an engineer to manually fail over and the decision making in the process can become complex. The Virtual IP failover is a straightforward and simple process by removing the ... Read More

Feed: Planet MySQL; Author: Severalnines; We’re excited to announce a major update to our tutorial “Database Load Balancing for MySQL and MariaDB with ProxySQL” ProxySQL is a lightweight yet complex protocol-aware proxy that sits between the MySQL clients and servers. It is a gate, which basically separates clients from databases, and is therefore an entry point used to access all the database servers. In this new update we’ve… Updated the information about how to best deploy ProxySQL via ClusterControl Revamped the section “Getting Started with ProxySQL” Added a new section on Data Masking Added new frequently asked questions (FAQs) Load ... Read More