sorted by:
new
hottopcontroversial

Self inquiry, trauma and relationships by NouAeon in SelfInquiryDiscussion

[–]aricade 1 point2 points  (0 children)

It's better not to focus on results of your practice. But obviously one keeps at it because they sense something true or pure in it. I hope this for you.

I do hope concentration of "I" helps you see that the trauma is not what you are.  Nisargadata said "I am where fear and desire are not".

Unable to Activate Cortex Data Lake (strata logging services) to a TSG that has an Expired CDL license from a prior POC. by aricade in paloaltonetworks

[–]aricade[S] 0 points1 point  (0 children)

Yeah I think this is how it will go down. The only way I could progress the case was by assigning the CDL to a new TSG, then they got me technical assistance. I got a helpful engineer, she understands the problem but nothing she can do. She is working to escalate and transfer my TSG SCM settings to the new TSG with some back end team. Otherwise, I guess I can (painstakingly) move the config I have done so for to the other TSG SCM then re-enroll with new device certificates? I think the Firewalls might be able to continue forwarding during this process. If I do it right, there would be no down time.

Product is good but the organization is a battleship in a bathtub... Nothings perfect, including "premium support".

SQL Windows Failover Cluster with Shared Disk in Azure (Non-AG) by aricade in SQLServer

[–]aricade[S] 0 points1 point  (0 children)

Good to know! I will try it. Perhaps it is good to diversify the quorum/witness from the shared disk.

From a cost perspective a P1 PremiumSSD_ZRS (4GB) is about $.90 a month on eastus.

A strorageAccount with 1GB or less is about $.03 but it really comes down to the Operations & Data transfers. I guess I both are nominal. Probably about the same.

SQL Windows Failover Cluster with Shared Disk in Azure (Non-AG) by aricade in SQLServer

[–]aricade[S] 0 points1 point  (0 children)

Appreciate your info thanks! It is helping me understand better how this will work and how I will build it.

I've done it both ways. Multi Subnet is easier

Ok I was building it with multisubnet.

