Tag: replication

Feed: Planet MySQL; Author: Oracle MySQL Group;   Introduction MySQL is the most popular open-source database and many organizations choose MySQL to store their valuable enterprise data. MySQL is optimized for OLTP, but it is not designed for analytic processing. As a result, organizations which need to efficiently run analytics on data stored in MySQL database move their data to another database to run analytic applications. This approach of moving data to another database introduces complexity and additional cost for customers in multiple ways: Applications need to define complex logic for extracting relevant data from MySQL. The extracted data needs ... Read More

Feed: AWS Architecture Blog. Amazon FSx provides AWS customers with the native compatibility of third-party file systems with feature sets for workloads such as Windows-based storage, high performance computing (HPC), machine learning, and electronic design automation (EDA).  Amazon FSx automates the time-consuming administration tasks such as hardware provisioning, software configuration, patching, and backups. Since Amazon FSx integrates the file systems with cloud-native AWS services, this makes them even more useful for a broader set of workloads. Amazon FSx for Windows File Server provides fully managed file storage that is accessible over the industry-standard Server Message Block (SMB) protocol. Built on ... Read More

Feed: Recent Announcements. S3 Replication is an elastic, fully managed, low cost feature that replicates objects in the same AWS Region by using S3 Same-Region Replication (S3 SRR) or across different AWS Regions by using S3 Cross-Region Replication (S3 CRR). With S3 Replication (multi-destination), you can easily create a shared dataset by replicating data to multiple buckets in the same or different AWS Regions. For example, you can use S3 Replication to push software installation files to multiple AWS Regions to reduce latency and minimize the time to deploy for users in each region. S3 Replication (multi-destination) is an extension ... Read More

Feed: Recent Announcements. Amazon S3 Replication now gives you the flexibility of replicating object metadata changes for two-way replication between buckets. With this new feature, replica modification sync, you can easily replicate metadata changes like object access control lists (ACLs), object tags, or object locks on the replicated objects. This two-way replication is important if you want to build shared datasets across multiple regions and keep all object and object metadata changes in sync.  ... Read More

Feed: Planet PostgreSQL. Big data has an unfortunate tendency to get messy. A few years in, a growing database that use to be small, lean, and well-designed, has better odds than not of becoming something large, bloated, and with best practices tossed aside and now considered unsalvageable.There’s a few common reasons that this happens, some better than others: Technological limitation: The underlying tech doesn’t support the scale. Say transactions or referential integrity across partitions in a sharded system. Stability: Certain operations come to be considered too risky. e.g. Batch update operations that have unpredictable performance properties. Cost/effort: Doing things the ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; Kristian Köhntopp  | December 1, 2020 |  Posted In: MySQL, Open Source Databases, Tools The tables in PERFORMANCE_SCHEMA (P_S) are not actually tables. You should not think of them as tables, even if your SQL works on them. You should not JOIN them, and you should not GROUP or ORDER BY them.Unlocked memory buffers without indexesThe stuff in P_S has been created with “keep the impact on production small” in mind. That is, from a users point of view, you can think of them as unlocked memory buffers – the values in there change as you ... Read More

Feed: Radar. Author: Mike Loukides. This month’s collection of interesting articles that point to important trends is dominated by AI. That’s not surprising; AI has probably been the biggest single category all year. But its dominance over other topics seems to be increasing. That’s partly because there’s more research into why AI fails; partly because we’re beginning to see AI in embedded systems, ranging from giant gas and oil wells to the tiny devices that Pete Warden is working with. Artificial Intelligence Teaching AI to manipulate and persuade: Combine NLP with reinforcement learning, and train in a multiplayer role-playing game ... Read More

Feed: Planet PostgreSQL. PostgreSQL 13 has been released over a month ago. The most important changes and new features have already been announced in various ways and (online) stages, mostly by well-known contributors or influential Postgres community players. In this blog we take a look at those who have allready mentioned the new features, changes and handy facts about PostgreSQL 13. We give an overview of interesting articles, webinars and blogs about the important major but also perhaps neglected non-major changes. Release schedule PostgreSQL Every year in Q3 the new major release is launched. Starting with PostgreSQL 10, a major version ... Read More

Feed: Planet MySQL; Author: Marco Tusa; How native ProxySQL stands in failover support (both v2.0.15 and v2.1.0)In recent times I have been designing several solutions focused on High Availability and Disaster Recovery. Some of them using Percona Server for MySQL with group replication, some using Percona XtraDB Cluster (PXC). What many of them had in common was the use of ProxySQL for the connection layer. This is because I consider the use of a layer 7 Proxy preferable, given the possible advantages provided in ReadWrite split and SQL filtering. The other positive aspect provided by ProxySQL, at least for Group Replication, ... Read More

Feed: Planet PostgreSQL. Date: 30.11.2020 Tags:   postgresql    loxodata    france    slony    training    running    Category:   Interviews    Interviewed by: Andreas Scherbaum PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here. Please tell us about yourself, and where you are from. I live in a small town in the East of France.After graduating in Computational Chemistry, I jumped into consulting at the beginning of the century. I was already convinced by ... Read More