Author: Nirav Logical

AWS RDS MySQL Community from Version 5.5 to 5.7 Quick, Easy and Safe Stapes.

Modify the version of the instance will bring the downtime but it works for small instances. I Like to follow the right stapes to get the upgrade done with Minimum/Zero downtime.

Best, Solution to get the MySQL version upgrade in Amazon Web Services RDS is to create a Read replica and upgrade it multiple version until you got your right version. this process will keep you existing instance up and running while you working on an upgrade. isn’t it cool?

Let’s see what those steps are:

  1. Select RDS instance and create a read replica with Same VPC/subnet group, parameter group, security group etc.
  2. Select the Read Replica and Modify the version to 5.6.x. This time you cannot select Automatic backup or Multi-AZ. ( this can be done later). Keep performing this until you behind 1 version to your final required version of MySQL
  3. Create a custom parameter group of type MySQL Community 5.7 or one which is your final version, Use this custom group at last upgrade you give to your Read Replica i.e. MySQL Community 5.7.
  4. The final version you are modifying: Once Read Replica status is “Available”, select it again and Modify to Version 5.7.x. Along with selecting the Multi-AZ option as of the original Instance and Backup retention to a non-zero value ( Selecting in these steps will change the time required later for promoting Read Replica considerably).
  5. Once Read Replica status is “Available”. Verify the version as 5.7.x or your required last version. Check the Replica Lag in RDS console. This should be zero to proceed with next steps.
  6. Make the Primary RDS instance as read-only by setting parameter “read_only” to “1” in the parameter group associated with Primary RDS instance, if you are storing the Session in the DB then your site gets down by this step.
  7. Promote Read replica so that it will become a Writable.
  8. Change the Endpoint in your application and test whether this new upgrade is working with your application code?
  9. Modify (Rename DB instance identifier) the Original Primary to any arbitrary name. Or change the End Point in the Application
  10. Modify (Rename DB instance identifier) the Original Replica to the name of primary RDS instance.
  11. Take the RDS snapshot of the New version RDS Instance.
  12. take the RDS snapshot of the old version RDS Instance.
  13. Shutdown old version RDS instance.

Declaimer: You can implement this steps for your stage environment, Make sure you app is working with new upgraded DB then upgrade your production server along with your code if required.

Social media Requirements to Habitat

Hello Readers, Today I would like to share with you the thought I have from many years to clear the requirements and usage of the Social media. 

In Current time we have engrossed our self in Short reels, Youtube, Instagram, Facebook and many more Social Media Platform which are somehow becoming life for many people but the most of the social media platform built with the purpose and they served their purpose well and become popular. For example:

Facebook – To Connect Friends and Family members share movements.

Instagram – To share your personal Pictures and video to get noticed

LinkedIn – Professional profile to showcase your skill and experience to get hired or get connected with professionals.

Youtube – Sharing Videos without restrictions.

Facebook’s usage increase when family and friends ware living in the same area or region get settled around the globe. In many cases family also get separated after education, marriage or increase adoption of live-in relationship. Most of the school/college friends ware not able to get in touch after school or college due to one and another reason. Facebook made this very convenience that people who ware in your personal connection can’t lose you until you are using Facebook. 

Instagram’s usage increase when the creative people has the skill to generate the visually appealing contents and they have very fewer people to view that and appreciate the work and skill they have to generate. I.e. person who is an accountant and has the ability to take good photography he/she was unable to arrange a gallery show which is expensive and not something they can take the risk. Instagram fix this gap and become popular. (Creative people means all the people who are working in the visual Entertainment industry.) 

LinkedIn’s usage increase when the existing platform was not truly built for professional or business purpose as they had lots of noise of personal and family content along with that the requirement of the skill getting heigh due to globalization. LinkedIn fills this gap and gets inspired professional people to have a digital resume of their self which make then understand the market need and their value in their industry. 

Youtube’s requirement is very different than other platforms, as the video is something very expansive until webcam/camera introduce for mobile and laptop. Although people who had a separate Handycam or video camera has an only place to store those video is into their PC, CD, DVD or other forms.  To share the video they have to plan for meet and can see that together. For business people need to learn everyday and learning was done through school/university or job experience.  Youtube has changed this whole scenario all to gather and provided a platform for people who like to share video content of any topic and that can be seen by people around the world, that created skill, job and learning platform. 

Now we can see that issues get resolved with the social platforms that made our life easy which is good and I appreciate the usage of the platform. In Many cases, the lake of awareness we as people have started using sharing more information over this platform due to the habits. This habit has also given very sensitive information about an individual. 

Now, this information is getting used to keeping you under the screen so they are planting the content in a way that you like it and you have no sense of time although this platform ware to save time and keep people connected and get benefited in their life these platforms are becoming peoples life. 

To get out of this hypnotization of social media people now need to understand the use of each platform and also make sure to give minimum access to Location, Notifications, audio and video to your smartphones.

Technologies are to help the human in their daily life, it’s not the only thing in life. Try to use Physical Books, Papers to concentrate on your work.