How to use Xtrabackup to rebuild Slave from Master in MySQL

In this article we will learn about the Percona’s Xtrabackup to rebuild slave from master in minimum time and without locking out the tables.

 

What is Percona XtraBackup:

Percona XtraBackup is a free, open source, complete online backup solution for all versions of Percona Server for MySQL, MySQL ® and MariaDB®. With over 2,100,000 downloads, Percona XtraBackup performs online non-blocking, tightly compressed, highly secure backups on transactional systems so that applications remain fully available during planned maintenance windows.

 

Advantages of Percona XtraBackup over MySQLdump:

  • Fast and reliable backups
  • Uninterrupted transaction processing during backups
  • Savings on disk space and network bandwidth with better compression
  • Automatic backup verification
  • Higher uptime due to faster restore time

 

XtraBackup is mostly used while we copy Master data to Slave, while rebuilding Slave server we can use it very effectively without any downtime on master.

Using XtraBackup to rebuild Slave from Master MySQL:

Master:
10.10.10.1
Slave:
10.10.10.2

On Master:

 

 

On Slave:

 

On Master:

Make sure scp is enabled between the servers.

On Slave:

 

 

  • innobackupex records the point in the innodb log where it started.
  • It then copies all of the logs to a file. At the same time it does a raw copy of all the data files in the datadir.
  • You need to apply the logs, either before or after you move the logs.
  • After you have applied the logs, put the files in the right place.
  • Once all files are in place and have the correct permissions.
  • Start mysql, reset master and slave, point GTID to the correct place, change master, and start slave.
  • The slave should now be insync and catching up to the master.

That’s all for XtraBackup, please comment for any suggestion or concerns.

 

Top 5 Inspiring Movies for Programmers

Hello all, Today I will tell you about the top 5 inspiring movies for Programmers that inspired me to get more into programming. These movies are my personal choice and our interest may differ, I’ll not talk about the movies where some random guy sitting on multiple screens is hacking the whole world. I prefer movies based on true stories and events, based on real life inspiring people. Hope you would like them.

 

1. Pirates of Silicon Valley (1999)

Pirates of Silicon Valley

Pirates of Silicon Valley is directed by Martyn Burke. It stars Noah Wyle as Steve Jobs and Anthony Michael Hall as Bill Gates. The film is based on Paul Freiberger and Michael Swaine’s book Fire in the Valley: The Making of The Personal Computer. It explores the impact of the rivalry between Jobs and Gates on the development of the personal computer. This is must watch.

 

2. The Social Network (2010)

the social network

This film is based on the founder of Facebook, Mr. Mark Zukerberg. Harvard student Mark Zuckerberg creates the social networking site that would become known as Facebook, but is later sued by two brothers who claimed he stole their idea, and the co-founder who was later squeezed out of the business.

 

3. The Internet’s Own Boy: The Story of Aaron Swartz (2014)

The-Internets-Own-Boy-The-Story-of-Aaron-Swartz

The story of programming prodigy and information activist Aaron Swartz, who took his own life at the age of 26.

 

4. Takedown (2000)

Takedown (2000)

Takedown is a film about computer hacker Kevin Mitnick, the topmost hacker in the world. It is based on the book Takedown by John Markoff and Tsutomu Shimomura.

 

5. Jobs (2013)

Jobs (2013)

The story of founder of Apple, Mr. Steve Jobs, how he went this far.

 

I hope you have like my list of top 5 inspiring movies for Programmers. Please add other movies in comment if they helped you to grow more interest in programming.

Difference between Application Software and System Software

Today we’ll talk about the difference between Application Software and System Software with the help of examples.

System Software:

System software is general purpose software which is used to operate computer hardware. It provides platform to run application software. For example operating systems like windows, linux.

Application Software:

Application software is specific purpose software which is used by user for performing specific task. For example computer games, office, chrome.

 

Now we’ll talk about some basic difference between Application software and system software:

 

