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
178 Views Asked by LavaHot At
0
There are 0 best solutions below
Related Questions in MYSQL
- MySQL Select Rank
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Push mysql database script to server using git
- Why does mysql stop using indexes when date ranges are added to the query?
- Google Maps API Re-size
- store numpy array in mysql
- Whats wrong with this query? Using ands
- MySQL-Auto increment
- show duplicate values subquery mysql
- Java Web Application Query Is Not Working
- microsoft odbc driver manager data source name not found and no default driver specified
- Setting foreign key in phpMyAdmin
- No responses from google places text search api
- Adding to MAMP database in SQL/PHP
- I want to remove certain parent- and child-divs in all my wordpress posts with php or some other script
Related Questions in EMBEDDED
- PHP don't use temp file for upload
- Sparkfun SC16IS750 does not work on Raspberry Pi
- Reserve memory space in m_text memory region of FLASH on embedded target
- SAE J1939 Standards Collection -- How much is necessary?
- How to call multiple slaves for Spi data transmission?
- Deployment over GPRS to embedded devices
- Changing just one byte in SD card sector
- Comparion of values won't work without delay
- Better to pass struct, or pointer to struct?
- STM32F4 Handling peripheral error while making a DMA Transfer (RX)
- USB programming, transfer file from iOS device to Embedded os device?
- using Diab, dcc 5.9.4 to compile a windows executable
- does b64_pton() work if input contains special characters? I am using it in C code
- u-boot select boot partition based on GPIO state
- Why is a write to a memory-mapped peripheral register not actioned (LPC43xx)?
Related Questions in SCHEMA
- Elasticsearch schema for multiple versions of the same text
- SQL Schema recommendations
- How does an LDAP Client eg Apache Directory Studio get schema from an LDAP Server?
- Looping functoid, Mapping
- No Synchronize Model with Database in Mysql Workbench
- XML Namespace URI with HTTPS?
- sqlite schema has quotes around table name after a table rename
- Group many postgresql databases into separate schemas into same database
- MongoDB: updating an array in array
- How to open an android application from browser
- Error when using JAXB to create JAva classes from XSD
- MongoDB data modeling issue
- Solr 5.1.0: How to set the unique key via Schema API
- Compare Array with Collection-Array containing Objects
- Updating MySQL database schema on update
Related Questions in UPGRADE
- Upgrade H2 from sonarqube 4.5.1 to 5.1.1
- Spring upgrade on-start equivalent
- MarkLogic 8 - After upgrade we are getting 405 Method Not Allowed on a GET
- after PHP upgrade - Cannot use object of type stdClass as array
- MarkLogic 8 - Rest Endpoint Returning XML even though we specify JSON
- Error when updating from Joomla 3.3.6 to 3.4.1
- How to find reason for StackOverflowException in System.Web.dll after upgrading an ASP.NET MVC 2 project?
- Error installing required packages in Yosemite
- Android upgrading sql database using android-sqlite-asset-helper
- Cannot upgrade gitlab from 7.9.4
- symfony upgrade from 2.3 to 2.7
- Upgrade from Sql server 2008 to Sql Server 2008 R2 didn't update running version
- Points to be looked into while upgrading from redis-2.8.19 to redis-3.0.2
- Drupal 7 not sending e-mail after upgrade
- Updating MySQL database schema on update
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 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?