Oracle VM VirtualBox Manager - Revision history

Rasimsen: /* replication mysql */

2018-11-01T12:38:53Z

‎replication mysql

Rasimsen at 10:42, 1 November 2018

2018-11-01T10:42:36Z

Rasimsen at 10:22, 30 October 2018

2018-10-30T10:22:09Z

Rasimsen at 15:57, 29 October 2018

2018-10-29T15:57:59Z

Rasimsen at 12:07, 29 October 2018

2018-10-29T12:07:06Z

Rasimsen at 11:50, 29 October 2018

2018-10-29T11:50:56Z

Rasimsen at 09:50, 29 October 2018

2018-10-29T09:50:09Z

Rasimsen: Created page with "to install linux ubuntu, go and download iso files : https://www.ubuntu.com/download/desktop/thank-you?country=GB&version=18.04.1&architecture=amd64"

2018-10-29T09:39:23Z

Created page with "to install linux ubuntu, go and download iso files : https://www.ubuntu.com/download/desktop/thank-you?country=GB&version=18.04.1&architecture=amd64"

New page

to install linux ubuntu, go and download iso files : https://www.ubuntu.com/download/desktop/thank-you?country=GB&version=18.04.1&architecture=amd64

← Older revision		Revision as of 12:38, 1 November 2018
Line 116:		Line 116:

	=replication mysql=		=replication mysql=
		+
		+
		+
		+
		+	==How to fix master and slave have equal MySQL server UUIDs MySQL Error==
		+	if you get error on slave database like below
		+	<source>
		+	# mysql -u root -p
		+	#mysql> show slave status;
		+
		+	Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.
		+	</source>
		+
		+	Problem :
		+	Server UUIDs is automatically generated but it was copied when I cloned mysql instance using AWS AMI
		+	<source>
		+	ubuntu@ip-172-31-26-201:/var/lib/mysql$ cat /var/lib/mysql/auto.cnf
		+	[auto]
		+	server-uuid=fea4e713-9552-11e6-a093-06a1a5e379d3
		+	</source>
		+
		+	It can be simply fixed by removing that auto generated auto.conf file and restart MySQL server.
		+
		+	Enjoy your MySQL Master-Slave replication!!!

← Older revision		Revision as of 10:42, 1 November 2018
Line 108:		Line 108:

	https://stackoverflow.com/questions/37879448/mysql-fails-on-mysql-error-1524-hy000-plugin-auth-socket-is-not-loaded		https://stackoverflow.com/questions/37879448/mysql-fails-on-mysql-error-1524-hy000-plugin-auth-socket-is-not-loaded
		+
		+	========================
		+	to install vim editor
		+	<source>
		+	sudo apt install vim
		+	</source>
		+
		+	=replication mysql=

← Older revision		Revision as of 10:22, 30 October 2018
Line 93:		Line 93:
	</source>		</source>

		+	==MySql case sensitive table names issue on Windows/MacOS to Linux==
		+	/etc/mysql/my.cnf file (add the row lower_case_table_names=1)
		+
		+	Note:
		+	*lower_case_table_names=0 > table names are stored as specified and comparisons are case sensitive.
		+	*lower_case_table_names=1 > table names are stored in lowercase on disk and comparisons are not case sensitive.
		+	*lower_case_table_names=2 > table names are stored as given but compared in lowercase.
		+
		+	<source>
		+	[mysqld]
		+	lower_case_table_names = 1
		+	</source>


	https://stackoverflow.com/questions/37879448/mysql-fails-on-mysql-error-1524-hy000-plugin-auth-socket-is-not-loaded		https://stackoverflow.com/questions/37879448/mysql-fails-on-mysql-error-1524-hy000-plugin-auth-socket-is-not-loaded

← Older revision		Revision as of 15:57, 29 October 2018
Line 85:		Line 85:

	Note: On some systems (e.g., Debian stretch) 'auth_socket' plugin is called 'unix_socket', so the corresponding SQL command should be: UPDATE user SET plugin='unix_socket' WHERE User='YOUR_SYSTEM_USER';		Note: On some systems (e.g., Debian stretch) 'auth_socket' plugin is called 'unix_socket', so the corresponding SQL command should be: UPDATE user SET plugin='unix_socket' WHERE User='YOUR_SYSTEM_USER';
		+
		+	==error: mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.==
		+
		+	<source>
		+	sudo mkdir -p /var/run/mysqld
		+	sudo chown mysql:mysql /var/run/mysqld
		+	</source>
		+
		+

	https://stackoverflow.com/questions/37879448/mysql-fails-on-mysql-error-1524-hy000-plugin-auth-socket-is-not-loaded		https://stackoverflow.com/questions/37879448/mysql-fails-on-mysql-error-1524-hy000-plugin-auth-socket-is-not-loaded

← Older revision		Revision as of 12:07, 29 October 2018
Line 85:		Line 85:

	Note: On some systems (e.g., Debian stretch) 'auth_socket' plugin is called 'unix_socket', so the corresponding SQL command should be: UPDATE user SET plugin='unix_socket' WHERE User='YOUR_SYSTEM_USER';		Note: On some systems (e.g., Debian stretch) 'auth_socket' plugin is called 'unix_socket', so the corresponding SQL command should be: UPDATE user SET plugin='unix_socket' WHERE User='YOUR_SYSTEM_USER';
		+
		+	https://stackoverflow.com/questions/37879448/mysql-fails-on-mysql-error-1524-hy000-plugin-auth-socket-is-not-loaded

@@ Line 1: / Line 1: @@
 to install linux ubuntu, go and download iso files : https://www.ubuntu.com/download/desktop/thank-you?country=GB&version=18.04.1&architecture=amd64
-==Internet Connection on VM==
+=Internet Connection on VM=
 I was having the same problem on Ubuntu 12.10 64bit using Virtualbox 4.2.22. Here are the steps I took to solve my problem:
@@ Line 15: / Line 15: @@
 *Hit OK to save your changes
 *Start your VM

← Older revision		Revision as of 09:50, 29 October 2018
Line 1:		Line 1:
	to install linux ubuntu, go and download iso files : https://www.ubuntu.com/download/desktop/thank-you?country=GB&version=18.04.1&architecture=amd64		to install linux ubuntu, go and download iso files : https://www.ubuntu.com/download/desktop/thank-you?country=GB&version=18.04.1&architecture=amd64
		+
		+	==Internet Connection on VM==
		+	I was having the same problem on Ubuntu 12.10 64bit using Virtualbox 4.2.22. Here are the steps I took to solve my problem:
		+
		+	Open Virtualbox Manager
		+	*Select the machine you cannot get internet on in the left pane
		+	*Click the Settings button in the top menu
		+	*Click Network in the left pane in the settings window
		+	*Switched to Bridged Adapter in the Attached to drop-down menu
		+	*Select the name of the network adapter you are currently using on your host machine. I am using wireless so I chose eth0 which is my wireless network adapter. You can check which adapter you are currently using by opening the terminal (CTRL+ALT+T by default) and running ifconfig. It will probably be the eth adapter that shows an inet addr and shows data transfer next to RX bytes.
		+	*Under Advanced, make sure the machine is using the Desktop Adapter Type
		+	*Under Advanced, make sure Promiscuous Mode is set to Allow VMs
		+	*Under Advanced, make sure Cable connected is checked on
		+	*Hit OK to save your changes
		+	*Start your VM