Which mysql package is the best ?
Traccar only needs database.
Hello Anton,
Mysql ? Which version ? Can you propose the best one ?
Latest stable one.
Is Mysql really better than the H2 database ?
By the way, can i use a database which are not int the same server ? I have tracar on a vps but i have another host somewhere, will it be great in term of perf ?
Last question, i guess my line will be :
<entry key='database.url'>jdbc:mysql://[IP ADRESS OF THE OUTSIDE SERVER]:3306/[DATABASE]?allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=U
Right ?
MySQL is definitely better than H2 database. Please don't use H2 for production. It's only intended for testing and evaluation purposes.
You can have database on a different server, but then there is a risk of connection issues between two.
Correct. Make sure that uses has permissions to connect remotely and database is configured for remote access as well.
Thx, i just installed WAMP package.
It seems to work but im worry about this :
As you can see type is MyISAM but in the mysql config i have write INNODB in engine storage.
Is this wrong ?
It is wrong. You need to have InnoDB as default engine before Traccar creates its tables.
Thx it's done and perfect :)
Last request, in this topic : https://www.traccar.org/forums/forum/server/page/2/
I have my ip adress, can you remove it ? I can't edit my posts (there are more than one in the topic and in the picture)
Here : https://www.traccar.org/forums/topic/help-about-using-an-emulator-or-a-phone-device/
I think you should be able to edit your posts.
Well i don't see how, where is the "edit button" :
OK, please give me links to the posts that you want to edit and exactly what you want to remove.
Here #15061REPLY :
https://www.traccar.org/forums/topic/help-about-using-an-emulator-or-a-phone-device/
(check the picture to know what to delete)
Removed.
Thx a lot for your help, god bless you !
Hello,
I would like an advice about which mysql package do you use ? During the past when i made some website i used "wamp" package. Notheless i guess i wont use whole wamp package this time.
What is the easy and best one to use with traccar server ? I know that i need to useInnoDB but any other advice will be greatly appreciated