#Database scaling

[marrywillson]

Explore how Data PODs leverage blockchain technology for enhanced digital data security, ensuring decentralized control and protection of your information.

[thedbahub]

Troubleshooting TempDB Issues in Azure SQL Database

Azure SQL Database is a go-to for many due to its scalability and managed service offerings. Ensuring optimal performance hinges on properly managing the TempDB, a crucial system database that holds everything from temporary tables to caches for sorting. The TempDB’s size and performance are key to your database application’s speed and efficiency. TempDB and Core Count Explained There’s a…

[king-of-men]

Oh the good old reply-then-block dodge; nice. Nonetheless, with respect to your incisive counter:

not centrally. no. through communication, through collaborative labor. through work

This is money with extra steps. And shortly thereafter it's money without extra steps.

[darkaac]

Fin.

[whentherewerebicycles]

okay well we spent two hours doing a small group brainstorming/planning activity using projects from people’s work and that was actually fun—I love doing that kind of ideation and planning work with people. then we had to sit through 30+ min of whole-group debrief where people stood up and monologued breathlessly about feeling held by the collective as we harvested each other’s wisdom which almost ruined the experience. but luckily I came prepared with a challenge to work through in my head lol.

today’s zoning-out project is mapping out the basic research skills class I’ll be teaching in the spring quarter. one of the big problems I’ve identified in my info-gathering interviews is that students can’t do some pretty basic research things (like reading academic articles, evaluating sources, conducting lit reviews on a given topic, etc) and so faculty don’t want to take them on as summer research assistants because it’s a ton of work to train them in those skills AND familiarize them with the faculty member’s questions and methods AND give them a crash-course on the existing scholarship around this topic. so I am trying to pilot a thing where faculty get extra research funds for taking on a small group of summer students… but my office takes them for a quarter first, trains them in those basic skills and helps them build relationships with the librarians, and has them do all their major activities & assignments using real sources/data related to the faculty member’s project. that way students have 10 weeks to practice the skills and learn at least some of the research before we hand them off to the faculty mentors for the summer. I think we will also provide ongoing mentoring + student services-type support throughout the summer so we can continue working on project management and skill-building type stuff with them individually as they are conducting research… but for now I am focusing on drafting a version of the spring course to workshop with the faculty members who have expressed interest in participating. anyway I am at the very earliest stages but today while zoning out I spent some time trying to unbundle some of the skills that go into engaging with academic sources… needs refining (and maybe even some more unbundling?) but here is a first stab at it:

[boypr1ncesss]

