Tag: MySQL Replication

Feed: Planet MySQL; Author: Severalnines; One of the most popular ways in achieving high availability for MySQL is replication. Replication has been around for many years, and became much more stable with the introduction of GTIDs. But even with these improvements, the replication process can break due to various reasons - for instance, when master and slave are out of sync because writes were sent directly to the slave. How do you troubleshoot replication issues, and how do you fix them?  In this blog post, we will discuss some of the common issues with replication and how to fix them ... Read More

Feed: Planet MySQL; Author: Continuent; First off: Happy 15th birthday, Hadoop! It wasn’t an April Fool’s joke then, and it isn’t today either: Hadoop’s initial release was on the 1st of April 2006 :-) As most of you will know, Apaches Hadoop is a powerful and popular tool, which has been driving much of the Big Data movement over the years. It is generally understood to be a system that provides a (distributed) file system, which in turn stores data to be used by applications without knowing about the structure of the data. In other words, it’s a file system ... Read More

Feed: Planet MySQL; Author: Continuent; Key Elements for Deploying Highly Available, Geo-Scale MySQL When evaluating a solution, we need to define the requirements for our application around these following elements: High Availability (HA): Local fast and automatic failover, for high availability Disaster Recovery (DR): Remote fast and site level failover, for disaster recovery and continuous operations Zero Downtime: Perform complex system changes or routine maintenance, while keeping applications available Geo-Scale: Geographically distributed (active/passive or active/active) low-latency database deployments with a single consolidated management view Read Scale: Fast local response times for read traffic, even in a geo-distributed deployment Multi-Primary: Ability ... Read More

Feed: AWS Public Sector Blog. Author: Farhad Jahangirov. Applications running on LAMP (Linux, Apache, MySQL, and PHP) stack are ubiquitous—WordPress alone represents 38% of all content management systems. Other popular CMS applications such as Drupal and Joomla also run on LAMP as well as Moodle, a widely used learning management system (LMS). Because of the popularity of these applications, public sector organisations such as educational institutions should protect their business continuity by implementing disaster recovery (DR) solutions: policies, tools, and procedures to help the recovery or continuation of technology infrastructure and systems following a disaster. Amazon Web Services (AWS) Professional ... Read More

Feed: Planet MySQL; Author: Severalnines; Hybrid environments, where a part of the database infrastructure is located on-prem and some of it is located in a public cloud are not uncommon. There may be different reasons to use such setup - scalability, flexibility, high availability, disaster recovery. How to implement this setup in a proper way? This might be challenging as you have to consider several pieces of a puzzle that have to fit together. This blog is intended to give you some insights into how such a setup may look like. Connectivity We are not going into details here because ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.23! In addition to several bug fixes and minor changes, some significant enhancements regarding monitoring/troubleshooting and performance were included. MySQL Shell AdminAPI Cluster diagnostics Checking how a Cluster is running and, whenever the cluster is not 100% healthy, perform troubleshooting tasks is certainly one of the main tasks of a DBA. The AdminAPI makes this operation very easy by centralizing the monitoring information in: <Cluster>.status([options]) In this release, we’ve extended the status() command to provide more ... Read More

Feed: Planet MySQL; Author: Severalnines; In a previous blog, we had discussed how to migrate a standalone Moodle setup to scalable setup based on a clustered database.  The next step you will need to think about is the failover mechanism - what do you do if and when your database service goes down.  A failed database server is not unusual if you have MySQL Replication as your backend Moodle database, and if it happens, you will need to find a way to recover your topology by for instance promoting a standby server to become a new primary server. Having automatic ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; Since Covid situation we are - same as the rest of the world - switching most of our MySQL sessions & workshops to the online word. Below you can find the list of events with MySQL recorded sessions we run during the time from September to end of November and also some interesting videos as well. So, the list below includes publicly available recorded MySQL sessions (or slides only) from conferences end other events we attended.  September 2020: Open Source Conference Hiroshima, September 19, 2020 MySQL Session: "MySQL Update" Speaker: Yoshiaki Yamasaki, the MySQL Principal Solution ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; At my FOSDEM talk earlier this year, I gave a trick for fixing a crashed GTID replica.  I never blogged about this, so now is a good time.  What is pushing me to write on this today is my talk at MinervaDB Athena 2020 this Friday.  At this conference, I will present more details about MySQL replication crash safety.  So you know what to do if you want to learn more about this subject.  Let's now talk about voodoo.(This post uses the new MySQL terminology: primary, source and replica.  You can read the Oracle terminology ... Read More

Feed: Planet MySQL; Author: Slack Engineering; From the very beginning of Slack, MySQL was used as the storage engine for all our data. Slack operated MySQL servers in an active-active configuration. This is the story of how we changed our data storage architecture from the active-active clusters over to Vitess — a horizontal scaling system for MySQL. Vitess is the present and future of Datastores for Slack and continues to be a major success story for us. From the solid scalability fundamentals, developer ergonomics, and the thriving community, our bet on this technology has been instrumental for Slack’s continued growth.  ... Read More