[heroes] Status Galera Cluster | syslog server | ntp
Hi folks --- galera I've some good news: the new Galera cluster for our MySQL databases is up and running. I've enabled monitoring and the (db)proxy setup already, but did not start salt on the machines, yet. During the next days, there should be some time to do some testing and finally start with the import of the current databases one by one. One by one because I want to check first if really all the databases in the old cluster are still needed - IMHO a lot of them can simply be skipped. I like to start with the redmine (aka progress) DB first - and then decide about the rest - objections? ...and of course: any help welcome! Especially from those who have experience with galera clusters or mysql database setups/tuning. --- syslog A note to our Salt gurus: syslog.infra.opensuse.org is up and running, but does not see a lot of incoming events, yet. Can you please place something like: ---- /etc/rsyslog.d/remote.conf $WorkDirectory /var/spool/rsyslog $ActionQueueFileName uniqName $ActionQueueMaxDiskSpace 1g $ActionQueueSaveOnShutdown on $ActionQueueType LinkedList $ActionResumeRetryCount -1 *.* @@syslog.infra.opensuse.org ----- On all our nodes together with an entry like: ----- /etc/hosts 192.168.47.7 syslog.infra.opensuse.org syslog monitor ----- for the case that DNS does not work or the name is not resolvable during boot. --- ntp First of all: I switched to use only ntp1, ntp2 and ntp3 on the nodes. This way, the first DNS entry wins, which is lucky most of the time ntp1.infra.opensuse.org, ntp2.infra.opensuse.org and ntp3.infra.opensuse.org. I did not adapt the salt profile, yet, because I want to hear from you if we might switch over from ntp to chrony ? --- CU ...and have a good night ;-) Regards, Lars -- To unsubscribe, e-mail: heroes+unsubscribe@opensuse.org To contact the owner, e-mail: heroes+owner@opensuse.org
Am Sun, 29 Oct 2017 23:07:08 +0100 schrieb Lars Vogdt <lrupp@suse.de>:
I like to start with the redmine (aka progress) DB first - and then decide about the rest - objections?
No objections, so I moved the database of progress.opensuse.org to the new cluster. So far everything seems to work (still)... Regards, Lars -- To unsubscribe, e-mail: heroes+unsubscribe@opensuse.org To contact the owner, e-mail: heroes+owner@opensuse.org
On Sun, Oct 29, 2017 at 11:07:08PM +0100, Lars Vogdt wrote:
Hi folks
--- galera
I've some good news: the new Galera cluster for our MySQL databases is up and running. I've enabled monitoring and the (db)proxy setup already, but did not start salt on the machines, yet.
During the next days, there should be some time to do some testing and finally start with the import of the current databases one by one. One by one because I want to check first if really all the databases in the old cluster are still needed - IMHO a lot of them can simply be skipped.
I like to start with the redmine (aka progress) DB first - and then decide about the rest - objections?
...and of course: any help welcome! Especially from those who have experience with galera clusters or mysql database setups/tuning.
This is great, thanks a lot! I'll try to get the configs in salt with Christian
--- syslog
A note to our Salt gurus: syslog.infra.opensuse.org is up and running, but does not see a lot of incoming events, yet.
Can you please place something like:
---- /etc/rsyslog.d/remote.conf $WorkDirectory /var/spool/rsyslog $ActionQueueFileName uniqName $ActionQueueMaxDiskSpace 1g $ActionQueueSaveOnShutdown on $ActionQueueType LinkedList $ActionResumeRetryCount -1 *.* @@syslog.infra.opensuse.org -----
On all our nodes together with an entry like:
----- /etc/hosts 192.168.47.7 syslog.infra.opensuse.org syslog monitor -----
for the case that DNS does not work or the name is not resolvable during boot.
Also great! I filed https://gitlab.infra.opensuse.org/infra/salt/merge_requests/93 review please
--- ntp
First of all: I switched to use only ntp1, ntp2 and ntp3 on the nodes. This way, the first DNS entry wins, which is lucky most of the time ntp1.infra.opensuse.org, ntp2.infra.opensuse.org and ntp3.infra.opensuse.org.
What's the reason for this? The NTP servers ntp[1-3].i.o.o have different configuration in salt (they use ntp[1-2].o.o as their NTP servers, plus each other)
I did not adapt the salt profile, yet, because I want to hear from you if we might switch over from ntp to chrony ?
Fine by me, but I suppose it is not in SLE-11, so yet another reason to get rid of those VMs :) Theo
On Tue, Nov 14, 2017 at 11:42:21AM +0100, Theo Chatzimichos wrote:
Also great! I filed https://gitlab.infra.opensuse.org/infra/salt/merge_requests/93 review please
I managed to get it with the formula instead, see: https://gitlab.infra.opensuse.org/infra/salt/merge_requests/94 https://gitlab.infra.opensuse.org/infra/salt/merge_requests/95 Theo
participants (2)
-
Lars Vogdt -
Theo Chatzimichos