Tag: replication

Feed: AWS Partner Network (APN) Blog. Author: Jordon Hoffnagle. By Jordon Hoffnagle, Sr. Partner Marketing Manager at signNow Organizations of all sizes must figure out how to keep their employees and customers connected while keeping business moving forward—more so when face-to-face contact is likely not an option. Businesses around the world find themselves embracing this new normal of remote work, and they are searching for the right software to drive their employee and business success. To accommodate what may have just been the world’s newest industrial revolution, paper-based processes could become a thing of the past. Fortunately, software solutions are ... Read More

Feed: Planet PostgreSQL. Development on Citus first started around a decade ago and once a year we release a major new Citus open source version. We wanted to make number 10 something special, but I could not have imagined how truly spectacular this release would become. Citus 10 extends Postgres (12 and 13) with many new superpowers: Columnar storage for Postgres: Compress your PostgreSQL and Citus tables to reduce storage cost and speed up your analytical queries. Sharding on a single Citus node: Make your single-node Postgres server ready to scale out by sharding tables locally using Citus. Shard rebalancer ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Peter Vaihansky. By Peter Vaihansky, Sr. Vice President at DataArtBy Nicola Pietroluongo, Enterprise Sr. Solutions Architect at AWSBy Vipin Unni, Enterprise Account Manager at AWS Inchcape Shipping Services is a maritime services provider that can trace its roots back to 1847 when it began trading with the British East India Company as its first client. Today, Inchcape is a global organization and leader in ships agency and maritime services, boasting more than 240 offices in 68 countries, covering around 2,500 ports. The main thing that all interested parties need when a vessel is ... Read More

Feed: James Serra's Blog. Author: James Serra. Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and AI related announcements: Azure Arc enabled machine learning (preview): Build models on-premises, in multi-cloud, and at the edge with Azure Arc. It does this by deploying Azure Machine Learning to a Kubernetes cluster that resides on-prem or in another cloud. More infoAzure Migrate new features: Discover and assess your SQL servers and their databases for migration to Azure from within the Azure Migrate portal, get target ... Read More

Feed: Planet PostgreSQL. © Laurenz Albe 2021PostgreSQL commit ee28cacf61 has added new options for the target_session_attrs connection parameter. This article explores how the new options can be used to simplify high availability and horizontal scaling solutions.What is target_session_attrs?The PostgreSQL client shared library libpq has support for connection strings to more than one database server: psql 'host=server1.my.org,server2.my.org port=5432,5432 dbname=mydb user=myself' In the URL connection string format, that would look like psql 'postgresql://myself@server1.my.org:5432,server2.my.org:5432/mydb' Then the client will first try to connect to server1.my.org, and if it cannot reach that server, it will try to connect to server2.my.org.This is useful in combination with ... Read More

Feed: Microsoft Azure Blog. Author: Jeremy Winter. In response to the global health and macroeconomic crisis that began last year, customers have been accelerating their digital transformation efforts at an unprecedented pace to help bolster organizational resilience. They have depended on the cloud to not only help maintain business continuity throughout the recovery but also reimagine their mission for long-term growth. Customers like Albertsons Companies, Actavo, H&R Block, and Additiv have shared how migrating to the cloud with Microsoft Azure allowed them to stay resilient: "Within the space of a week, we were able to tick a box that said, 'If lockdown ... Read More

Feed: Planet PostgreSQL. 1. Introduction As an experienced PostgreSQL user, you may have a lot of experience in setting up streaming replication in your database clusters to make multiple backups of your data. But have you wondered how the standby is able to correctly determine if a tuple sent from the primary should be visible to the user or not. In the case where a transaction contains multiple subtransactions, how does the standby determine the visibility in this case? You might say… well it is PostgreSQL so it will just work… This is true. If you are someone who is ... 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: AWS Big Data Blog. Thousands of customers are building their data lakes on Amazon Simple Storage Service (Amazon S3). You can use AWS Lake Formation to build your data lakes easily—in a matter of days as opposed to months. However, there are still some difficult challenges to address with your data lakes: Supporting streaming updates and deletes in your data lakes, for example, database replication, and supporting privacy regulations such as GDPR and CCPA Achieving fine-grained secure sharing not only with table-level or column-level access control, but with row-level access control Optimizing the layout of various tables and files on ... Read More

Feed: Microsoft Azure Blog. Author: Rohan Kumar. For any organization to succeed in a world of unprecedented uncertainty, a new level of agility is required. Core to that agility is the ability to quickly gain insights from data at any scale, power ultra-low latency applications that deliver personalized experiences, and empower all users in an organization, regardless of size. This requires a computing platform that provides limitless scale, performance, and possibilities for what can be achieved with data. To help organizations achieve these limitless capabilities, we shared several announcements today at Microsoft Ignite: Unmatched analytics Our commitment to customers is ... Read More