Which mysql package is the best ?

xplane257 years ago

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

Anton Tananaev7 years ago

Traccar only needs database.

xplane257 years ago

Hello Anton,

Mysql ? Which version ? Can you propose the best one ?

Anton Tananaev7 years ago

Latest stable one.

xplane257 years ago

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 ?

Anton Tananaev7 years ago

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.

xplane257 years ago

Thx, i just installed WAMP package.

It seems to work but im worry about this :

omg

As you can see type is MyISAM but in the mysql config i have write INNODB in engine storage.

Is this wrong ?

Anton Tananaev7 years ago

It is wrong. You need to have InnoDB as default engine before Traccar creates its tables.

xplane257 years ago

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/

Anton Tananaev7 years ago

I think you should be able to edit your posts.

xplane257 years ago

Well i don't see how, where is the "edit button" :

http://img4.hostingpics.net/pics/820961Azaza.png

Anton Tananaev7 years ago

OK, please give me links to the posts that you want to edit and exactly what you want to remove.

xplane257 years ago

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)

aaaaaa
Anton Tananaev7 years ago

Removed.

xplane257 years ago

Thx a lot for your help, god bless you !