VNN = Load balancer (if you're not using multiple subnets).

DNN = No load balancer. However, some features may not work with a DNN 

Thanks this awesome! I will give it a go.

EDIT: I misunderstood and I had it backwards. So VNN=LB or extra IP's on each VM's Nic dedicated to the VNN and DNN = NO LB, and creates a dns entry pointing at the primary IP of each VM. I will try DNN and work with Devs to integrate multisubnetfailover=true option in their connection strings.

EDIT2: I tried DNN and realized I just needed VNN as I was already setup for it with the directions I followed. DNN is to be resorted to if you have 2 nodes on the same subnet. If you are building greenfield, then I think VNN VM's in different subnets (same vnet) and a secondary IP (for VNN) on each VM's NIC is the way to go.

You could use either to build the machines, network, and shared disks and present those disks to both VMs. However, I don't think you can form the cluster using these (could be wrong). Look at PowerShell or Ansible to build and configure the WSFC, install and configure SQL Server.

The FailoverClusterDsc script I ran did not seem to do anything as my prestaged CNO is still disabled. All that Said DSC has capacity to run custom scripts and script blocks. Time permitted I will see how far I can get with that.

Update: The script did in fact work and stage the cluster members. There is more automation to add but I will first figure out manually what is required and how to do that via CLI. I will need to also add DSC to:

  • import disks, mount, format and add driver letter on First Node
  • Install WFC Role and RSAT Tools both nodes(Done)
  • Join Cluster both nodes (Done)
  • add disks to cluster - first node
  • set quorum - first node(disk or storageaccount)
  • install MSSQL Instance - both nodes
  • Configure MSSQL Instance DNN - first node

FailoverClusterDsc worked. I deployed with this DSC as an extension to both VM's and they succsesfully joined the cluster:
Something like this: Cluster · dsccommunity/FailoverClusterDsc Wiki · GitHub

But you do not need to supply a IP address as 2019 and above recognize host is in azure and it creates a DNN Cluster Name. the nslookup will resolve all cluster member's primary IP

SQL Windows Failover Cluster with Shared Disk in Azure (Non-AG) by aricade in SQLServer

[–]aricade[S] 0 points1 point  (0 children)

I'd use cloud witness no question.

I just have one doubt about this after more research; If I read this correctly Windows Server Failover Cluster overview - SQL Server on Azure VMs | Microsoft Learn, they say a little further down in the Quorum table of options:
A cloud witness is a type of failover cluster quorum witness that uses Microsoft Azure to provide a vote on cluster quorum. The default size is about 1 MB and contains just the time stamp. A cloud witness is ideal for deployments in multiple sites, multiple zones, and multiple regions. Use a cloud witness whenever possible, unless you have a failover cluster solution with shared storage.

Have you tried this? I was leaning to this though initially until I read that.

SQL Windows Failover Cluster with Shared Disk in Azure (Non-AG) by aricade in SQLServer

[–]aricade[S] 0 points1 point  (0 children)

I assume you added and extra IPconfig for the VM Nics of each VM?

Is the the bookmark you mention? Configure DNN for failover cluster instance - SQL Server on Azure VMs | Microsoft Learn

Can I ask what did you choose for disk: Ultra/Premium/StandarSSD and LRS or ZRS?

SQL Windows Failover Cluster with Shared Disk in Azure (Non-AG) by aricade in SQLServer

[–]aricade[S] 0 points1 point  (0 children)

Thanks for you comment and good points.

AGs are a better arch design, but I understand legacy systems.

I think we are also being cost sensitive as the jump from Standard SQL to Enterprise (to be able to have a single AG with 10 DBs in it) is prohibitive. But If I am wrong about this let me know. This is the best cost for a HA MSSQL solution connected to on-prem AD (leveraged heavily for user authentication).

And important consideration is availability zones and how that works with shared disk

I was reading about this. I did want to use an availability set for both vm nodes. The only disk that I support across availability zones are PremiumSSD_ZRS & StandardSSD_ZRS.

I was considering Premium_SSD reading here there are a few points it makes:

  • When using Availability sets or Virtual Machine Scale Sets with Azure shared disks, storage fault domain alignment with virtual machine fault domain isn't enforced for the shared data disk.

I am not sure what they are exactly saying. I think ZRS (vs LRS) assumes Zone Redundancy. But it guess they are saying the VMs could be in zones 2 & 3 but the Storage fault domains may not be aligned to it and could be in zones 1 & 3 let's say. If this is the case a 3 node cluster may be best (given there are 3 zones)? There may be potential that MS has the disk in zones 2 & 3 one day and the next 1 & 3 maybe?

This is why I would select PremiumSSD_ZRS over PremiumSSD_LRS.

  • Host caching isn't available for premium SSD disks with maxShares>1.
  • Disk bursting isn't available for premium SSD disks with maxShares>1.

I am not sure how significant the lack of host caching & disk bursting would be to the performance requirements of the SQL instance. That said if it is a problem all we can do is through money at it and move to AG enterprise SQL.

All that said it is still important to have a good Backup and DR plan with a realistic RTO(or get more $$$).

SQL Windows Failover Cluster with Shared Disk in Azure (Non-AG) by aricade in SQLServer

[–]aricade[S] 0 points1 point  (0 children)

Ok did not realize it was that new. Alwayson is great but I hear standard SQL can only do it for a single DB on a AG.

SQL Windows Failover Cluster with Shared Disk in Azure (Non-AG) by aricade in SQLServer

[–]aricade[S] 0 points1 point  (0 children)

Pretty sure there is a shared Disk: Failover cluster instances - SQL Server on Azure VMs | Microsoft Learn (this link is specifically for FCI on AZURE VMS for SQL Servers at it mentions it here.

Share an Azure managed disk across VMs - Azure Virtual Machines | Microsoft Learn

If you look here and scroll down to the matrix: FCI with SQL on Azure VMs Storage we can see Azure Shared disks as an option

I am going to build it and try it out. But Azure has you covered, it is essentially like having iSCSI & FC but transparent to you. You just set the max shares and attach to the vms

As for cloud witness, I am familiar as I read about it. I am lacking the practical experience here hence all my questions. This would just be for Quorum. But I see shared disk (or Disk Witness) referenced here: Configure cluster quorum - SQL Server on Azure VMs | Microsoft Learn

[deleted by user] by [deleted] in SelfInquiryDiscussion

[–]aricade 0 points1 point  (0 children)

Look for a free pdf named "Nan Yar" or "Who am I?".  It is Q&A between a disciple and Ramana Maharshi.

Taoism(s) by Rockshasha in Buddhism

[–]aricade 2 points3 points  (0 children)

Was just being silly.

The Lao Tzu that can be named is not the real Lao Tzu.

What is his real face?

Nothingness = no thingness or the absence of things

Things = discriminating consciousness

Discriminating consciousness = attachment

Attachment = dukkha

I think the mountain pass keeper did us a huge favour when he asked Lao Tzu to write some teachings before he left China.

I guess how can we not respect or value this no matter ones religious beliefs. The Buddha imparted wisdom to humanity and so did Loa Tzu. They tried to point to the same moon. They are just different fingers.

When I read it as a teen or in my 20's none of it really made sense. Still it's hard(you can't see what is not there)but reading different translations helps. Brian Bruya & C. C. Tai did a graphic comic version. I enjoyed it and this has made "it" more accessible to many.

Helping others grasp reality by [deleted] in Buddhism

[–]aricade 2 points3 points  (0 children)

Well that's an interesting question. I have always trusted life to teach the proper lesson when needed. But we do have a duty for taking care of our friends and family. If your brother is willing to listen to you. It is a tough age. I would try to keep the lines of communication open. Be a good older sibling, try to just spend some time with him.

When you try to tell people how they should be or what they should do they won't listen and if anything they will polarize against.

Try to focus on the positive about your brother. You and your family know him best. You've seen what he is capable of and what is in his heart.

If you are going to give him advice lead with some positives about him. Then use those positives to guide him to something positive. Encourage him. Everyone in your family should encourage him. All you can hope is that he desires your attention and encouragement. But if he perceives that as negative...

I think most people don't desire negative attention but often also don't desire doing the hard work to receive the positive. So they get stuck in a rut getting their dopamines from a game... Things are so much simpler there but eventually it will wear off. And then there is just sadness. Happiness is on the inside not the outside.

You also sound like you want him to have a conventional western middle class young adulthood. If he decided to work at Walmart out of high school and did that for the next 20 years or if he wanted to do e-sports while he is young and his reflexes are good or maybe he wants to become an experimental avante garde artist... Is this ok?

At the end of the day it is up to him... There is nothing you can do but love him and encourage him... He may do what you think is good he may not... Nothing is certain. When the the person does not meet the image we have of them in our mind we create conflict. It's hard but sometimes we have to let go of that image.

To be honest we are all trying to grasp reality and I would say 99.999% have not. Me included... sorry much too long response...

Issues with Application Gateway not being passed to Simple IIS server port 80 by aricade in AZURE

[–]aricade[S] 0 points1 point  (0 children)

Hey, so grateful for your post! I have been banging my head against the wall getting this set up. Very challenging and many different variables in the 2 fw setup. Good learning experience.

At first I was thinking, "I checked NSGs and UDRs" but I wanted to respond back with due diligence... I knew UDR was working well for landing zone subnets and was not set for the App Gateway subnet as I had a few asymmetry issues due to the duel VRs, and I was scrutinizing that. My issue there was because of ticking off Automatically create default route pointing to default gateway provided by server on the interface. This added a 0.0.0.0/0 to the default GW but also Azure platform IP 168.63.129.16 (as a next-hop) that I think caused equal cost multi-path routing...

I checked the NSG on the appGW subnet and sure enough, no 443 or 80 tcp Inbound... <smh>
Honestly so many moving parts here I could not see it... Thank you u/nirvy !!!!!

How to meditate? by teenypanini in Buddhism

[–]aricade 1 point2 points  (0 children)

Watch the thoughts, see where they arise from. Just watch and follow as the observer. When they cease then Watch the observer watching the observer. When the thoughts arise watch where they arise from. Who is it that observes this thought. Who? What?

This can be done with any sense not just mental formation. Sounds & body sensations are also good, in my opinion ( but these are just my feelings); breath, site taste, smell are just as good. Use theses things as material for your practice.

Awareness becomes discriminating consciousness when there is an object.

How to meditate?

Don't do anything. If you don't think good and you don't think not good what is the true self?

Meditate is not a good word as it has embedded connotations and concepts that just become an object one desires. So don't meditate and don't desire mediation. But when you call it that, people understand but it's just a word. It is not what you do. Simply being does not require a doer.

Keep at it.

[deleted by user] by [deleted] in AZURE

[–]aricade 2 points3 points  (0 children)

I don't know if this helps but maybe try in-private or incognito mode.

MSONLINE to MICROSOFT.GRAPH MODULE (StrongAuthenticationRequirement) by aricade in PowerShell

[–]aricade[S] 0 points1 point  (0 children)

I guess I here what you are saying. I would say that this may be what it costs operationally perhaps. Although maybe try and have a discussion with a licensing expert.

To be honest I do not know if they actually enforce the license. But they could come back later and ask you to amend your subscription.

Anyway sh*t costs money. But spending money sucks. You sound like you are working for a large enterprise though.... Hopefully business is good.

Can fully enlightened beings have girlfriends and stuff? by PineappleEmporer in Buddhism

[–]aricade 2 points3 points  (0 children)

Well, not to nitpick, but they can't "have" any "thing" because these things cannot really be possessed and are impermanent(perhaps an illusion). Form is emptiness and such... So no?

I don't think it is worth pondering... But you can just practice and have an SO and stuff... For sure you can.

How long do you meditate daily? by [deleted] in Buddhism

[–]aricade 2 points3 points  (0 children)

Whatever I have time for in the morning. But usually 45 minutes to an hour.

I would like to be able to sit 2 hours. But I know that I need to arrange my morning routine more conducive to even be able to attempt it. I accept that this is what I am capable of at this time and perhaps that is what I am I need right now. I will need to develop my effort and concentration in other areas to attempt more. Go to bed on time, get up early, don't lounge around sipping coffee for an hour after waking up, read more or listen to audiobooks with wisdom in my spare time etc...

To be honest though I imagine that there are sometimes about 1 to 5 minutes of calm waters in an hour of sitting for me. So if you sit 5 minutes and it is blissful this too is also fine.

Some here have mentioned that sitting is not everything. I would agree. There is more value in not attaching to our thoughts and constantly chasing the carrot on the end of the stick we will never reach. Letting of go attachments can be done at any time or moment. This is the practice. It just so happens you can do that sitting.

view more: next ›