All Questions
Tagged with upgrade replication
21 questions
0
votes
1
answer
56
views
Postgres server migration and version upgrade
We are migrating a 2TB server with a very large amount of BLOBs from an on-premises server to a cloud server. During the migration, we'd also like to update the Postgres version from 14 to 16.
Now due ...
- 1
1
vote
0
answers
188
views
AWS RDS MySQL "manual" read replica in "Waiting for dependent transaction to commit" state but lag is zero
I have an SOP I use to upgrade AWS RDS instances running MySQL with no downtime that I have been following since 2021. I'll outline my method below, but it involves manually hooking up a new master ...
- 111
1
vote
0
answers
763
views
Upgrade Replication MySQL from 5.7.34 to 8.0.28 without database downtime
I have to upgrade a MySQL replication topology from 5.7 to 8.0 without database downtime. It’s MySQL Community Edition.
There is one source and 5 replicas in the topology and connections happen via ...
- 226
2
votes
1
answer
2k
views
How to rollback to earlier SQL Server version without data loss after SQL Server upgrade
We are planning for SQL Server 2019 upgrade from SQL Server 2014 version. One of the requirement from the business owners is that we should be able to fall back to earlier version without data loss ...
- 21
0
votes
1
answer
351
views
Upgrading Logical Replica of PostgreSQL
I am trying to upgrade a logical replica from PostgreSQL V10 to V13. We are using pglogical for the logical replication.
Though the upgrade process of the replica can be done, however the replication ...
- 532
3
votes
1
answer
2k
views
Postgres major version upgrade using replication server
I am planning to upgrade my database from Postgres 10 to Posgres 14. To reduce the downtime, I plan to use the replication for the same. Plan (in short) is to:
Dump the data using pg_dumpall
Kill the ...
- 131
0
votes
0
answers
314
views
MariaDB upgrade fails on replication slaves
I am having problems when a MariaDB replication slave wants to upgrade its tables after a server was patched. This happens consistently with any sort of OS patching.
The system has several slave ...
- 101
0
votes
1
answer
290
views
Transactional replication upgrade from SQL Server 2017
We would like to inplace upgrade of transactional replication topology from SQL Server 2017 to SQL2019 with minimal downtime. The following is the setup. All the all current instances are on SQL ...
- 113
0
votes
1
answer
144
views
how to upgrade postgresql 9.0.4 to latest with minimum downtime
I have master-slave-slave setup for postgresql 9.0.4 in our production setup.
We need to upgrade it to latest (11.X), so my question is what would be the procedure to do so with as little downtime as ...
1
vote
0
answers
34
views
SQL Server upgrade re-initializes subscriptions
I recently, in a test environment, upgraded my SQL Server Distributor from 2012 to 2017. The upgrade went off without a hitch but I noticed that after the upgrade was completed all of my subscriptions ...
- 11
5
votes
1
answer
2k
views
Upgrading Master-Slave MySQL
I'm experimenting with MySQL replication with MySQL 5.5.52.
My main problem is: how to do "apt-get upgrade" on a master-slave setup properly?
Until now I upgraded the slave then failed over and ...
- 103
1
vote
0
answers
317
views
Replacement for transactional replication
My colleagues and I have to migrate a database from SQL Server 2008 R2 to SQL Server 2012.
Schema, triggers, stored procedures etc. are working fine. But we also have to "migrate" the replication ...
- 352
0
votes
1
answer
656
views
MySQL percona 5.6 to MySQL 5.5 replication
Scenario 1 I am having a MySQL DB on 5.5 which is compliance, So need to upgrade it to MySQL 5.6. while doing this we see that 5.6 is running slow, were as it runs perfectly on 5.5 backup.
Scenario ...
- 159
0
votes
2
answers
2k
views
Upgrading the mysql server from 5.1 to 5.6?
My server have CentOS6. Currently I'm are using the Percona 5.1.47 version. Would like to upgrade to 5.6.
What is the best way to do, and what are the prerequisites to keep in mind before doing ...
- 59
5
votes
1
answer
3k
views
Replication stops with GTID_NEXT error after creation/drop of memory table in mysql5.6
We have recently upgraded to mysql5.6.25 from mysql5.5.x/mysql5.1.x on our mysql-cluster.
Below is a brief snapshot of our architecture.
Since we have upgraded and enabled gtid-mode we have been ...
- 51
2
votes
1
answer
3k
views
MySQL 5.6 Slaves Fail to Reconnect to older MySQL server when it goes down for backups
I have an existing replication setup with Masters and Slaves running MySQL 5.0. A long existing script runs at night which restarts MySQL on the master with skip-networking, runs a backup, and then ...
- 35
1
vote
1
answer
1k
views
Upgrading mysql percona server from 5.5.40 to 5.6.71
2014-12-26 05:18:20 13215 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2014-12-26 05:18:20 13215 [ERROR] Native table '...
- 59
1
vote
0
answers
351
views
How to upgrade MySQL 5.0 to 5.5 with master-master replication?
I have to update 2 hosts with SUSE Linux Enterprise 11 from SP2 to SP3 which implies an update from MySQL 5.0.94 to 5.5.31.
The release notes state:
SLE 11 SP3 introduces the upgrade of the MySQL ...
- 11
1
vote
0
answers
279
views
Best practice for upgrading MySQL on a master-master setup
Anyone have experience upgrading a master-master setup of MySQL 5.1 to a release version of MySQL while trying to keep at least one server online (in my case we are upgrading to MariaDB 5.5).
- 11
0
votes
1
answer
566
views
Is it possible to upgrade mongodb cluster without upgrading arbiters?
Is it possible to have running real nodes with version 2.4 and arbiter nodes with 2.0 or 1.8 in the replica set?
Upgrade guides for version 2.2 and 2.4, did not tell anything about upgrading arbiters....
- 375
1
vote
1
answer
1k
views
replication breaks after upgrading master
I have a set up of replication with master 5.1.30 and slave 5.5.16
and the replication is working good
Now i have upgraded mysql master to 5.1.47
As far as i know we have to turn off the log bin ...
- 191