UPDATE 3:
If you pay attention to my previous logs I gave, it seems that there was a packages conflicting when installing PXC. after I occurred that Error, I tried apt-get upgrade , then I got:
So I tried: apt-get -f install
It installed some lost packages like mysql-server-5.7
Then I tried to install PXC again by --force-overwrite option:
sudo apt-get -o Dpkg::Options::="--force-overwrite" install percona-xtradb-cluster-57
Now PXC is installed and fortunately my websites are up (but with a problem I’ll mention later! DB is read-only now!)
then I didn’t completed the next steps of this tutorial:
https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/apt.html#apt
it told $ sudo service mysql stop but I started it! to see if my website can be back online again!
I’m not interested to continue the installation! I’m very disappointed for installing PXC, disappointed a lot!
I’m now scared to broke my server more and more! I don’t know how to uninstall PXC and revert everything to my default mysql, it seems a lot of ppl out there have the same problem and unanswered yet:
https://dba.stackexchange.com/questions/210568/dpkg-error-uninstall-percona-xtradb-server-5-7
Now I have several problems, PHPmyadmin is full of errors, it shows me my previous databases but it can’t even show me the Global variables.
A more severe problem is that my PHP applications and websites are able to only read from DB, when I try to write or update something, I get:
It seems that it’s because I didn’t complete the installation and my single node is not able to do WRITE operation:
https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html
So at final, please help me! What Should I do now?
1- Uninstall Percona-XtraDB-Cluster and using the previous mysql? How can it be done?
2- still using it with this 1 single node mode? How? SET GLOBAL pxc_strict_mode=PERMISSIVE; or MASTER ?
3- Completing the installation steps for all 3 nodes? (As I said I’m very disappointed, I don’t want to see these errors anymore in all my other nodes! I Prefer saving my life instead of HA by 3node!)
Or is there anything wrong in my installation tasks? I don’t think so! Because I just entered:
sudo apt-get install percona-xtradb-cluster-57 PXC itself broke everything!