Open-source News

The Technical Workloads Where AMD Ryzen 9 7900X3D/7950X3D ...  Phoronix

Linux Distro Reviews: openSUSE Tumbleweed — Part 1  WebProNews

fd Is a Blazingly Fast Way to Find Files on Linux  MUO - MakeUseOf

While the AMD Ryzen 9 7900X3D and Ryzen 9 7950X3D are promoted as great "gaming processors", these new Zen 4 desktop CPUs with 3D V-Cache also have great capabilities for various technical computing workloads thanks to the hefty cache size. In prior articles I've looked at the Ryzen 9 7900X3D/7950X3D in around 400 workloads on Linux while in this article I am looking more closely at these technical computing areas where these AMD Zen 4 3D V-Cache processors show the most strength and value outside of gaming.

How to Get the Best Linux Features With Windows Apps  MUO - MakeUseOf

Transport Fever 2 has a big free upgrade, plus Steam Deck support  GamingOnLinux

Linux Foundation Energy Announces Conference Schedule for LF ...  PR Newswire

BMW Updates iDrive For All Current Models Ahead Of Switch To Android Platform  CarScoops

Atari's 1981 classic revamp Caverns of Mars: Recharged is out now  GamingOnLinux

IceFire Ransomware Exploits IBM Aspera Faspex to Attack Linux-Powered Enterprise Networks  The Hacker News

IceFire ransomware now encrypts both Linux and Windows systems  BleepingComputer

TikTok owner Bytedance this week hosted their CloudFW Open System Firmware Symposium in Beijing where they celebrated the launch of CloudFW 2.0 as they implement Coreboot to replace UEFI...

PipeWire 0.3.67 is now available as the latest version of this now widely used server by the Linux desktop for managing audio and video streams as an alternative to PulseAudio and JACK on the audio side...

While less than one week since the Linux 6.3-rc1 release, already the first batch of Intel (i915) kernel graphics driver updates has been sent to DRM-Next for queuing until the Linux 6.4 merge window kicks off in two months...

Initial Batch Of Intel Graphics Driver Updates Queued For Linux 6.4  Phoronix

Last year I wrote about a Google engineer working on rumble support for the latest Microsoft controllers in conjunction with Microsoft's Xbox team. That patch seemed to have fallen through the woodwork but has been updated and sent out in "v2" form this week for allowing Linux gamers to enjoy rumble functionality with these latest Microsoft controllers...

Linux Patch Updated For Rumble Support On Latest Microsoft Xbox ...  Phoronix

Back in 2021 Ruby merged the YJIT just-in-time compiler that last year with Ruby 3.2 was deemed production grade. There's also been the MJIT compiler that relies upon an external C compiler. And now landing this week in Ruby is RJIT as the newest just-in-time effort...

Postgres DevOps database administrator: A day in the life doug.ortiz Thu, 03/09/2023 - 03:00

A Postgres DevOps DBA plays a critical role in modern IT organizations that rely on Postgres as their primary database management system. The role of a Postgres DevOps DBA involves many responsibilities, skills, and tasks. A few of these include: Managing the database design and architecture, infrastructure management, ensuring high availability, security, and performing routine maintenance tasks (tuning, backup and recovery, and monitoring).

This article summarizes the common responsibilities and skills expected of a Postgres DevOps DBA in today's enterprise environments.

Database design and architecture

Two primary responsibilities of a Postgres DevOps DBA are database design and architecture. This role must have a greater understanding of the application's data storage requirements and the business logic involved. This knowledge includes designing and creating database schemas and tables. It also means configuring indexes and other database objects to optimize query performance, and choosing the right version of Postgres to use. The role must ensure the database is designed for scalability and maintainability, considering future growth and data retention needs.

Performance tuning

Another critical area of responsibility is performance tuning. A Postgres DevOps DBA must be able to identify and resolve performance issues by monitoring database performance metrics and analyzing query performance. The role must also have a deep understanding of the database and be able to configure it for optimal performance, including optimizing queries and indexes, tuning memory settings, and identifying and addressing performance bottlenecks.

Backup and recovery

Backup and recovery are also key areas of responsibility. The DBA must have a solid understanding of backup and recovery solutions and must design and implement a backup strategy that ensures that data is always recoverable in the event of data loss. They must also validate the recovery process and implement high-availability and disaster recovery solutions to minimize downtime and data loss.

Security

Security is another critical area of responsibility. The DBA ensures the database is secure by implementing access controls, encryption, and other security measures to protect the data. They must also stay up-to-date with the latest security trends and best practices and implement them to protect against potential threats.

Infrastructure management

Infrastructure management is also a key responsibility. These DBAs must manage the hardware, network, and storage infrastructure and provision the infrastructure to support Postgres. They must also configure the infrastructure for performance and availability and scale the infrastructure as necessary to accommodate data growth.

[ Related read: 3 tips to manage large Postgres databases ]

Automation and scripting

This role must be able to automate repetitive tasks such as backups, monitoring, and patching using tools like Ansible, Terraform, and Kubernetes. They must also be familiar with automation best practices to ensure tasks are automated efficiently and effectively. Automation reduces the potential for human error, improves efficiency, and allows the DBA to focus on more complex tasks.

More open source career advice Open source cheat sheets Linux starter kit for developers 7 questions sysadmins should ask a potential employer before taking a job Resources for IT artchitects Cheat sheet: IT job interviews Monitor and configure alerts

Monitoring the database and infrastructure and setting up alerts to notify them of issues is extremely important. The role must also take proactive measures to prevent downtime and data loss, using monitoring tools like Nagios, Zabbix, and Prometheus to detect potential issues.

Collaboration

