We have an embedded Linux device running a MySQL instance and we have periodic updates for the system where all software, the entire system image, will be replaced on a reboot, but any previously written data stays intact. At some point we may decide that there is one thing or another incorrect in the schema for the database and decide a modification is in order. Given that there is an update service that runs on bootup after the image is replaced, but before the MySQL instance starts up, how could we make updates to the schema in a reliable and manageable way that does not require manual intervention and keeps the schema in line with the version of software on new images. For instance, some devices might be offline for a long time and not receive intermediate updates with schema changes, but will download the latest system image always. How can you version the schema and keep devices consistent with the latest version?
Updating MySQL database schema on update
179 Views Asked by LavaHot At
0
There are 0 best solutions below
Related Questions in MYSQL
- How to Retrieve Data from an MySQL Database and Display it in a GUI?
- How to change woocomerce or full wordpress currency with value from USD to AUD
- window.location.href redirects but is causing problems on the webpage
- Error: local variable 'bramka' referenced before assignment
- Products aren't displayed after fetching data from mysql db (node.js & express)
- status table for all entries (even in different dates) in database changing value when all checkboxes are checked
- Can't Fix Mariadb & Mysql ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2) On MacOs
- Express Mysql getting max ID from table not working cought in a promise
- failed to upload a table from sql file
- Update a MySQL row depending on the ID in Google Sheets Apps Script
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- How to display the column names which have only unique non-null values in MySQL table?
- mysql query takes too long because of wrong indexes usage
- Multitable joining in Sql
Related Questions in EMBEDDED
- MSP430F5529 on the MSPEXP430F5529LP: UART is not actually transmitting despite seemingly correct setup. What is wrong?
- A FPGA Project Proposal where I can use both PS and PL
- Program doesn't run after DFU
- Sending struct through queue
- How to generate a VPI warpmap for polynomial distortion correction?
- How to present this example concept in UML: Using 2 LCD displays in C/C++
- CLion: Debug via St-Link
- Portenta H7 Baremetal Development and a Little Guidance on Embedded System Learning Roadmap
- STM32 RTC3 Mixed Mode: Writing TR resets SSR
- Unable to read value from gpio set as input
- Mbed TLS: in-place en-/decryption for OAEP doesn't seem to work
- Shared variable read from low priority thread in preemptive scheduling
- Own Pattern / framework for interfacing with components in C
- Performance Difference Between Global Variable and Local Variable in Embedded Systems
- Comparing analog signal from Electret mic with samples
Related Questions in SCHEMA
- Should Organization schema be on every page?
- How to save multiple string inside an array column in MongoDB
- How does Big Query differentiate between a day and month when we upload any CSV or text file?
- Does the language used in schema need to match the HTML lang attribute?
- graphql-java extension type redefine error from version 15
- In SilverStripe/GraphQL 4 how do I get the bulkLoader auto generated schemas to allow has_many and many_many updates?
- How to validate URL param with AJV in Fastify?
- AJV ignores 'required' rule for properties in nested, referenced object
- Form validation with yup - how to strip a field after validating it?
- JSON Schema draft v4 - additional Properties error with anyOf
- FME - Specify schema name in PostgreSQL database writer (ArcSde)
- JSONLD Issue: Works via IP but Fails with Domain/Sub-domain IN next JS 14
- How to drop all views in cascade manner from a schema in HSQL database
- Spark Not Null constrains in combination with badrecordspath for reading (delta) tables
- "Schema hasn't been registered for model" Error in mongoose only while populating
Related Questions in UPGRADE
- Problem on upgrading Laravel 9 to Laravel 10
- Insight: Deprecated APIs removed in Kubernetes v1.29
- Upgraded C# MVC project EF 4.7.2 to .net Core 8.0
- Cannot upgrade to syncElegantOTA v3 in platformIO
- How to export Parties and Agreements from BizTalk Server 2013 R2?
- ModuleNotFoundError after upgrade
- getTypeName method when updating from Hibernate core v5 to v6
- Missing Private Key after updating Node
- How to change height and width in mat-form-field
- C# WPF Menu no longer works after upgrade project to SDK style
- Symfony AssertionError: assert($mapping instanceof ManyToManyOwningSideMapping)
- Service.startForeground() issue in Android 14
- Compatibility Problem after Update from Xamarin.Forms to .Net MAUI
- How to solve Jenkins 2.361.4 start with ProjectMatrixAuthorizationStrategy error?
- TYPO3 v11: upgrade to PHP8 breaks the page completely
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?