Stack Exchange

I have a situation for which I would appreciate any valuable pointers. I have sql transactional replication configured as below. sql01sqla ---> publisher sql01sqlc --> subscriber sql01sqle ---> distributor. I am testing if I can recover my replication flow , in the event of losing the distribution host, I have put distribution database in full recovery model and am taking log backups every 15mins. After configuring transactional replication, and ensuring a table is in sync, i stopped the agents (log reader and distribution ) on the distribution host. inserted a few records on publication and ensure the log back job of the publisher db is disabled as well. Now restored distribution d...

I have a table in mysql with the following data: | StartDateTime | FinishDateTime | | 2016-08-18 10:00:00 | 2016-08-18 11:00:00 | | 2016-08-18 12:00:00 | 2016-08-18 14:00:00 | | 2016-08-31 17:00:00 | 2016-09-01 09:00:00 | What I would like to get as the output is | Month | Duration | | Aug | 10 | | Sept | 9 | I can get the right output when each record is only within 1 month but I am not sure how to go about crossing month boundaries. Can anyone point me in the right direction? Let's block ads! بخوانید...

In a simple MySQL replication Master-Slave configuration I have a problem where Master tries to coect to itself as a slave on reboot. So when I restart MySQL on Master, I see errors related to the same server trying to replicate to itself and I have to manually run mysql -e "STOP SLAVE;" every time I restart MySQL. How can I disable slave on master for good? Here's the relevant portion of my.cnf: ## Logging binlog_format = mixed log_bin = /var/log/mysql/mysql-bin.log sync_binlog = 1 pid_file = /var/run/mysqld/mysqld.pid log_error = /var/log/mysql/error.log #general_log ...

I need the brief explanation between Multi-AZ and Read replica with exact different on it , I'm deep looking for both . ...