genuinely obsessed w the high of finding undocumented gundam figures and adding them to mfc . like i haven't felt this alive since i was using my dad's university connections (he's a professor) to take out books of med lit from various college libraries so i could scan them . i love archiving

[goodoldbandit]

Data Unbound: Embracing NoSQL & NewSQL for the Real-Time Era.

Sanjay Kumar Mohindroo Sanjay Kumar Mohindroo. skm.stayingalive.in Explore how NoSQL and NewSQL databases revolutionize data management by handling unstructured data, supporting distributed architectures, and enabling real-time analytics. In today’s digital-first landscape, businesses and institutions are under mounting pressure to process massive volumes of data with greater speed,…

[govindhtech]

How Do AutoScaling & Load Balancing Differ From Each Other?

Difference between auto scaling and load balancing

Although both load balancing and autoscaling are automated procedures that aid in the development of scalable and economical systems, their primary goals and modes of operation are different:

Concentrate

Whereas auto scaling concentrates on resource management, load balancing concentrates on traffic management.

How they operate

While auto scaling adjusts the number of servers in response to demand, load balancing divides traffic among several servers.

How they collaborate

Auto scaling can start new instances for load balancing to attach connections to, while load balancing can assist auto scaling by redirecting connections from sick instances.

Additional information regarding load balancing and auto scaling is provided below:

Balancing loads

Distributes requests among several servers using algorithms. Each instance’s health can be checked by load balancers, which can also route requests to other instances and halt traffic to unhealthy ones.

Auto-scaling

Determines when to add or delete servers based on metrics. Application requirements for scaling in and out instances can serve as the basis for auto scaling strategies.

Advantages

Auto scaling can optimize expenses and automatically maintain application performance.

Application autoscaling is strongly related to elastic load balancing. Load balancing and application autoscaling both lessen backend duties, including monitoring server health, controlling traffic load between servers, and adding or removing servers as needed. Load balancers with autoscaling capabilities are frequently used in systems. However, auto-scaling and elastic load balancing are two different ideas.

Here’s how an application load balancer auto scaling package complements it. You can reduce application latency and increase availability and performance by implementing an auto scaling group load balancer. Because you may specify your autoscaling policies according to the needs of your application to scale-in and scale-out instances, you can control how the load balancer divides the traffic load among the instances that are already running.

A policy that controls the number of instances available during peak and off-peak hours can be established by the user using autoscaling and predetermined criteria. Multiple instances with the same capability are made possible by this; parallel capabilities can grow or shrink in response to demand.

An elastic load balancer, on the other hand, just connects each request to the proper target groups, traffic distribution, and instance health checks. An elastic load balancer redirects data requests to other instances and terminates traffic to sick instances. It also keeps requests from piling up on any one instance.

In order to route all requests to all instances equally, autoscaling using elastic load balancing involves connecting a load balancer and an autoscaling group. Another distinction between load balancing and autoscaling in terms of how they function independently is that the user is no longer required to keep track of how many endpoints the instances generate.

The Difference Between Scheduled and Predictive Autoscaling

Autoscaling is a reactive decision-making process by default. As traffic measurements change in real time, it adapts by scaling traffic. Nevertheless, under other circumstances, particularly when things change rapidly, a reactive strategy could be less successful.

By anticipating known changes in traffic loads and executing policy responses to those changes at predetermined intervals, scheduled autoscaling is a type of hybrid method to scaling policy that nonetheless operates in real-time. When traffic is known to drop or grow at specific times of the day, but the shifts are usually abrupt, scheduled scaling performs well. Scheduled scaling, as opposed to static scaling solutions, keeps autoscaling groups “on notice” so they can jump in and provide more capacity when needed.

Predictive autoscaling uses predictive analytics, such as usage trends and historical data, to autoscale according to future consumption projections. Particular applications for predictive autoscaling include:

Identifying significant, impending demand spikes and preparing capacity a little beforehand

Managing extensive, localized outages

Allowing for greater flexibility in scaling in or out to adapt to changing traffic patterns over the day

Auto scaling Vertical vs Horizontal

The term “horizontal auto scaling” describes the process of expanding the auto scaling group by adding additional servers or computers. Scaling by adding more power instead of more units for instance, more RAM is known as vertical auto scaling.

There are a number of things to think about when comparing vertical and horizontal auto scaling.

Vertical auto scaling has inherent architectural issues because it requires increasing the power of an existing machine. The application’s health is dependent on the machine’s single location, and there isn’t a backup server. Downtime for upgrades and reconfigurations is another need of vertical scaling. Lastly, while vertical auto scaling improves performance, availability is not improved.

Due to the likelihood of resource consumption and growth at varying rates, decoupling application tiers may help alleviate some of the vertical scaling difficulty. Better user experience requests and adding more instances to tiers are best handled by stateless servers. This also enables more effective scaling of incoming requests across instances through the use of elastic load balancing.

Requests from thousands of users are too much for vertical scaling to manage. In these situations, the resource pool is expanded using horizontal auto scaling. Effective horizontal auto scaling includes distributed file systems, load balancing, and clustering.

Stateless servers are crucial for applications that usually have a large user base. It is preferable for user sessions to be able to move fluidly between several servers while retaining a single session, rather than being restricted to a single server. Better user experience is made possible by this type of browser-side session storage, which is one outcome of effective horizontal scalability.

Applications that use a service-oriented architecture should include self-contained logical units that communicate with one another. This allows you to scale out blocks individually according to need. To lower the costs of both vertical and horizontal scalability, microservice design layers should be distinct for applications, caching, databases, and the web.

Due to the independent creation of new instances, horizontal auto scaling does not require downtime. Because of this independence, it also improves availability and performance.

Don’t forget that not every workload or organization can benefit from vertical scaling solutions. Horizontal scaling is demanded by many users, and depending on user requirements, a single instance will perform differently on the same total resource than many smaller instances.

Horizontal auto scaling may boost resilience by creating numerous instances for emergencies and unforeseen events. Because of this, cloud-based organizations frequently choose this strategy.

Read more on Govindhtech.com

[marrywillson]

Discover how Data PODs empower users with decentralized data control through blockchain technology, ensuring privacy and security for your data.

[reasonsforhope]

"With Donald Trump set to take office after a fear-mongering campaign that reignited concerns about his desire to become a dictator, a reasonable question comes up: Can nonviolent struggle defeat a tyrant?

There are many great resources that answer this question, but the one that’s been on my mind lately is the Global Nonviolent Action Database, or GNAD, built by the Peace Studies department at Swarthmore College. Freely accessible to the public, this database — which launched under my direction in 2011 — contains over 1,400 cases of nonviolent struggle from over a hundred countries, with more cases continually being added by student researchers.  

At quick glance, the database details at least 40 cases of dictators who were overthrown by the use of nonviolent struggle, dating back to 1920. These cases — which include some of the largest nations in the world, spanning Europe, Asia, Africa and Latin America — contradict the widespread assumption that a dictator can only be overcome by violence. What’s more, in each of these cases, the dictator had the desire to stay, and possessed violent means for defense. Ultimately, though, they just couldn’t overcome the power of mass nonviolent struggle.  

In a number of countries, the dictator had been embedded for years at the time they were pushed out. Egypt’s Hosni Mubarak, for example, had ruled for over 29 years. In the 1990s, citizens usually whispered his name for fear of reprisal. Mubarak legalized a “state of emergency,” which meant censorship, expanded police powers and limits on the news media. Later, he “loosened” his rule, putting only 10 times as many police as the number of protesters at each demonstration.  

The GNAD case study describes how Egyptians grew their democracy movement despite repression, and finally won in 2011. However, gaining a measure of freedom doesn’t guarantee keeping it. As Egypt has shown in the years since, continued vigilance is needed, as is pro-active campaigning to deepen the degree of freedom won.  

Some countries repeated the feat of nonviolently deposing a ruler: In Chile, the people nonviolently threw out a dictator in 1931 and then deposed a new dictator in 1988. South Koreans also did it twice, once in 1960 and again in 1987. (They also just stopped their current president from seizing dictatorial powers, but that’s not yet in the database.)  

In each case people had to act without knowing what the reprisals would be...

It’s striking that in many of the cases I looked at, the movement avoided merely symbolic marches and rallies and instead focused on tactics that impose a cost on the regime. As Donald Trump wrestles to bring the armed forces under his control, for example, I can imagine picketing army recruiting offices with signs, “Don’t join a dictator’s army.”  

Another important takeaway: Occasional actions that simply protest a particular policy or egregious action aren’t enough. They may relieve an individual’s conscience for a moment, but, ultimately, episodic actions, even large ones, don’t assert enough power. Over and over, the Global Nonviolent Action Database shows that positive results come from a series of escalating, connected actions called a campaign...

-via Waging Nonviolence, January 8, 2025. Article continues below.

East Germany’s peaceful revolution

When East Germans began their revolt against the German Democratic Republic in 1988, they knew that their dictatorship of 43 years was backed by the Soviet Union, which might stage a deadly invasion. They nevertheless acted for freedom, which they gained and kept.

Researcher Hanna King tells us that East Germans began their successful campaign in January 1988 by taking a traditional annual memorial march and turning it into a full-scale demonstration for human rights and democracy. They followed up by taking advantage of a weekly prayer for peace at a church in Leipzig to organize rallies and protests. Lutheran pastors helped protect the organizers from retaliation and groups in other cities began to stage their own “Monday night demonstrations.”  

The few hundred initial protesters quickly became 70,000, then 120,000, then 320,000, all participating in the weekly demonstrations. Organizers published a pamphlet outlining their vision for a unified German democracy and turned it into a petition. Prisoners of conscience began hunger strikes in solidarity.

By November 1988, a million people gathered in East Berlin, chanting, singing and waving banners calling for the dictatorship’s end. The government, hoping to ease the pressure, announced the opening of the border to West Germany. Citizens took sledgehammers to the hated Berlin Wall and broke it down. Political officials resigned to protest the continued rigidity of the ruling party and the party itself disintegrated. By March 1990 — a bit over two years after the campaign was launched — the first multi-party, democratic elections were held.

Students lead the way in Pakistan

In Pakistan, it was university students (rather than religious clerics) who launched the 1968-69 uprising that forced Ayub Khan out of office after his decade as a dictator. Case researcher Aileen Eisenberg tells us that the campaign later required multiple sectors of society to join together to achieve critical mass, especially workers. 

It was the students, though, who took the initiative — and the initial risks. In 1968, they declared that the government’s declaration of a “decade of development” was a fraud, protesting nonviolently in major cities. They sang and marched to their own song called “The Decade of Sadness.” 

Police opened fire on one of the demonstrations, killing several students. In reaction the movement expanded, in numbers and demands. Boycotts grew, with masses of people refusing to pay the bus and railway fares on the government-run transportation system. Industrial workers joined the movement and practiced encirclement of factories and mills. An escalation of government repression followed, including more killings. 

As the campaign expanded from urban to rural parts of Pakistan, the movement’s songs and political theater thrived. Khan responded with more violence, which intensified the determination among a critical mass of Pakistanis that it was time for him to go.

After months of growing direct action met by repressive violence, the army decided its own reputation was being degraded by their orders from the president, and they demanded his resignation. He complied and an election was scheduled for 1970 — the first since Pakistan’s independence in 1947.

Why use nonviolent struggle?

The campaigns in East Germany and Pakistan are typical of all 40 cases in their lack of a pacifist ideology, although some individuals active in the movements had that foundation. What the cases do seem to have in common is that the organizers saw the strategic value of nonviolent action, since they were up against an opponent likely to use violent repression. Their commitment to nonviolence would then rally the masses to their side. 

That encourages me. There’s hardly time in the U.S. during Trump’s regime to convert enough people to an ideological commitment to nonviolence, but there is time to persuade people of the strategic value of a nonviolent discipline. 

It’s striking that in many of the cases I looked at, the movement avoided merely symbolic marches and rallies and instead focused on tactics that impose a cost on the regime. As Donald Trump wrestles to bring the armed forces under his control, for example, I can imagine picketing army recruiting offices with signs, “Don’t join a dictator’s army.”  

Another important takeaway: Occasional actions that simply protest a particular policy or egregious action aren’t enough. They may relieve an individual’s conscience for a moment, but, ultimately, episodic actions, even large ones, don’t assert enough power. Over and over, the Global Nonviolent Action Database shows that positive results come from a series of escalating, connected actions called a campaign — the importance of which is also outlined in my book “How We Win.”  

As research seminar students at Swarthmore continue to wade through history finding new cases, they are digging up details on struggles that go beyond democracy. The 1,400 already-published cases include campaigns for furthering environmental justice, racial and economic justice, and more. They are a resource for tactical ideas and strategy considerations, encouraging us to remember that even long-established dictators have been stopped by the power of nonviolent campaigns.

-via Waging Nonviolence, January 8, 2025.

[heartandmusic]

ive been talking such a big game for almost a decade mostly irl about starting a website for my name research as an alternative to baby names sites with historical information and anthropological context and including inline citations and all that and the thing is. two college degrees later and im still sooooo bad at web programming

[nwhales]

You know who has unmitigated access to my (and all of federal employee’s) sensitive information?

Here’s a hint: it’s not tiktok!

It’s Musk. It’s Musk and his goons that have taken over the Office of Personnel Management. I’m not kidding they have physically taken over the physical office and the database that stores federal employees’ information like pay scale, social security number, home addresses, etc. and it’s now left unprotected.

This should concern everyone because the federal government is the largest employer in the country and I can guarantee that you, the like 5 people who may read this post, or someone you know is or has been a federal employee. And now that information is in the hands of Elon Musk and we don’t know what he is going to do with that information. No, seriously, officials who once oversaw the database and protected that data have said that “there’s no visibility into what they’re doing with the computer or the data,” and “there’s no oversight.” Because Musk and his private employees have physically moved and locked people out of their offices and have changed it so that the people who previously oversaw and had access can only get to their emails.

Right now we know that right now Musk and “OPM” is using the data to send poorly worded emails to all federal employees that are meant to coerce and scare people into taking a shitty deal and resigning. But then what? This is the tip of the iceberg. They have so much data and information for millions of people that the possibilities are endless.

So check in on your friends and neighbors who are federal employees. We’re scared and uncertain about so many aspects of our jobs and our lives. We have been hit with wave after wave of insulting emails telling us that we’re not good at our jobs and that actually our jobs are worthless. We’re facing so many rumors about who has our personal information and what’s being done with it. We are just so tired. And it’s week two. That’s the point - to exhaust us into submission. To my fellow federal workers, hold the line. We’re stronger together and we will get through this.

https://www.reuters.com/world/us/musk-aides-lock-government-workers-out-computer-systems-us-agency-sources-say-2025-01-31/

[sakuraszn]

ft. katsuki bakugo

summary: helping defend his kid from other kids on roblox.

“Katsuki.”

No response.

“Katsuki.”

Still nothing. Just the glow of the screen reflecting off his face, jaw clenched, eyes locked in like he was planning a full-scale battle strategy. His fingers flew across the keyboard, clicking with the precision of a trained assassin.

You folded your arms. “Katsuki Bakugo. You are a grown-ass man playing Roblox.”

He finally looked up from your kid’s gaming setup, scowling. “Yeah? And?”

You pinched the bridge of your nose. “And you’re a Pro Hero. You fight real villains. You’ve literally saved the world.”

“Yeah, well, right now, I’m savin’ my kid’s goddamn tycoon,” he snapped, turning back to the screen.

Your child, sitting beside him, was absolutely thriving. “GET HIS ASS, DADDY!”

“ON IT, SQUIRT,” Katsuki barked, fingers moving like he was hacking into a government database.

You sighed, watching your fully grown husband—one of the strongest heroes alive—brutalizing a bunch of kids in Roblox because some 10-year-old named BlazeNinja_44 wouldn’t stop spawn-killing your kid.

The chat was on fire.

BlazeNinja_44: BRO WHO IS THIS

ExplosiveDynamight (Katsuki): UR WORST NIGHTMARE, LITTLE ****

BlazeNinja_44: ?????

ExplosiveDynamight: U LIKE SPAWN-KILLIN’ KIDS? HOW BOUT I SPAWN-KILL UR WHOLE BLOODLINE

Your kid cackled kicking their legs back and forth watching his dad go off for him. “Dad, you sound like one of those gamers.”

“GOOD.” Katsuki cracked his knuckles like he was about to drop a finisher move. “This lil’ bastard deserves it.”

You stared in sheer disbelief as your husband—a fully licensed Pro Hero—went on an unstoppable rampage, obliterating a bunch of middle schoolers in an online Lego game.

And worst of all?

Your kid was cheering him on.

You sighed, rubbing your temples. “I can’t believe I married you.”

“Yeah, yeah, whatever,” Katsuki muttered, eyes still locked on the screen. “y’know you love me.” he grins.

© sakuraszn! xoxo

[totalincandescense]

See the great thing about Phil Lester is he contains multitudes. He is bottle blonde babe, hotter than boiling water husband material. He is a bossy bitch who can bat his eyelashes and get anything he wants. He is a wildly intelligent and interesting person with two college degrees and a catalogue of fun facts to rival Jeopardy’s database. He’s a creative genius and a brilliant storyteller with a brain that needs to be studied in a laboratory. He is passenger princess girlfailure card carrying silly goose. He’s the sweetest man alive. He’s a loser. He’s a stinky baby. He’s a six on the Kinsey scale. He’s the patron saint of lesbians. He has a fat ass. I’m in love with him. He’s also a horrible evil man and I’m going to kill him with hammers (affectionate). What a guy

[asoiafpalestine]

COMMS ARE CURRENTLY OPEN! Send in your submissions now!

ABOUT US:

Our fundraiser was created to help Siraj and his family, and on a larger scale, to bring awareness and aid to Palestinians struggling to survive. You can donate to Siraj at the link above, or check out the causes we've promoted here on the blog under the #campaigns tag.

Bahaa Majid needs funds to afford medical supplies and a wheelchair for his mother, donate here. He also has an additional fundraiser to help fund his education here.

Mai and her family need medical care for her brother and money to leave Gaza when the border opens, donate here.

Gaza Funds has an exhaustive database of active Palestinian fundraisers here.

Crips for eSims for Gaza has a donation portal here, where the money you donate will be used to pay for crucial internet connection for Palestinians. Every image, post, or fundraiser you see from Gaza is made possible by an eSim.

Gaza Soup Kitchen continues to provide invaluable food to Palestinians in need as basic staples become scarce. Donate here.

There are thousands of dedicated accounts on this site that create and continue to update lists of Palestinian fundraisers and charities that require donations. We'll be platforming these as they come up.

HOW TO COMMISSION:

STEP ONE: Choose a fundraiser for Palestinians. This can be one of the linked personal fundraisers, eSims for Gaza, or a larger charitable organization — as long as it’s for Palestine.

STEP TWO: Donate 30 Euros or more to the campaign, and keep a screenshot of your receipt. This is how you will pay for your commission when you send in your prompt.

STEP THREE: Write out your commission specifications and collect any helpful images, such as reference photos, fancasts, or character sheets (if submitting an OC) Please note that we do not accept requests for specific artists. This is in order to keep the workload equal and voluntary among our contributors.

STEP FOUR: Using your tumblr account, submit your commission info AND the screenshot of your receipt in an ask to this blog.

STEP FIVE: Once you have submitted your info, a member of the team will contact you over DMs to confirm we have received your commission.

THAT’S IT! Thanks for donating! When your commission is done, we’ll tag you in the post!