Tag: lock

Feed: AWS Architecture Blog. Originally published March 2020 to the Field Notes blog, and reviewed for technical accuracy in March 2021. To get started with Amazon Elasticsearch Service (Amazon ES), you must have a concept for authentication and authorization for your search cluster. In addition to an IP-based access policy or a proxy server to protect your search cluster, you can leverage AWS Identity and Access Management (IAM) with Amazon Cognito User Pools to authenticate and authorize users. With fine-grained access control you further control permissions to dashboards or data in your Amazon ES cluster. You can configure this using the AWS ... Read More

Feed: R-bloggers. Author: Posts on R-hub blog. [This article was first published on Posts on R-hub blog, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. SQLite is a great, full featured SQL database engine. Most likely it is used more than all other database engines combined. The RSQLite R package embeds SQLite, and lets you query and manipulate SQLite databases from R. It is used in Bioconductor data packages, many deployed Shiny apps, ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Jeff Moncrief. By Jeff Moncrief, Director of Sales Engineering at Sonrai SecurityBy Adam Blackington, Partner Solutions Architect at AWS With the move to cloud, there has been a paradigm shift in how we protect our most valuable asset—data. Where it was once the network, identities have become the “new” perimeter. With that, it’s critical to fully understand every possible relationship between the identities and data that exist inside your cloud. The foundation to securing your organization in this new paradigm is truly knowing who, what, and how your data is accessed. In this ... Read More

Feed: R-bloggers. Author: Mirai Solutions. [This article was first published on Mirai Solutions, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Concepts like reproducibility, integrity and collaborative development are a “must” for using R in production. Among other common best practices (modularize your code, structure it as a package, define unit testing and automate with CI / CD pipelines), managing code dependencies is a fundamental step for ensuring quality and robustness of your ... Read More

Feed: CIO. Author: . In recent years, organisations of all sizes across Australia have taken advantage of public cloud services largely due to the benefits of flexible, consumption-based usage and access to modern applications. Usage of these services certainly ramped up when the COVID-19 pandemic first hit in early 2020.But these services are not 'one-size-fits-all’ solution. There are some scenarios where public cloud not the best option for organisations. For instance, without the policies and governance in place, service costs can easily balloon to unmanageable levels while application latency can also be an issue.Australian tech leaders gathered in Sydney recently to discuss their ... Read More

Feed: Planet MySQL; Author: Mikael Ronström; This blog introduces how RonDB handles automatic thread configuration. This blog is more technical and dives deeper under the surface of how RonDB operates. RonDB provides a configuration option, ThreadConfig, whereby the user can have full control over the assignment of threads to CPUs, how the CPU locking is to be performed and how the thread should be scheduled.However for the absolute majority of users this is too advanced, thus the managed version of RonDB ensures that this thread configuration is based on best practices found over decades of testing. This means that every ... Read More

Feed: Planet MySQL; Author: Continuent; Key Elements for Deploying Highly Available, Geo-Scale MySQL When evaluating a solution, we need to define the requirements for our application around these following elements: High Availability (HA): Local fast and automatic failover, for high availability Disaster Recovery (DR): Remote fast and site level failover, for disaster recovery and continuous operations Zero Downtime: Perform complex system changes or routine maintenance, while keeping applications available Geo-Scale: Geographically distributed (active/passive or active/active) low-latency database deployments with a single consolidated management view Read Scale: Fast local response times for read traffic, even in a geo-distributed deployment Multi-Primary: Ability ... Read More

Feed: Planet MySQL; Author: Ronald Bradford; This week I was evaluating AWS QLDB. Specifically the verifiable history of changes to determine how to simplify present processes that perform auditing via CDC. This is not the first time I have looked at QLDB so there was nothing that new to learn. What I found was that creating a workable solution with an existing application is hard. Even harder is creating an example to publish in this blog (and the purpose of this post). First some background. Using MySQL as the source of information, how can you leverage QLDB? It’s easy to ... 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: MariaDB Knowledge Base Article Feed. Author: . 소개 시퀀스는 CREATE SEQUENCE문에서 지정된 대로 일련의 숫자값을 생성하는 객체입니다. CREATE SEQUENCE는 시퀀스를 생성하고, 생성된 시퀀스는 NEXT VALUE FOR sequence_name으로 호출될 때 마다 새로운 값을 생성합니다.일련번호가 생성되는 방식을 원하는대로 제어하고 싶을 경우에 AUTO INCREMENT를 대신해 사용할 수 있습니다 시퀀스는 값을 캐싱하기 떄문에 경우에 따라 AUTO INCREMENT보다 훨씬 빠를 수 있습니다.(CREATE SEQUENCE문의 CACHE 값 한도만큼 캐싱합니다. 기본값은 1000입니다.) 또 다른 장점은 사용된 모든 시퀀스의 생성된 마지막 값에 접근할 수 있도록 하여, LAST_INSERT_ID()의 한계점 중 하나를 해결했다는 것입니다. 시퀀스 생성 CREATE SEQUENCE문은 시퀀스를 생성하는 데 사용됩니다. 다음은 100에서 시작하여 매번 10 씩 증가하는 시퀀스의 ... Read More