Tag: MariaDB

Feed: Planet MySQL; Author: Continuent; Overview The Skinny In this blog post we will discuss how to use the Tungsten Connector keep-alive feature to ensure long-running MySQL & MariaDB/Percona Server client sessions stay connected in a Tungsten Cluster. Agenda What’s Here? Briefly explore how the Tungsten Connector works Describe the Connector keep-alives – what are they and why do we use them? Discuss why the keep-alive feature is not available in Bridge mode and why Examine how to tune the keep-alive feature in the Tungsten Connector Tungsten Connector: A Primer A Very Brief Summary The Tungsten Connector is an intelligent ... Read More

Feed: Planet MySQL; Author: Codership; Codership, the makers of Galera Cluster are proud to be sponsors at the second annual DataOps.Barcelona happening June 20-21 2019 at the World Trade Centre in Barcelona, Spain. For an opening keynote, in the Auditorium from 9.30-10.30am see Colin Charles speak about What’s New in Galera Cluster 4. There are plenty of new features and it debuts in MariaDB Server 10.4, so expect to hear a lot about what is available. On day two, Colin will also speak about Running MySQL and MariaDB Server securely in 2019. Our booth will have Vlad Alexandru manning it ... Read More

Feed: Planet MySQL; Author: ScaleGrid.io; Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Or, considering adding a new database to your application and want to see which combinations are most popular? We found all the answers you need at the Percona Live event last month, and broke down the insights into the following free trends reports: 2019 Top Databases Used So, which databases are most popular in 2019? We broke down the data ... Read More

Feed: Planet MySQL; Author: Severalnines; This blog is aimed at explaining an overview of cross replication between PostgreSQL and MySQL, and further discussing the methods of configuring cross replication between the two database servers. Traditionally, the databases involved in a cross replication setup are called heterogeneous databases, which is a good approach to move away from one RDBMS server to another. Both PostgreSQL and MySQL databases are conventionally RDBMS databases but they also offer NoSQL capability with added extensions to have the best of both worlds. This article focuses on the discussion of replication between PostgreSQL and MySQL from an ... Read More

Feed: Planet MySQL; Author: Continuent; Overview The Skinny When it comes to zero downtime, proxies are the first line components of a cluster. In order to achieve High Availability (HA) for MySQL, MariaDB and Percona Server, a commonly deployed setup consists of configuring load balancers (hardware or software) on top of those proxies. A Strong Architecture How is Maintenance Made Possible? With this proxy + load balancer architecture, server maintenance is made possible on any of the proxy hosts, as follows: the proxy is stopped the load balancer detects the dead proxy and removes it from the pool new connection ... Read More

Feed: Planet MySQL; Author: Severalnines; In the previous blog post, we showed you some basic steps to deploy and manage a standalone MySQL server as well as MySQL Replication setup using the MySQL Puppet module. In this second installation, we are going to cover similar steps, but now with a Galera Cluster setup. Galera Cluster with Puppet As you might know, Galera Cluster has three main providers: MySQL Galera Cluster (Codership) Percona XtraDB Cluster (Percona) MariaDB Cluster (embedded into MariaDB Server by MariaDB) A common practice with Galera Cluster deployments is to have an additional layer sitting on top of ... Read More

Feed: Planet MySQL; Author: Continuent; Perform Complex Online Schema Changes on MySQL / MariaDB / Percona Server Leveraging Tungsten Clustering | Continuent LtdThis website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read More Top ... Read More

Feed: Planet MySQL; Author: Severalnines; This blog is aimed at explaining an overview of cross replication between PostgreSQL and MySQL, and further discussing the methods of configuring cross replication between the two database servers. Traditionally, the databases involved in a cross replication setup are called heterogeneous databases, which is a good approach to move away from one RDBMS server to another. Both PostgreSQL and MySQL databases are conventionally RDBMS databases but they also offer NoSQL capability with added extensions to have the best of both worlds. This article focuses on the discussion of replication between PostgreSQL and MySQL from an ... Read More

Feed: DivvyCloud. Author: David Mundy; DivvyCloud is a way to deploy policy, minimize blast radius, and give developers the freedom to operate within the guide rails of safety. Thomas Martin Head of Application Modernization, GE Digital We are excited to announce our newest release of 2019! Collaboration with our customers and the broader community help shape our releases with improvements to core capabilities around discovery, analysis, and automated remediation of cloud and container infrastructure. Each release also includes several new features and support for the ever-expanding portfolio of services from the major cloud providers. This release focuses on data protection, ... Read More

Feed: MemSQL Blog. Author: Jacky Liang. A columnstore database takes all the values in a given column – the zip code column in a customer database, for instance – and stores all the zip code values in a single row, with the column number as the first entry. So the start of a columnstore database’s ZIP code record might look like this: 5, 94063, 20474, 38654… The “5” at the beginning means that the ZIP code data is stored in the fifth column in the rowstore database of customer names and addresses that the original data comes from. Columnstore databases ... Read More