New answers tagged

0

My configuration works just fine, forgot to add port 4567 on each node IPs and removed the options. group="galera-testing" address="gcomm://10.10.10.15:4567, 10.10.10.16:4567, 10.10.10.17:4567" log="/var/log/garbd.log" Now my 2-node galera works. Even if one goes down, I can still transmit data to the database.


0

Two node galera is a fundamentally broken design as it cannot maintain uptime without a quorum and the ability of a node to go down to aid recovery. garb is a toy test thing and not a production tool. Use 3 nodes all as full galera member nodes. Use haproxy in a redundant configuration on all nodes. Use a different IP addresses for haproxy and galera without ...


1

Probably not a good idea to add transactional replication to an already struggling db, have you enabled read committed snapshot isolation on the database ? Assuming you have already added appropriate indexes this is normally this is a good place to start with blocking and deadlocking issues (assumes your application uses read committed the default ...


0

use sp_helppublication see BoL for full syntax and a description of the result set https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-helppublication-transact-sql?view=sql-server-ver15


0

This answer has been copied from the accepted answer on this question of Stack Ovweflow: How to determine the SQL Server replication type by TSQL? Run the following query on the distribution database: SELECT P.Publication ,P.Publication_type ,S.Subscriber_ID ,S.Update_Mode FROM MSPublications P INNER JOIN MSSubscriptions S ON ...


0

Found out the option MASTER_BIND is for use on replication slaves having multiple network interfaces, and determines which of the slave's network interfaces is chosen for connecting to the master Thanks


0

You can delete the single channel by deleting the entry from the table mysql.slave_master_info. For example: delete from slave_master_info where channel_name=''; And then use the query to show slave status running status something like below: SELECT channel_name AS Channel_Name, smi.host AS Master_Host, smi.user_name AS Master_User, smi....


0

If you define the foreign server using host and port connection parameters, these data are part of the PostgreSQL metadata and replicated. Streaming replication creates an identical copy of the database. So you'd have to define the foreign server using connection parameters that refer to a file outside the database proper. What comes to mind is the service ...


1

If slave_parallel_workers is changed from default 0 value then a number of events applier threads will be launched. Independent events are applied in parallel. If some event is dependant on another one (say INSERT and then an UPDATE to the same row), an UPDATE event will be applied sequentially after the INSERT. Threads dependant on some other event becomes ...


1

You can use a Temporal Table at the subscriber for this, although you need to use some custom initialization scripts to preserve the history table at the subscriber. Then insert at the publisher and delete whenever you want. Both the insert and delete will be replicated to the subscriber, and the history table will have the data after it's deleted from the ...


0

The root cause of this was connection timeouts because the availability group was in a Multi-subnet Availability Group. This was resolved by following this document from Microsoft.


0

I've tried my approach and partially worked. After manually changing ( with mariadb stopped ) master-bin.index the slave started working again but only Master_Log_File was increasing Master_Log_File: master-bin.000319 Relay_Master_Log_File: master-bin.000312 Slave_IO_Running: Yes Slave_SQL_Running: Yes As if slave was only reading but not writing. So I gave ...


0

Finally solved it! Our IPS (Ubiqity Firewall) identified this particular connection as a threat and disconnected it every time. Why it identified one client as a threat and not also the other one too, we don't actually know. Accepting Laurenz Answer as his first intention was oviously right.


2

That is a networking problem. The message and the lack of server log entries prove that you didn't reach the database server. You'll have to use standard network debugging techniques to solve this problem.


0

Anti-OPTIMIZE If you are using InnoDB (which you should be using), then OPTIMIZE TABLE is almost totally useless. Stop running that. If you are DELETEing huge chunks of a table, and that led you to want to OPTIMIZE, then let's discuss alternatives. Replication issues It is possible to avoid replicating any command(s): SET SESSION binlog = OFF; -- I ...


0

You can follow these steps before setting up a Publication. Tutorial: Prepare SQL Server for replication (publisher, distributor, subscriber) Create Windows accounts for replication. Prepare the snapshot folder. Configure distribution. I believe you skipped this. If not, please edit you question with the steps you already followed successfully.


Top 50 recent answers are included