![]() This entry was posted in cookbook, debian, linux, mysql and tagged cookbook, debian, installation, linux, mysql by unai. Having ‘binlog_ignore_db’ is enough to exclude databases from replication BUT having ‘replicate_ignore_db’ as well will make things clearer since the databases that are being ignored will appear in both the ‘SHOW SLAVE STATUSG’ and ‘SHOW MASTER STATUSG’. Replicate_wild_ignore_table = exampledb.cache% # Ignore all the cache* tables which have caused DUPLICATE If you want to ignore databases or tables you may use the following options: # Taking care of the auto-increment values (for multi-master replication)įor these changes to take effect, you would need to restart MySQL: Relay-log-index = iamalsounique98127-relay-bin # Unique log names (this prevents replication breaking upon hostname change :-) Log-bin-index = /var/log/mysql/mysql-bin.log Log_slow_queries = /var/log/mysql/mysql-slow.log ![]() These are some settings that I usually put on the /etc/mysql/my.cnf configuration file: # Here you can see queries with especially long duration This is due to the purchase of Sun Mycrosystem by Oracle. MariaDB is a well-known archi Database Relationships Management System that is a MySQL fork. This step is essential if you want to have applications running on your system. Open tables: 17 Queries per second avg: 5.571. So, in this post, you will learn how to install MariaDB on Debian 11. # Start MySQL and check that everything is OK Ln -s /home/mysql/mysql-logs/ /var/log/mysql Mv /var/log/mysql/ /home/mysql/mysql-logs Ln -s /home/mysql/mysql-data/ /var/lib/mysql Now, stop MySQL, move the folders to the right location, reconfigure MySQL and start again: # Stop MySQL ![]() Open tables: 17 Queries per second avg: 26.000. Threads: 1 Questions: 78 Slow queries: 0 Opens: 23 Flush tables: 1 This is free software,Īnd you are welcome to modify and redistribute it under the GPL license This software comes with ABSOLUTELY NO WARRANTY. usr/bin/mysqladmin Ver 8.41 Distrib 5.0.51a, for debian-linux-gnu on i486 To check the status: /etc/init.d/mysql status This article describes how to move these two folders to ‘/home’ which is ideally mounted into another disk and has enough space to keep your database data and logs.įirst, I install the required apt-get packages as follows: apt-get update That may cause your database server system disk to get full, which is never a good idea. By default MySQL keeps them in the root mount point (i.e. While installing MySQL Server it is always good to keep in mind that the logs and data folders will potentially have a big size. ![]()
0 Comments
Leave a Reply. |