I tried to enable master slave replication this morning and I met this error

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.

[email protected]:/var/lib/mysql$ cat /var/lib/mysql/auto.cnf
[auto]
server-uuid=fea4e713-9552-11e6-a093-06a1a5e379d3

Enjoy your MySQL Master-Slave replication!!!

Last week, one of my colleagues tried upgrading some of core libraries from .net framework 4.7 into .netstandard 2.0 and it got me 3 days to handle THIS shit:

Continue reading →

Magento is one of the most widely used eCommerce platforms today that people to choose to grow their online business. I had a chance to talk about Magento Performance at Magestore.com HQ some months ago to share the best practices to Hanoi community for saving their clients from loosing sales or customers for unhappy experiences on the website.

I met some errors today when working on Microsoft Dynamic RMS database because they customized it and add some triggers. I must check where the triggers defined to fix the issue and this is the query I made.

SELECT      o.[name],
            c.[text]
FROM        sys.objects AS o
INNER JOIN  sys.syscomments AS c
ON      o.object_id = c.id
WHERE   o.[type] = 'TR'

1. Open port 3306  to enable remote connection
2. Login to your mysql with this command

mysql -u root -p

1. Create a new user and grant access

CREATE USER 'username'@'%' IDENTIFIED BY 'userpass';
GRANT ALL ON *.* TO 'username'@'%';
FLUSH PRIVILEGES;