2014-10-24, 14:31
I have a master client that updates my library.
I will shortly be experimenting with having another Raspberry PI (Gotham 13.2) accessing the library.
I plan to move the library db into MySQL and point both devices at it.
As it will be my neighbour next door watching the other unit, I do not wish to give them the ability to write back to the MySQL database.
If I make the DB readonly, will this cause major problems? Or can it work in this way?
Thanks
Note - the DB would be readonly ONLY for the other user, not for the master box which will have full write access (to actually update the library etc)
I will shortly be experimenting with having another Raspberry PI (Gotham 13.2) accessing the library.
I plan to move the library db into MySQL and point both devices at it.
As it will be my neighbour next door watching the other unit, I do not wish to give them the ability to write back to the MySQL database.
If I make the DB readonly, will this cause major problems? Or can it work in this way?
Thanks
Note - the DB would be readonly ONLY for the other user, not for the master box which will have full write access (to actually update the library etc)