Tag: MySQL Replication

Feed: Planet MySQL; Author: Michael McLaughlin; MySQL will be used for our online sections because the VMware instance and Docker configurations where too large to effectively download this term. MySQL 8.0.21 Installation Steps After you download the MySQL 8 MSI file, you will perform the following 24 steps to install MySQL on Windows 10. If you want a full developer install you must install Microsoft Excel and Visual Studio first. The first thing you need to do is grant privileges to allow the MySQL Installer application to work in Windows 10. Click the Yes button to authorize the MySQL Installer ... Read More

Feed: Planet MySQL; Author: Continuent; Cloud-Based Active/Active Tungsten MySQL Clusters @ Bluefin Payments Please join us on Wednesday September 30th at 10am PT for a discussion about geo-distributed active/active MySQL replication for Financial Services SaaS Providers based on a case study of Continuent customer Bluefin Payments, and on how to guarantee credit card transaction availability with geo-distributed Tungsten MySQL clusters. Financial Services typically require two or more active data centers to provide their customers with continuous availability along with quick response times. Bluefin Payments uses co-located data centers with active/active replication between each MySQL cluster, which provides a complete, local ... Read More

Feed: Planet MySQL; Author: Continuent; Large Number of On-premises Tungsten MySQL Clusters @ Marketo Thanks to those who could join us this week for our High Volume MySQL HA use case webinar on how to guarantee continuous operations for a SaaS provider with billions of daily transactions and terabytes of data using Tungsten MySQL Clusters. If you missed the webinar or would like to see it again, the replay is now available to watch at your convenience.  In this webinar, Continuent CEO Eero Teerikorpi discussed some common challenges SaaS providers face, such as having to provide 24/7/365 operations with zero ... Read More

Feed: Planet MySQL; Author: Continuent; Cloud-Based Active/Passive Tungsten MySQL Clusters @ Riot Games Thank you for joining us this week for our Geo-Scale MySQL webinar: Guaranteed Global Game Access for Hundreds of Millions of Players Worldwide. This is the story of a global gaming company with several hundred million worldwide players and the challenges it faced serving a gaming application for a large-scale, geographically-distributed audience. Eero Teerikorpi, our CEO and Founder of Continuent, discussed how to geo-scale MySQL in AWS with Tungsten Clusters, i.e. how to build a global, multi-region MySQL cloud back-end for Player Account Management capable of serving ... Read More

Feed: Planet MySQL; Author: Continuent; Large Number of On-premises Tungsten MySQL Clusters @ Marketo Please join us next Wednesday at 10am PT to learn how to guarantee continuous operations for a SaaS provider with billions of daily transactions and terabytes of data using Tungsten MySQL Clusters. In this webinar, Continuent CEO Eero Teerikorpi will discuss some common challenges SaaS providers face, such as having to provide 24/7/365 operations with zero downtime, even during maintenance operations. In addition, SaaS providers need to have an easy, consistent, and cost-effective model to scale. Marketo is a very large marketing automation SaaS provider, which ... Read More

Feed: Planet MySQL; Author: Continuent; Next in line in our Tungsten MySQL Use Case webinar series is the story of a global gaming company with several hundred million worldwide players and the challenges it faced serving a gaming application for a large-scale, geographically-distributed audience. Please join us next Wednesday at 10am PT for our Geo-Scale MySQL webinar: Guaranteed Global Game Access for Hundreds of Millions of Players Worldwide - Cloud-Based Active/Passive Tungsten MySQL Clusters @ Riot Games. Eero Teerikorpi, our CEO and Founder of Continuent, will be discussing how to geo-scale MySQL in AWS with Tungsten Clusters, i.e. how to ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; InnoDB ReplicaSet was introduced from MySQL 8.0.19. It works based on the MySQL asynchronous replication. Generally, InnoDB ReplicaSet does not provide high availability on its own like InnoDB Cluster, because with InnoDB ReplicaSet we need to perform the manual failover. AdminAPI includes the support for the InnoDB ReplicaSet. We can operate the InnoDB ReplicaSet using the MySQL shell. InnoDB cluster is the combination of MySQL shell and Group replication and MySQL routerInnoDB ReplicaSet is the combination of MySQL shell and MySQL traditional async replication and MySQL routerWhy InnoDB ReplicaSet?You can manually perform the switchover ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Oftentimes, we need to replicate between Amazon Aurora and an external MySQL server. The idea is to start by taking a point-in-time copy of the dataset. Next, we can configure MySQL replication to roll it forward and keep the data up-to-date.This process is documented by Amazon, however, it relies on the mysqldump method to create the initial copy of the data. If the dataset is in the high GB/TB range, this single-threaded method could take a very long time. Similarly, there are ways to improve the import phase (which can easily take 2x ... Read More

Feed: Planet MySQL; Author: Dave Stokes;     MySQL has had replication for decades but the various options can be confusing.  One social media post I read recently could be summarized with the statement 'there are too many good options but how do I know which is right for me?'Cluster    Of all the words used in the computer related world, 'cluster' is the one that I wish we could have found a replacement for as the confusion over the word has created it's own cluster. Since MySQL has InnoDB Cluster and NDB cluster with other vendors using the word we end ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; So you talk to a database, doing transactions. What happens actually, behind the scenes? Let’s have a look.There is a test table and we write data into it inside a transaction: CREATE TABLE t ( id serial, data varbinary(255) ) START TRANSACTION READ WRITE INSERT INTO t ( id, data ) VALUES (NULL, RANDOM_BYTES(255)) COMMITThe MySQL test instance we are talking to is running on a Linux machine, and otherwise idle to make observation easier. Also, we configured it with innodb_use_native_aio = false because observing actual physical asynchronous I/O and attributing it to the ... Read More