Tag: replication

Feed: CronJ. Author: Ayush Goel; As discussed in my last blog, there are 2 types of databases SQL and NoSQL. So in this blog, we will be looking at one type of NoSQL database that is MongoDB. MongoDB is an example of a document-type database, which means it stores data in JSON-like documents. One of the biggest reasons for its popularity is the data model used is a highly elastic one that allows us to combine and store data of multivariate types. MongoDB Architecture Let’s first discuss the architecture of MongoDB. A typical MongoDB architecture has 3 parts-  Database: A database ... Read More

Feed: Planet MySQL; Author: Simon Mudd; If you use replication with MySQL, if you need a backup, if you need a spare copy of a system for testing and for many other reasons you need a way to make a copy of your MySQL system. In the past you could make a copy in various ways: using a cold file system copy with MySQL first shutdownusing MySQL Enterprise Backup, Xtrabackup from Percona or MariaBackup (an Xtrabackup fork). These work against an online running server. However, they required special binaries to run on the source in addition to the traditional mysqld.copying ... Read More

Feed: Planet MySQL; Author: Andrew Grimo; In MySQL 8.0.17 there have been a lot of updates to the MySQL set of offerings. We’ve introduced Cloning into InnoDB Cluster 8.0.17, advances with the MySQL-Router in 8.0.17 and MySQL continues to expand its collection of automation managed features. When Group Replication was first introduced in MySQL 5.7.17, there was considerably less to manage right away compared to a “3-member Async replication setup w/auto-failover“.  Auto-failover tooling requires a lot of thought, determination and coding.  With the advent of Group Replication, MySQL’s users can put aside all that work and let MySQL Server’s Group ... Read More

Feed: Planet MySQL; Author: Continuent; Overview The Skinny In this blog post, we explore the correct way to implement bi-directional Tungsten Replication between AWS Aurora and Tungsten Clustering for MySQL databases. Background The Story When we are approached by a prospect interested in using our solutions, we are proud of our pre-sales process by which that we engage at a very deep technical level to ensure the we provide the best possible solution to meet with the prospect’s requirements. This involves an in-depth hands-on POC, in addition to the significant time and effort we spend building and testing the solution ... Read More

Feed: Logicworks. Author: Lindsay Syhakhom; A staggering eighty-one percent (81%) of data breaches involve stolen or weak credentials. While two-factor authentication is now a foundational part of any identity security initiative, hackers are increasingly bypassing two-factor authentication methods.  Recently, a leader in identity governance and access management software came up with a new approach to help companies stay one step ahead of hackers in preventing unauthorized access. Their approach analyzes multiple factors of the authentication request so that two-factor authentication is only required if risks are detected. This process is called adaptive authentication or risk-based authentication and improves security while ... Read More

Feed: Planet MySQL; Author: Ted Wennmark; Last week I posted a blog on how to setup multi-source for MySQL 5.7 using GTID based replication, in this blog we will do the same using MySQL 8.0.Most of the procedure are the same, there are only two things that we need to change are; 1) Procedure for creating the replication user. 2) Fetching the GTID value from the MySQL dumpfile.1) Create replication user for MySQL 8 MySQL 8 uses a new authentication plugin so to create the replication user will differ from MySQL 5.7. The procedure for 5.7 was with:mysql> CREATE USER ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . This page documents system variables related to Galera Cluster. For options that are not system variables, see Galera Options. See Server System Variables for a complete list of system variables and instructions on setting them. Also see the Full list of MariaDB options, system and status variables. wsrep_auto_increment_control Description: If set to 1 (the default), will automatically adjust the auto_increment_increment and auto_increment_offset variables according to the size of the cluster, and when the cluster size changes. This avoids replication conflicts due to auto_increment. In a master-slave environment, can be set to OFF ... Read More

Feed: Planet MySQL; Author: Dave Stokes; Oracle Code One starts September 16th and the MySQL Track is packed with interesting presentations. The session coded that start with 'DEV' are general talks. Hands on Labs start with 'HOL' and you will have a pre imaged laptop to use to do the lab work. And 'TUT' is for tutorials.  Use the mobile OOW/CodeOne app to reserve your space as space is limited and there is limited stand by space.I highly recommend the State of the Dolphin talk on Monday as that will provide the richest overview of what is going on within ... Read More

Feed: AWS Partner Network (APN) Blog. Author: AWS Admin. By Ivan Bishop, Partner Solutions Architect, ISV Migrations at AWSBy Jon Roberts, Principal Engineer at Greenplum (Pivotal)Are you thinking of deploying Pivotal Greenplum on the Amazon Web Services (AWS) Cloud? Many customers also want to shift the responsibility for infrastructure to AWS, considering the alternatives. With an on-premises deployment, it takes time to provision floor space in a data center, run power cables and fiber, and ensure adequate cooling. Then, you have to acquire the hardware, provision IP addresses, install and harden the operating system (OS) across multiple machines, and finally ... Read More

Feed: Planet MySQL; Author: The Pythian Group; On October 3rd ProxySQL will have it’s very first technology day. They have chosen the lovely city of Ghent, Belgium, my home town, as the place to be. For those attending Percona Live Europe in Amsterdam, this is a great opportunity to extend your stay for a bit and take a two-hour train ride from the Percona Live venue at Amsterdam airport to Ghent where you can get some additional ProxySQL-specific content.The ProxySQL team has selected a few experienced speakers to come and talk about their product. Vlad Fedorkov from ProxySQL LLC will ... Read More