S.No.System SoftwareApplication Software
1.System software is used for operating computer hardware.Application software is used by user to perform specific task.
2.System softwares are installed on the computer when operating system is installed.Application softwares are installed according to user’s requirements.
3.In general, the user does not interact with system software because it works in the background.In general, the user interacts with application sofwares.
4.System software can run independently. It provides platform for running application software.Application software can’t run independently. They can’t run without the presence of system software.
5.Some examples of system softwares are compiler, assembler, debugger, driver, etc.Some examples of application softwares are word processor, web browser, media player, etc.

 

Please comment if you have any difference which I couldn’t specify.

TutorialsPoint Offline Version Download 2017 [Full Website]

Here you get link for TutorialsPoint offline version download 2017 for free (latest full website).

TutorialsPoint is an educational website that provides programming languages tutorials. It covers almost all the languages like C, C++, JAVA, C Sharp, HTML, CSS, JavaScript, PHP, ASP.Net, SQL and many more. TutorialsPoint is getting more than 30 million visits per month and it is the most popular programming language tutorial website on the internet. The tutorials are very helpful for beginners to learn any programming language. It also provides thousands of examples and facility to edit and execute them online in their own online IDE for many languages.

 

The biggest drawback of TutorialsPoint is that you can’t access these awesome tutorials without internet. Fortunately I have found a great solution for this problem. So in this article I am sharing the link to download TutorialsPoint offline version for absolutely free.

 

Steps for TutorialsPoint Offline Version Download 2017:

  1. Download the compressed file from the link: tutorialspoint.zip
  2. Above link will directly download the file.
  3. Just extract it using any software like WinZip / WinRaR.
  4. Now go to the extracted folder and open index.html file
  5. This will open tutorialspoint offline version into your default web browser.

tutorialspoint offline version download

Please comment if you face any problem.

Download Turbo C++ for Windows 7/8/10*

What is Turbo C++?

TurboC++ for Windows is a modified version of the Borland Turbo C++ that can be run on newer versions of Windows, such as Vista, 7, 8 and 10. The application sports all the features of the old IDE, eliminating all the incompatibility issues that are encountered in a normal Turbo C++ installation on modern Windows editions.

TurboC++ for Windows bundles all the features of the old IDE; it includes a compiler, a debugger, the DOS shell, breakpoints, code inspection, watches, tracing, to name the most important ones. The program also incorporates a few project samples and runs in full screen mode only.

Will it work in Full Screen Mode?

Absolutely yes. The problem with other/old Turbo C++ programs is on Windows Vista+ is that they do not run in full screen mode but this will work just perfect in full screen mode.

This is one of the most reliable alternatives to manually attempting to solve Turbo C++ incompatibility issues with Windows Vista, 7 and 8. The solution relies on the Dosbox and includes a couple of code adjustments to manage the successful launch and proper functioning of the program.

Download Turbo C++ for windows

 

Download Turbo C++ for Windows 7/8/10:

Download Link: Turbo C++ for windows

Click on the above link select the mirror (UK / US) and it will start downloading, the setup is a .exe file, just run it and it will install, in case you face any problem please comment below.

How to install Whatsapp on Java Phones

Today in the smartphone era Whatsapp is one of the most common app which every user must have, but still Whatsapp on Java Phones is not seen much. So follow this article if you want to install Whatsapp on Java Phones hassle free.

WhatsApp is available for various platforms like android, windows, symbian and some s40 phones but not in java so I’ll share you the links to install whatsapp on java mobiles. It is working and has been tested on various Nokia phones like sha 200, C2-03, etc. Still it is not working on some samsung phones. I’ll share a different article on how to install Whatsapp on samsung phones.

Follow the below steps to download and install WhatsApp on Java phones..

 

install whatsapp on java phones

 

Steps to install WhatsApp on Java Phones:

  1. Download both the files (WhatsApp_Messenger.jar and WhatsApp_Messenger.jad) from the link given below in your PC (not in mobile).

WhatsApp_Messenger.jar

WhatsApp_Messenger.jad

2. Copy these files in the same folder inside your phone

3. That’s all, now you can find whatsapp and should be able to run it without any problem .

 

This may not work for Samsung mobile phones as there operating system is little different

 

Comment if you face any problem, thank you.