31 Mart 2022 Perşembe

mysqld loglarının saati ile sistem saatinin uyumlu olması

 

#  mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql


mysql> set global time_zone='Europe/Istanbul';
Query OK, 0 rows affected (0.00 sec)

mysql> set global log_timestamps="system";
Query OK, 0 rows affected (0.00 sec)



veya

mysqld.cnf de 

mysqld

default-time-zone = "Turkey"
veya 

default-time-zone = "Europe/Istanbul"

 

log_timestamps="system"



mysql> SELECT @@global.time_zone;
+--------------------+
| @@global.time_zone |
+--------------------+
| Turkey             |
+--------------------+
1 row in set (0.00 sec)


mysql> select now(); system date;
+---------------------+
| now()               |
+---------------------+
| 2022-03-31 19:46:26 |
+---------------------+
1 row in set (0.00 sec)

Thu Mar 31 19:46:26 +03 2022
mysql> 

 

[root@adminlinux ~]# head /var/log/mysqld.log
2022-03-25T11:17:24.066701Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-18) starting as process 21860
2022-03-25T11:17:24.088451Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 254bf671-ac2d-11ec-b68d-525400cdac00.
2022-03-25T11:17:24.096120Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2022-03-25T11:17:24.096185Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-03-25T11:17:24.115078Z 1 [ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to 

[root@adminlinux ~]# tail  /var/log/mysqld.log
Version: '5.7.36-39-57-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona XtraDB Cluster (GPL), Release rel39, Revision 5197785, WSREP version 31.55, wsrep_31.55
2022-03-31T19:52:53.459363+03:00 2 [Note] WSREP: Initialized wsrep sidno 2
2022-03-31T19:52:53.459389+03:00 2 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 1) (Increment: 1 -> 1)
2022-03-31T19:52:53.459428+03:00 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-31T19:52:53.459454+03:00 2 [Note] WSREP: Assign initial position for certification: 17, protocol version: 4
2022-03-31T19:52:53.459477+03:00 0 [Note] WSREP: Service thread queue flushed.
2022-03-31T19:52:53.459506+03:00 2 [Note] WSREP: GCache history reset: 6b23794e-b10f-11ec-9e36-fb8d241d3e07:0 -> 6b23794e-b10f-11ec-9e36-fb8d241d3e07:17
2022-03-31T19:52:53.464572+03:00 2 [Note] WSREP: Synchronized with group, ready for connections
2022-03-31T19:52:53.464595+03:00 2 [Note] WSREP: Setting wsrep_ready to true
2022-03-31T19:52:53.464600+03:00 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
[root@adminlinux ~]#

 

Hiç yorum yok:

Yorum Gönder

Ansible automation platform kurarken dikkat edilmesi gereken noktalar

 1. iç ortamamınızda kullanılacak aap için yerel sertifikalar üretilmeli. Aşağıdaki script kullanılabilir. https://github.com/linuxliste/ara...