In addition to these technical responsibilities, a PostgreSQL DevOps DBA must also collaborate with other IT teams, such as developers, operations, and security, to integrate the database into the larger IT ecosystem. The DBAs must also document their work and stay up-to-date with the latest trends and best practices in Postgres and DevOps. This involves engaging with stakeholders to gather requirements, establish priorities, and align the database with the organization's broader goals.

Wrap up

In conclusion, a Postgres DevOps DBA plays a critical role in modern IT organizations that rely on Postgres as their primary database management system. How do your current skills and expectations match this list? Are you on the right track to excel as a DBA in modern database environment?

What are the responsibilities of a database administrator (DBA)?

Image by:

opensource.com

Careers Databases What to read next MariaDB and MySQL cheat sheet This work is licensed under a Creative Commons Attribution-Share Alike 4.0 International License. Register or Login to post a comment.

Contribute to open source without code Debra Chen Thu, 03/09/2023 - 03:00

An open source "community" means different things to different people. I think of open source a little like "falling in love" because it is about people and relationships. Treat open source as a community because, without people, there is no source, open or otherwise.

I'm a member of the Apache DolphinScheduler community. Because that project is intentionally low-code, it appeals to many people who aren't software developers. Sometimes, people who don't write code aren't sure whether there's a meaningful way to contribute to an open source project that exists mainly because of source code. I know from experience that there is, and I will explain why in this article.

Contributions to the community

In the Apache DolphinScheduler project, I'm mainly responsible for global operation, influence, and caring for the community.

Some people say that projects are big trees, with open source being the soil. That's an apt analogy, and it demonstrates the importance of actively nurturing the thing you're trying to help grow.

I have a simpler idea: Do everything possible to make it good.

A community requires constant attention, not because it's needy but because it is part of life. Community is the people living amongst you, whether in your physical or online space.

Since joining the open source community, I have independently initiated and organized events, including:

• Coordinated on average one meetup in China a month.
• Recommended the community participate in the technology shares within the big data field.
• Coordinated with almost all of the open source projects within China's "big data" field, visiting and communicating with those communities individually.

In my opinion, an excellent project should grow in a good ecology. And a community needs to go out to exchange ideas, share resources, and cooperate with other excellent communities. Everyone should feel the benefits brought to the community in their work.

My overseas expansion follows the same pattern. Of course, it's difficult to do that effectively due to differences in cultures and languages. It takes energy, but it's worth it.

So far, we have successfully held meetups overseas, including in the United States, India, Singapore, Germany, France, Finland, and more.

So how do I contribute to DolphinScheduler? Am I committing code to the project? Am I a community manager? Do I have an official title?

I think of myself as an assistant. I foster communication and connection, and that, as much as any code contribution, is an example of the "Apache Way."

Get started with DolphinScheduler

I first learned about open source when I worked at OpenAtom Foundation as an open source education operation manager. As China's first open source foundation, OpenAtom operates many projects, exemplified by OpenHarmony.

I joined the DolphinScheduler community and found a group of people who were eager to share knowledge, provide guidance and support, and keen to help others discover a tool they would find useful in their own lives.

DolphinScheduler aims to be an influential scheduler worldwide, helping teams work in an Agile and efficient way.

First impressions of the community

It's common to hear complaints from the community about project development. We all have complaints from time to time. Maybe you reported a bug, but the developers didn't address your problem. Or maybe you had a great idea for a feature, but the team ignored it. If you're a member of an open source community, you've heard these grievances before, and if you haven't, you eventually will.

I've learned that these voices are all important to an open source community. It's a good sign when you hear this feedback because it means the community is willing to find bugs, report them, and ask and answer questions. Hearing those complaints may reveal places in the project's structure that need to be improved. Is there a volunteer from the community who can respond to bug reports and triage them so they get to the right developer? Is there a volunteer group waiting to be formed to respond promptly to questions from newcomers in your project's Discourse or forum?

A greeter at the door of your open source project can help invite tentative community members in. A greeter can also ensure that there's no "gatekeeping" happening. Everyone's welcome and everyone has something to contribute, even if all they can offer is an atmosphere of helping one another.

As much as you or I wish we could solve technical issues for everyone, it's not practical. But anyone can be willing to help find a solution—that's one of the great strengths of a community. These users spontaneously serve as their community's "customer service" department.

Within the DolphinScheduler project, we have many (Yan Jiang, Xu Zhiwu, Zhang Qichen, Wang Yuxiang, Xiang Zihao, Yang Qiyu, Yang Jiahao, Gao Chufeng, and Gao Feng, in no particular order!). Even though they don't develop the solution, they work tirelessly to find the person who can.

Our favorite resources about open source Git cheat sheet Advanced Linux commands cheat sheet Open source alternatives Free online course: RHEL technical overview Check out more cheat sheets Words to the community

If you want to become a committer through non-code contributions or don't have time to make a code contribution, then the first step is to join the community. There's no sign-up form or approval process, but there's also no fast track. You join a community by participating. Through reliable and consistent participation, you develop relationships with others.

I'm available for a chat and always eager to talk about global event organization, documentation, feedback, and more.

Become a committer

Apache DolphinScheduler faces many challenges. Many companies, even ones that support open source, choose non-open business tooling. I want to work with community partners to make DolphinScheduler a world-class scheduling tool. I hope everyone can harvest the technical achievements they want and that DolphinScheduler helps get them there.

Join our community and help us promote an open and Agile way of working. Or find a project in need of your non-coding skills. Find out just how cool and fun it is to empower a community of your peers!

If you want to become a committer through non-code contributions or don't have time to make a code contribution, then the first step is to join the community.

Image by:

(WordPress, CC0 License)

Community management Careers What to read next This work is licensed under a Creative Commons Attribution-Share Alike 4.0 International License. Register or Login to post a comment.