Comments (9)
Was this ever shipped?
from mysql-cluster.
Hello!
We are considering adding auto-clustering support for the Percona template. What type of replication do you expect to be available? Are asynchronous master/slave replication and Percona XtraDB Cluster with ProxySQL as a balancer by analogy with MariaDB Galera cluster options for you?
Do you use clustered Percona at the moment? If yes, could you describe in more details the specifics?
Please tell us more about the monitoring solutions you prefer for your cases.
Thanks,
from mysql-cluster.
I am currently using MySQL with Master-Master replication. I haven't tested with Percona yet but would like to try.
For monitoring I use Percona PMM, I have added a group of Docker Engine CE
nodes to install Percona PMM by following this guide https://www.percona.com/doc/percona-monitoring-and-management/2.x/install/docker.html, the Docker image https://hub.docker.com/r/percona/pmm-server does not work directly with the Jelastic system, I don't know why.
Then I followed this guide to add sudo access to each MySQL instance: https://www.infomaniak.com/en/support/faq/2346/jelastic-cloud-launching-commands-with-root-access-to-any-container
I installed the client which takes care of recovering data from MySQL servers:
sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
sudo yum install pmm2-client -y
On each instance I created a MySQL user that I called pmm-agent
so as not to pollute the logs, it allows filtering on the interface:
$> mysql -u${DB_USER} -p${DB_PASS}
mysql> CREATE USER 'pmm-agent'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY '${PMM_AGENT_PWD}';
mysql> GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT, RELOAD ON *.* TO 'pmm-agent'@'127.0.0.1';
I had to adjust some MySQL variables to optimize the log feed (from https://www.percona.com/doc/percona-monitoring-and-management/2.x/manage/conf-mysql-slow-log.html):
$> mysql -u${DB_USER} -p${DB_PASS}
mysql> SET GLOBAL slow_query_log = 1; SET PERSIST slow_query_log = 1;
mysql> SET long_query_time = 0; SET GLOBAL long_query_time = 0; SET PERSIST long_query_time = 0;
mysql> SET GLOBAL log_slow_extra = 1; SET PERSIST log_slow_extra = 1;
mysql> SET GLOBAL log_queries_not_using_indexes = 1; SET PERSIST log_queries_not_using_indexes = 1;
mysql> SET GLOBAL log_throttle_queries_not_using_indexes = 100; SET PERSIST log_throttle_queries_not_using_indexes = 100;
Then I connect the clients to the server:
sudo pmm-admin config --server-insecure-tls --server-url=https://admin:${PMM_SERVER_PWD}@${IP_PMM}:443 --force ${DB_NODE_IP} generic mysql-${DB_NODE_ID}
pmm-admin register --server-insecure-tls --server-url=https://admin:${PMM_SERVER_PWD}@${IP_PMM}:443 --force ${DB_NODE_IP}
pmm-admin add mysql --query-source=slowlog --username=pmm-agent --password=${PMM_AGENT_PWD} mysql-${DB_NODE_ID}-slowlog 127.0.0.1:3306
And that's it, you don't need more to have quality monitoring :)
PMM agent can also connect to ProxySQL instead or in addition to MySQL, not sure which is better.
from mysql-cluster.
I'd like to hear more about why you want to switch from MariaDB to Percona? Do you have any issues you are trying to solve?
from mysql-cluster.
I use MySQL without any particular problem, I would especially like to test the Percona solution which replaces MySQL.
I would like to compare performance, see memory restoration...
https://www.percona.com/software/mysql-database/percona-server/feature-comparison
Some big companies use it and on paper it looks better in every way.
from mysql-cluster.
Ok, got your point. Thanks for sharing your thoughts. Might that be an option for you to compare performance of your application based on standalone nodes - MySQL vs Percona? That exercise will be easier for you and the results will be easier to compare.
from mysql-cluster.
It's an option to see that Percona is better, but I already know the result and it doesn't really interest me. The end goal is rather to replace MySQL with Percona without losing functionality.
I would like to have horizontal and vertical scalability which is done automatically, like with MySQL.
from mysql-cluster.
The request is accepted and thank you for all the information you have provided
from mysql-cluster.
The Percona-cluster release is scheduled for the first quarter of the next year.
Thanks
from mysql-cluster.
Related Issues (11)
- Test HOT 2
- Random error on scalable cluster installation HOT 3
- Unable to have a functioning environment after cloning HOT 7
- MySQL - InnoDB buffer flushing HOT 1
- Firewall to allow for replication between MySQL nodes HOT 5
- Horizontal scaling not functional after binlog expiry is passed HOT 17
- Shutting down cluster through jelastic scheduler can break replication HOT 2
- rename master/slave on db cluster HOT 1
- Native ProxySQL Clustering HOT 1
- Multi-region version of this
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysql-cluster.